Page 1 of 1

LastDatabaseRow - SeekDatabaseRow

Posted: Mon Aug 30, 2004 6:44 pm
by downi
Is it possible to build this two commands into Purebasic:

LastDatabaseRow --> acces to last register in one table.

SeekDatabaseRow --> acces to one especific register in one table.

according to this link:
viewtopic.php?t=2779

The Database lib of PB has FirstDatabaseRow(), NextDatabaseRow() and PreviousDatabaseRow() but why not a LastDatabaseRow? 8O

Posted: Mon Aug 30, 2004 7:01 pm
by Manolo
Hehehe...
My old request...
Manolo

LastDatabaseRow

Posted: Mon Aug 30, 2004 7:18 pm
by downi
Old, but not solved! :lol:

The LastDatabaseRow()-Function is really important for me and there is no solution for me to build a program in PB that I need urgently.

Maybe in PB 4.0?

Posted: Tue Aug 31, 2004 7:17 pm
by ABBKlaus
Hi,

i agree with that :roll:

using an agregate function is not really the best way :?

Code: Select all

Select LAST(column)

Returns the value of the last record in the specified field (not supported in SQLServer2K)
http://www.w3schools.com/sql/sql_functions.asp

Posted: Fri Aug 31, 2007 11:48 am
by downi
push

3 Years later now :-(

Is it possible to build this two commands into Purebasic:

LastDatabaseRow --> access to last register in one table.

SeekDatabaseRow --> access to one specific register in one table.