SQLite
BlitzMax Forums/BlitzMax Programming/SQLite
| ||
I have a database. The sample from the module shows me the main entry's.Import BaH.DBSQLite Import BRL.filesystem Local db:TDBConnection = LoadDatabase("SQLITE", "lavrc.db") If Not db Then DebugLog("Didn't work...") End End If If db.hasError() Then errorAndClose(db) End If If db.isOpen() Then ' get a list of tables in the database Local list:String[] = db.getTables() If list Then For Local i:Int = 0 Until list.length Print" " + (i + 1) + ". " + list[i] Next End If db.close() End If Function errorAndClose(db:TDBConnection) Print db.error().toString() db.close() End End Function How can i access the entry's of each main entry? Has anybody an sample! |
| ||
You want to do a query in the database? if so, this is how you do it.. [bbcode] Local query:TDatabaseQuery = TDatabaseQuery.Create(db) Local q:String = "SELECT * FROM YourTableName" query.execute(q) While query.nextRow() Local record:TQueryRecord = query.rowRecord() Local id:Int = record.value(0).getInt() Local firstName:String = record.value(1).getString() Local LastName:String = record.value(2).getString() 'etc... Wend [/bbcode] Last edited 2012 |
| ||
Thanx, that works! |