Welcome, Guest
Username: Password: Remember me
Components and Libraries for Database Development, discussions, problems and suggestions
  • Page:
  • 1

TOPIC:

ZeosDb 7.2 SQLLite Access Violation CT. 4.8 10 years 1 month ago #5423

  • eldonfsr14
  • eldonfsr14's Avatar Topic Author
  • Visitor
  • Visitor
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

Please Log in or Create an account to join the conversation.

ZeosDb 7.2 SQLLite Access Violation CT. 4.8 10 years 1 month ago #5425

  • ekir
  • ekir's Avatar
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 33
  • Thank you received: 6
Same problem (4.8). I installed 4.7 back - it works fine.

Please Log in or Create an account to join the conversation.

ZeosDb 7.2 SQLLite Access Violation CT. 4.8 10 years 1 month ago #5426

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
  • Posts: 4518
  • Thank you received: 1102
Can anyone try CT LAB ver 4.90 ?
PilotLogic Architect and Core Programmer

Please Log in or Create an account to join the conversation.

Last edit: by Sternas Stefanos.

ZeosDb 7.2 SQLLite Access Violation CT. 4.8 10 years 1 month ago #5427

  • eldonfsr14
  • eldonfsr14's Avatar Topic Author
  • Visitor
  • Visitor
Check this sample just when connect send error.

Thanks for your support.

Please Log in or Create an account to join the conversation.

ZeosDb 7.2 SQLLite Access Violation CT. 4.8 10 years 1 month ago #5428

  • eldonfsr14
  • eldonfsr14's Avatar Topic Author
  • Visitor
  • Visitor
Well this is my sample I using lazarus and visual planit, but i dont can add a task.


tahnks for your support.

Please Log in or Create an account to join the conversation.

ZeosDb 7.2 SQLLite Access Violation CT. 4.8 10 years 1 month ago #5430

  • Vladimir Bazović
  • Vladimir Bazović's Avatar
  • Offline
  • New Member
  • New Member
  • Posts: 7
  • Thank you received: 4
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?

Please Log in or Create an account to join the conversation.

ZeosDb 7.2 SQLLite Access Violation CT. 4.8 10 years 1 month ago #5431

  • Vladimir Bazović
  • Vladimir Bazović's Avatar
  • Offline
  • New Member
  • New Member
  • Posts: 7
  • Thank you received: 4
And please move this topic to DB related!

Please Log in or Create an account to join the conversation.

ZeosDb 7.2 SQLLite Access Violation CT. 4.8 10 years 1 month ago #5432

  • Miquel Matas
  • Miquel Matas's Avatar
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 121
  • Thank you received: 10
Go to CodeTyphon Center , Update Manager, Lab Development version, Check for updates, Start update. ;)
The following user(s) said Thank You: Vladimir Bazović

Please Log in or Create an account to join the conversation.

ZeosDb 7.2 SQLLite Access Violation CT. 4.8 10 years 1 month ago #5433

  • Vladimir Bazović
  • Vladimir Bazović's Avatar
  • Offline
  • New Member
  • New Member
  • Posts: 7
  • Thank you received: 4
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.

Please Log in or Create an account to join the conversation.

Last edit: by Vladimir Bazović. Reason: additional info

ZeosDb 7.2 SQLLite Access Violation CT. 4.8 10 years 1 month ago #5434

  • ekir
  • ekir's Avatar
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 33
  • Thank you received: 6
By the way, version 4.6 also had a problem with ZEOS + SQLite, but in version 4.7 everything was working correctly.

Please Log in or Create an account to join the conversation.

ZeosDb 7.2 SQLLite Access Violation CT. 4.8 10 years 1 month ago #5435

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
  • Posts: 4518
  • Thank you received: 1102
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 ...
PilotLogic Architect and Core Programmer

Please Log in or Create an account to join the conversation.

Last edit: by Sternas Stefanos.

ZeosDb 7.2 SQLLite Access Violation CT. 4.8 10 years 1 month ago #5437

  • eldonfsr14
  • eldonfsr14's Avatar Topic Author
  • Visitor
  • Visitor
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.

Please Log in or Create an account to join the conversation.

ZeosDb 7.2 SQLLite Access Violation CT. 4.8 10 years 1 month ago #5439

  • Vladimir Bazović
  • Vladimir Bazović's Avatar
  • Offline
  • New Member
  • New Member
  • Posts: 7
  • Thank you received: 4
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.

Please Log in or Create an account to join the conversation.

ZeosDb 7.2 SQLLite Access Violation CT. 4.8 9 years 11 months ago #5576

  • Michael Hiergeist
  • Michael Hiergeist's Avatar
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 24
  • Thank you received: 7
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

Please Log in or Create an account to join the conversation.

  • Page:
  • 1