Database A little request !

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

[Kiffi]

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

[thyphoon]

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