Zeoslib Portal

Okay, i merged this function to an extern application.

Is there a way to get the Insert ID (primary key) after exec an INSERT INTO Query in a ZQuery component?

Greetings
Schaelle


Edit: Okay, i have search specifical for Delphi and have nothing found, after search for SQLIte i have found "SELECT last_insert_rowid()". Done.

Working now. But with another code, i think there wer some erros in the SQL Query. Now i use ParamByName and so to avoid errors.

Hello, im working on a small application that used ZeosLib and a SQLite database. Currently i want to code a "database import" function, to overwrite the active SQLite database i must disconnect it from the connection. Only use ZConnection.Disconnect or set ZConnection.Connected to false i...

Hello, i have installed ZeosLib like in the QuickStart guide, placing some Zeos components and running the application work fine. But now i have placed a ZConnection in the designer with the following settings: object ZConnection: TZConnection Protocol = 'sqlite-3' Database = '.\db.s3db' Catalog = '...

Hello, I'm using SQLite Admin for adminstrate some database that I use while programming in Free Pascal under Lazarus using the TSQLite3DataSet. The problem the named DataSet using another format of SQLite Databases for Boolean and Date values: Boolean: 1/0 Date: Double (TDateTime format) (see Delph...