Topic: Cannot activate DEBUG_SQLStmt

Hi!
I use SqlitePass 0.55 components in Delphi 7.
When i try to activate debug mode {$DEFINE DEBUG_SQLStmt}, I get an exception message on seting new SQL text in the dataset. Error is raised in the module SqlitePassEngine.inc in line 56.

Re: Cannot activate DEBUG_SQLStmt

Hi,

I tried to have this bug showing up, but nothing happened. Could you send a code sample ?

Note : You don't have to {$DEFINE DEBUG_SQLStmt}to debug the library, except if you want to have detail on dataset events, logged to the SqlitePassDebug form (in sqlitePass  \source\debug).

Thanks

Re: Cannot activate DEBUG_SQLStmt

Thanks for answering,

By enabling the debug-engine, I wanted to get the SQL-code generated inside my program.

Maybe this is my fall, because i was integrate in your code some additional features such as supporting crypt engine(based on sqlcipher) and AddCustomCollate.
Btw, it would be nice to add this feature in official release ,)

In attach changed by me sources of components.

attach

ps: sorry for my english ,)
pps: I hope you uderstand me ,))

Re: Cannot activate DEBUG_SQLStmt

In attach test application that shows this bug
Attach
When SQL text is assigned to DataSet in design mode, on create database we have described exception!

Re: Cannot activate DEBUG_SQLStmt

I fixed this bug by adding condition:

...
{$IFDEF DEBUG_SQLITEPASS}
  if Assigned(FDatabase) then
   FDatabase.Debugger.Display('SQL Statement : ' + FSQLSelectStmt.SQL);
{$ENDIF}
...

Re: Cannot activate DEBUG_SQLStmt

Many thanks,

I didn't have time to check it...
I correct the code in next version.

Regards  smile

Re: Cannot activate DEBUG_SQLStmt

Looking forward to the emergence of the next version.