TOPIC:

Testing SqLite with ZeosDb when i active connect design time send me this error, i read diferents topics of that a fallow the steps but don't get fixed, still the problem with another databases or is only with sqlite.


Best regards.
Fernando Sandoval

Same problem (4.8). I installed 4.7 back - it works fine.

Can anyone try CT LAB ver 4.90 ?

Check this sample just when connect send error.

Thanks for your support.

Well this is my sample I using lazarus and visual planit, but i dont can add a task.


tahnks for your support.

I had a problem with parameters and sqlite and CT 4.8 because even if I correctly set param (ParamByName) it stays null and when I look at back-trace I see ZeosLib tries to use R/O dataset and messes something with pointers, I tried to fix it myself but without success. When you rewrite a sql statement using a bunch of '' for strings or QuoteStr, everything works ok.

But this is not the only problem with ZeosLib, when I use postgres a lot of weird stuff happens because when I use select with natural join on two tables then columns from second table (the inner join one and in different schema) are not accessible I believe there is something wrong with schema handling.

Forgive me for my ignorance, but where can I find CT 4.9 with fresh ZeosLib?

And please move this topic to DB related!

Go to CodeTyphon Center , Update Manager, Lab Development version, Check for updates, Start update.

ZConnection1.TestMode: Unknown property: "TestMode" with CT 4.90, after adding {$DEFINE ZEOS_TEST_ONLY } compiled OK but problems with sqlite and postgres are same.

By the way, version 4.6 also had a problem with ZEOS + SQLite, but in version 4.7 everything was working correctly.

Sir
CT 4.7 has Zeos 7.1.2 and
CT 4.8 has Zeos 7.2.0

Please, post to ZEOS forum zeoslib.sourceforge.net/ for any problem
we follow ZEOS SVN trunk ...

I try with 4.9 and is the same problem,

I dont know if attach file it is dont uploaded only moredator can publishing file.

Will do, I think that DB layer and Report layer are only big problems with CT environment , so we must be patient and persistent in those.

Hi Sirs,

the current trunk follows my code refactoring i do for ZeosDB. Current target -> best perfroamce. (Actual state is pretty cool)
Such refactoring includes possible bugs, i can't see.

It would be nice is you're opening a ticket in sourceforge.net/p/zeoslib/tickets/ with an reproducable app. Than we can help you.
Please keep track you're using latest \testing-7.2 (SVN) upgrades to get rid the bug isn't already fixed.

Also are coders wanted to add tests to our suites just if you don't feel able to code in Zeos.. Help is welcome.

Cheers, Michael