Last ID in a file...

Hi guys,

Another basic newbie question:

If a have an auto ID (unique key) in a file, what's the best way to find what the highest/last ID is?

I tried HSeekLast, but what "Sought Value" do you use? I don't want a sought value... I just want the last ID in the file using the ID index - why do you need a sought value? :confused:

Cheers...

Hello Darren

The HreadSeekLast will return the last ID of the nominated index so you have to nominate which index it should use. The AutoID feature is not a record number it is a generated number and may be different from the last physical record number.

If you have an index on surname then HreadSeekLast(MyFile,SurnameIndex) will return the alphabetic last name "ZOOLANDER" - maybe

So when you want the last AutoID number used then you must specify its index name
HreadSeekLast(MyFile,AutoIDKeyIndex)

Regards
Al

Darren,

Just use Hreadlast(Filename)

it will point directly to the last record in the file.




Edited 1 time(s). Last edit at 11/11/2008 08:08AM by Carlo Hermus.

Thanks guys... I'll try your suggestions later... :spos: