Zeoslib Portal

Hello

Since Aducom's static version is no longer maintained, I'm looking for an alternative that lets me compile SQLite into a Delphi application statically so I can just distribute a single EXE, with no dependency.

Does ZeosLib require sqlite3.dll?

Thank you.

Hello I read the PDF to install the latest ZeosLib into Delphi 2007, and have a couple of questions: 1. The PDF mentions "ZeosDbo.groupproj", but not "ZeosDboDev.groupproj" and "ZPlain.bdsproj": What are those two project files for? 2. The PDF says that after compiling ...

Hello I'm told that to it's possible to make changes to a dataset in Delphi using either TZQuery (which I thought could only SELECT data) or TZUpdateSQL. I find using the same component (TZQuery) to read and write data more natural than relying on a second component, so could someone tell me in whic...

Hello I'm reading "The Firebird Book" and am trying to build a very basic Delphi application to connect to a Firebird server. I was wondering: Is there a smarter, easier way to run queries like this? With ZQuery1 do begin Connection := ZConnection1; Sql.Clear; //How to check if a table alr...

Thanks a lot Mark. I'm still getting an error with INSERT, but it looks like it's a Firebird issue, not ZeosLib so I'll resume reading "The Firebird Book" to learn more: Project Project1.exe raised exception class EZSQLException with message 'SQL Error: validation error for column ID, valu...

Thanks for the help. I have a couple of questions: 1. Why is it wrong to disconnect in the same event, even after I'm done with SQL? 2. I get an error when INSERTing a record: Instead of seeing "John Doe", I get a question mark: http://pastebin.ca/1434841 3. The next steps are to allow a u...

At this point, I was able to create a database file, create a table within, but fail INSERTing a record and read it back: procedure TForm1.FormCreate(Sender: TObject); var MyDB,MyUSER,MyPASSWORD : String; begin MyDB := 'C:\test.firebird'; MyUSER := 'SYSDBA'; MyPASSWORD := 'masterkey'; With ZConnecti...

Hello I think I managed to successfully compile and install ZeosLib 6.6.4 in Delphi 2007. I'm having a bit of difficulty, however, getting started even with "examples\simple\ZSimpleMain.pas" because it uses a lot of extra stuff (TZSQLMonitor, TZSequence, properties, etc.), and am stuck at ...

Thanks

I just got a little further, but I'm getting two errors (Firebird 2.1.2, ZeosLib 6.6.4): 1. The Firebird installer provides FBCLIENT.DLL, but ZeosLib expects either FBCLIENT20.DLL or FBCLIENTD.DLL. I copied FBCLIENT.DLL as FBCLIENTD.DLL, and ZeosLib seemed happy, but... 2. ... when I reran the progr...

Hello I'm not a Delphi expert, and am having a bit of difficulty going through even the simplest of the samples "examples\simple\ZSimpleMain.pas", as it uses things like ZSQLMonitor and ZSequence that I haven't seen before, uses uses Properties instead of accessing data directly, etc. By a...

Yup, I'll just write an installer to install the EXE and the Firebird client DLL's. BTW, does someone have a very simple tutorial on how to get started with the DBGrid component, ZeosLib, and FireBird? I just need something that would show me how to connect to the server, send a SELECT, and watch th...

I can compile OK if I leave zeos.inc alone, but it fails if I comment out DBMS I don't need (MySQL, PostgreSQL, etc.) and only keep Firebird: ZInterbaseToken.pas(61): F1026 File not found: 'ZPostgreSqlToken.dcu' //This line: uses Classes, ZTokenizer, ZGenericSqlToken, ZPostgreSqlToken; BTW, unless I...

I removed the whole directory, redownloaded the Stable version, didn't edit src\zeos.inc: ZCore and ZParseSQL compile OK, but I get errors when compiling Zplain: [DCC Error] ZPlainPostgreSqlDriver.pas(1005): E2010 Incompatible types: 'AnsiChar' and 'Char' [DCC Error] ZPlainPostgreSqlDriver.pas(1018)...

Hello I'm a Delphi newbie and am trying to install ZeosLib in Delphi2009 for the time to try to connect to a Firebird server. I followed gto's Zeos Quick Start Guide , ie. unzip, add the root of Zeos directory + packages\delphi11\build, and compile. After editing src\Zeos.inc to just compile for Fir...