Zeoslib Portal

..and I take it you've tried your fair share of googling? For example I found this:
http://wiki.lazarus.freepascal.org/Zeos_tutorial

nope

Ummm, double-check that you've chosen the right protocol on your TZConnection ???

I should add that I'm only guessing - I use ZeosLib with Firebird - but some of the principals in connecting are the same.

My customer says he has over 2,000 contacts in his contacts table. Is there a way in Delphi to tell the TZtable to only read a few hundred records at a time to display in the DBGrid, and when the user scrolls down it will ask the TZTable to read the next few hundred?

I think the relevant library has to be in your working directory - the directory where your application is running from - or in the system32 or system folder or wherever - so check what happens if you put libsqlite.so in your folder.

I have spent the past 5 days on and off trying my best to find out why my application isn't working since I changed to FireBird and Zeos. Because my application has a 3rd party set of components it was a lot of code to read through and a lot of testing to try and find the problem. I wasn't getting a...

Thank you I will still have to test this on a "virgin" machine. Thanks for the help as always

Hi Seawolf. Thanks for your answer. Yes I already have changed it to length 5 and replaced all the 'Y' with 'True' and all the 'N' with 'False. This worked fine (and took me hours and hours to do) until I realised that one section of my application now doesn't work because I don't have proper boolea...

Thanks so much seawolf. Becauase this was urgent I just went through all my fields with # in them and took out the '#' (this did unfortunately still take me a long time to do and your fix would have been much easier). Hopefully others will benefit from this in the future!

I am running Firebird 2.1. I have a table with a field "ESTIMATEITEM#" - everything is working fine but if I specifically call .REFRESH it generates an error "Project XXX raised exception class EDatabaseError with message 'TABLE: Field 'ESTIMATEITEM' not found'. As you can see it is c...

Okay so I can please confirm - if the DLL is inside the same directory as the EXE it will see it?

In the installation instructions it says: Copy the required dlls for your database client to the windows system directory (usually Windows\ System or winnt\system32) or use the database client installer. and so I went to my Firebird install directory, and copied and pasted "fbclient.dll" i...

As you know Firebird doesn't have a BOOLEAN field type. Their "solution" is to create a domain of type CHAR, with length 1, with values "Y" or "N". But this only causes me problems in Delphi. 1) Does TZTable have a nice way of solving this problem so that the field is r...

Be sure to set the correct protocol on your ZConnection component because that gave me the same error when I started using ZEOS components (which was... yesterday)