Bring last and first record

[Leite33]

Hi
How i can bring the last record and the first record of database and bring the result on Edit Box. I use BCB6 enviroment. Di i have to make Query? Any code ideas?

[greg_dolley]

Hi
How i can bring the last record and the first record of database and bring the result on Edit Box. I use BCB6 enviroment. Di i have to make Query? Any code ideas?

Yeah, you'll have to use a query, such as:

"SELECT * FROM table"

If you're using ADO, then you can call MoveFirst() and MoveLast() to get the first and last record of the query.

Greg Dolley

[Leite33]

thanks. Good idea