zeos

Unicode filenames with zeos / sqlite

Hi, I need to save data in sqlite databases with user-chosen filenames. This includes unicode filenames. Is there a way to specify this in the Zeos components in Delphi? ...

BDS2006 and Zeos installation

Hi all, I recently installed Zeos 6.6 stable on BDS2006 for both the Delphi and C++ personalities. In order to do so, and since Zeos is written in Delphi, I checked the "Generate all C++ Builder files" when building the packages. The problem I found was that, somehow, not all necessary .DCUs were generated during the building of the...

Database connectivity Delphi

I'm using delphi for years, but never for database stuff, but recently started researching and testing. I must say, i'm impressed, most of things happens automatically, i'm used to write by hand in php and python. i'm going to develop a commercial system for a friend, (2 layers) 5 user computers, 1 database server. Database server wi...

Delphi: how to create Firebird database programmatically

I'm using D2K9, Zeos 7Alpha, and Firebird 2.1 I had this working before I added the autoinc field. Although I'm not sure I was doing it 100% correctly. I don' know what order to do the SQL code, with the triggers, Generators, etc.. I've tried several combinations, I'm guessing I'm doing something wrong other than just that for this not ...

Firebird Insert Distinct Data Using ZeosLib and Delphi

I'm using Zeos 7, and Delphi 2009 and want to check to see if a value is already in the database under a specific field before I post the data to the database. Example: Field Keyword Values of Cheese, Mouse, Trap tblkeywordKEYWORD.Value = Cheese What is wrong with the following? And is there a better way? zQueryKeyword.SQL.Add('IF...