Zeoslib Portal

I am doing some updates and repairs on some old D5 business stuff (freebie for fiend) with SQLite3 so have to use Zeos 6.6 I would like to speed up a text search which currently uses two BLOB_TEXT Fields, "Class" and "Methods" while not(dm.tbl.EOF) do begin SearchData:=dm.tbl.Fie...

Awesome, thanks. Had not thought of trying that, must be getting older than I thought.

I am doing some updates on some old D5 stuff with SQLite3 so have to use Zeos 6. This is not working as expected. ..Click Next until the Last File is in use. ....Click Next again and it displays the Last File again. // Surely it should have be at the last File after the Last Next?? ......Click Next ...

Hi All, I have been trying Lazarus and reluctantly I have had to return to D5 for a lot of reasons. This means using ZeosLib 6.6 and it is missing a few treats of 7.2. Namely the ZConnection.LibraryLocation for SQLite's sqlite3.dll and I am unable to activate the Connection at design time. I have de...

On the right hand side you will find an otion "Unit output directory (-FU)". Hi Jan, thanks for that. I have decided to go back to Delphi-5 as Lazarus is just too unpolished. I keep running into obstacles when doing more technical stuff and Lazarus/FPC falls short. I am forever trying to ...

I changed the unit output path (-FU) to a separate path per package: lib\zcore\$(TargetCPU)-$(TargetOS) lib\zparsesql\$(TargetCPU)-$(TargetOS) lib\zplain\$(TargetCPU)-$(TargetOS) lib\zdbc\$(TargetCPU)-$(TargetOS) lib\zcomponent\$(TargetCPU)-$(TargetOS) Jan, where exactly are you making these change...

Don't the !!!duplicate!!! errors tell you Hmm, nice. I am NOT an idiot. At the risk if duplicating Posts here, (and getting yelled at for doing that) when I made the above statement, I then posted to the 7.1 stable forum with a link to this thread as discovered that the 7.1 version ALSO does the sa...

Hi, I am having this problem reported in the beta forum. http://zeoslib.sourceforge.net/viewtopic.php?f=40&t=33408 I installed 7.1 first and got the problem so tried 7.2. Same issue, 172 Zeos specific warnings. I deleted all of the problem files, but next compile, same issue. Current versions of...

Me too and not just 7.2, it does it with "stable" 7.1.

Any fix or work around?

Thanks, thought I would ask here first, but decided to handle the issue myself before Post. More coding, but more control. I guess I was being lazy.

Squlite and I have two constraints, UNIQUE and CHECK RANGE.

Is there any way to get an error number for the specific error when using try/except/end.

All I get is "SQL Error: Constraint failed" and I'd like to let the user know specifically, what just went wrong.

Hi, I am looking for a way to see if there have been data changes to save wasting time over-writing a basically duplicate file for backup. I tried using FileAge(FName) but it appears that Zeos 6.6 writes stuff to the file whether data was changed or not so that's no help. I checked the SQLIte wiki a...

Michael, thanks for the quick reply, but this is what I did and it doesn't help. In unit ZAbstractRODataset; {** Options for dataset. } TZDatasetOption = (doOemTranslate, doCalcDefaults, doAlwaysDetailResync, doSmartOpen, doDontSortOnPost); But the doDontSortOnPost does not show up in the property e...

Hi All, I have an irritating issue with Delphi, SQLite, Zeos and a DBGrid. If I have a database of say 300 items and the DBGrid had that has 7 visible rows. I have an OnCellClick event that toggles a Boolean. tblShop.Edit; tblShop.FieldByName('Active').AsBoolean:=not(tblShop.FieldByName('Active').As...

Hi All, I have to use Zeos 6.6. as I am still on Delphi 5 and am getting this error when opening a database. In the IDE it works fine. Running the program directly form the development folder it works fine. But - if I make a copy of the program, the sqlite.dll and the database in another folder, I g...