Update field with incrementing numbers

[crystalhelio]

Hi,
I've a stupid question. i know this should be easy, but I can't figure it out. Please help.

I am using Dbase 4. I would like to run a query/macro to increment (i.e number it from 1.....100, if there are 100 records) the records in a field like we do in worksheet. Any idea?

Thanks
Ann

 

[dgrewe]

My trick is in the query to create a extra numberic field
and into table sqltable
next line after the query is
select sqltable
replace all extrafield with recno()



David W. Grewe (Dave)

 

[crystalhelio]

Thanks David. But my problem ( I am sorry I didn't explain right) is aggravated as I resorted the data based on 2 other fields and now I want to renumber this sort order starting from 1 to 16760 in a sequential ascending order.

Any thoughts?

Thanks again
Ann

 

[dgrewe]

Add the extrafield in the sort as above.
after the SQL Statement

use SQLTABLE
lnCount=0
scan all
lnCount=lnCount+1
Replace EXTRAFIELD with lnCount
endscan


David W. Grewe (Dave)