Showing the last database entry in an label

eps

Expert

Licensed User

Longtime User

• Aug 1, 2011

• #2

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

 

Upvote 0

F

Fox

Active Member

Licensed User

Longtime User

• Aug 1, 2011

• #3

eps said:

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

Click to expand...

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

 

Upvote 0

eps

Expert

Licensed User

Longtime User

• Aug 1, 2011

• #4

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

 

Upvote 0

F

Fox

Active Member

Licensed User

Longtime User

• Aug 1, 2011

• #5

eps said:

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

Click to expand...

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

 

Upvote 0

eps

Expert

Licensed User

Longtime User

• Aug 1, 2011

• #6

Use max pk

 

Upvote 0

F

Fox

Active Member

Licensed User

Longtime User

• Aug 2, 2011

• #7

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

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Aug 2, 2011

• #8

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]

 

Upvote 0

klaus

Expert

Licensed User

Longtime User

• Aug 2, 2011

• #9

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.

 

Last edited: Aug 2, 2011

Upvote 0

AscySoft

Active Member

Licensed User

Longtime User

• Aug 12, 2011

• #10

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!

 

Upvote 0