[SOLVED] Jump to BOF, the first record in a table?

[1HuntnMan]

Searching thru several docs for Laz/FPC and can't find an example for jumping to the first record or beginning of file.  Here's an example of BoF for a dBase table:

DbfClients.BOF which is boolean but that context won't compile. I tried DbfClients.BOF:= True and I tried   DbfContacts.DataSource.DataSet.BOF, etc.

Is there a way to jump to the first record or rather, refresh the DBGrid after changing the index.

I reindexed the table and the DBGrid started behaving properly but still would like to force BoF or EoF.

 

[lainz]

Hi, I usually use

Code: Pascal  [Select][+][-]

1. .first();

Edit:

As well

Code: Pascal  [Select][+][-]

1. .last();

[dsiders]

Searching thru several docs for Laz/FPC and can't find an example for jumping to the first record or beginning of file.  Here's an example of BoF for a dBase table:

DbfClients.BOF which is boolean but that context won't compile. I tried DbfClients.BOF:= True and I tried   DbfContacts.DataSource.DataSet.BOF, etc.

Is there a way to jump to the first record or rather, refresh the DBGrid after changing the index.

I reindexed the table and the DBGrid started behaving properly but still would like to force BoF or EoF.

TDataset.First
https://lazarus-ccr.sourceforge.io/docs/fcl/db/tdataset.first.html

TDataset.Last
https://lazarus-ccr.sourceforge.io/docs/fcl/db/tdataset.last.html

[1HuntnMan]

Thanks all, got in my personal Laz doc. Seems like I used to use BoF and EoF in Delphi long time ago for Last and First but can't remember.

[Thaddy]

Thanks all, got in my personal Laz doc. Seems like I used to use BoF and EoF in Delphi long time ago but can't remember.

Both are still supported by FreePascal, but refer to type File of <untyped, text or record>, way before TDataset and still work if you want to write a database  from scratch.

[dseligo]

Thanks all, got in my personal Laz doc. Seems like I used to use BoF and EoF in Delphi long time ago for Last and First but can't remember.

BOF and EOF exists, but they are read-only properties - you can test them to know if you are at the beginning or at the end of table (dataset).