Showing the last database entry in an label

[Fox]

hello guys how can i show the last database entry in an label? is this possible if yes how?

 

[eps]

Define last...

Do you mean the last record created in a table? Usually this is done via a key identifier, ie the highest number or create date...

 

[Fox]

Define last...

Do you mean the last record created in a table? Usually this is done via a key identifier, ie the highest number or create date...

no i mean the last record that was created if i have an database an the last record of 1 colum that was created that i mean...

 

[eps]

Surely it will have a primary key, just select the one with the highest primary key..

 

[Fox]

Surely it will have a primary key, just select the one with the highest primary key..

hmmm i have try to get it with SQL Last but not with success...

 

[eps]

Use max pk

 

[Fox]

ok this not works at me is there no other solution like sql last?

 

[Erel]

You can find the internal row id of the last row with this query:
[FONT=Courier, Monospaced]SELECT last_insert_rowid()

You will then need to do another query where rowid = the previous result.
[/FONT]

 

[klaus]

Be careful
SELECT last_insert_rowid()

works only when the database is initialized.
If you start the program and read a database and run SELECT last_insert_rowid() then you get 0.
Then after having added an entry and you call SELECT last_insert_rowid() then you get the right value.
If you have a column with the type of INTEGER PRIMARY KEY you can get the max value of this column with SELECT max(RowID) FROM DBTableName

Best regards.

 

[AscySoft]

hello

I know this is a little late posting... but for anyone else who's searching for this, check the documentation of this function Last Insert Rowid
See ya!