I'd like to use TDBLookupComboBox-component in my project.
How this it works you can see in attached app...
1 2010-11-15 17:09:24
Topic: Strange behavior of DBLookupComboBox (7 replies, posted in Bug Tracking)
2 2010-11-15 16:49:17
Re: Cannot activate DEBUG_SQLStmt (6 replies, posted in General)
I fixed this bug by adding condition:
...
{$IFDEF DEBUG_SQLITEPASS}
if Assigned(FDatabase) then
FDatabase.Debugger.Display('SQL Statement : ' + FSQLSelectStmt.SQL);
{$ENDIF}
...
3 2010-11-13 14:05:28
Re: Cannot activate DEBUG_SQLStmt (6 replies, posted in General)
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!
4 2010-11-13 10:12:59
Re: Cannot activate DEBUG_SQLStmt (6 replies, posted in General)
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.
ps: sorry for my english ,)
pps: I hope you uderstand me ,))
5 2010-11-13 09:29:12
Re: Incorrect changing SQL condition (2 replies, posted in Bug Tracking)
to get around the bug, I use such code
select * from w where trim (f1) = Trim (:par);
Thanks, waiting for fixex
6 2010-11-11 09:37:39
Topic: Incorrect changing SQL condition (2 replies, posted in Bug Tracking)
Hi!
I use SqlitePass 0.55 components in Delphi 7.
Situation:
create table w(f1 text(9));
insert into w(f1) values (" 1 ");
select * from w where f1=" 1 ";
When select statement is assigned, it is converted to the:
select * from w where f1=" 1 ";
and of course the output I get an empty set!!!
7 2010-11-11 08:09:42
Topic: Cannot activate DEBUG_SQLStmt (6 replies, posted in General)
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.