Page 1 of 1
Database A little request !
Posted: Thu Jan 03, 2008 5:36 pm
by thyphoon
I think add DatabaseLastInsertRowId() function will be great !
Netmaestro give a good alternative solution for sqlite3
Code: Select all
ImportC "sqlite3.lib"
sqlite3_last_insert_rowid(hDB.l)
EndImport
But it will be better if an integreate function will existe!
Ps:excuse my bad english !
Re: Database A little request !
Posted: Thu Jan 03, 2008 6:37 pm
by Kiffi
thyphoon wrote:I think add DatabaseLastInsertRowId() function will be great !
Netmaestro give a good alternative solution for sqlite3
here is another one without using ImportC:
Code: Select all
Procedure DatabaseLastInsertRowId(hDB)
DatabaseQuery(hDB, "Select last_insert_rowid()")
NextDatabaseRow(hDB)
ProcedureReturn GetDatabaseLong(hDB, 0)
EndProcedure
Greetings ... Kiffi
Re: Database A little request !
Posted: Thu Jan 03, 2008 9:44 pm
by thyphoon
Kiffi wrote:thyphoon wrote:I think add DatabaseLastInsertRowId() function will be great !
Netmaestro give a good alternative solution for sqlite3
here is another one without using ImportC:
Code: Select all
Procedure DatabaseLastInsertRowId(hDB)
DatabaseQuery(hDB, "Select last_insert_rowid()")
NextDatabaseRow(hDB)
ProcedureReturn GetDatabaseLong(hDB, 0)
EndProcedure
Greetings ... Kiffi
Thanks it's great !!
