LastDatabaseRow - SeekDatabaseRow

[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

[Manolo]

Hehehe...
My old request...
Manolo

[downi]

Old, but not solved!

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?

[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

[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.