Android Question RDC how read Last Insert Row from table

[Lello1964]

Hello again,

i want kwow if it's possible use command like "SELECT last_insert_rowid() from ARTICOLI"
i have tryed setting a new command :
sql.num_record=SELECT last_insert_rowid() from ARTICOLI

in config.propetries in RDC but doesn't work.

May i have more information about RDC commands ?

Thanks

Raffaele

 

[Erel]

RDC doesn't do anything special with the commands. It just passes them to the database engine.

Are you using a SQLite database?

 

[Lello1964]

Hello Erel,

Yes i'm using Sqlite.

Connection work, i can read from Pc, but have how read Last insert row from table ?

 

[mangojack]

is this of any use ..

'now get id of last inserted row
Dim lastID as Int    
lastID = SQL1.ExecQuerySingleResult("SELECT MAX(ID) FROM ARTICOLI")

Cheers mj

 

[Lello1964]

thanks mj