Hi programmers, Can you help me? I have three problems:
1)
I have problem with AllowOperators - I am using TDBEdit and property MaxLength is set to 0 (this means, that size is set to Field.Size for string field). When I enter QBE mode, size of TDBEdit is not changed and I can write for example only 2 chars and it is not enought for enter operators ... Is there any simple solution? Or Can you help me, how can I find all edits on all forms connected to DataSource used with QBE?
2) I have problem with "in operator". I want SQL WHERE KOD IN ('10','20','30'). When I write in QBE string field "in (10,20,30)" result in SQL select is KOD IN ('10,20,30').
Or I write "in ('10','20','30')" result in SQL select is KOD IN ('10'',20'',30').
3) I want in BeforeQBE event change expresions (for example expression "between 10 and 30" to "10..30". I write expression into QBEDefinition.Fields[I].Value but display value is "between 10 and 30" and after DBEDIT get focus, value changes to "10 .. 30"
When I set Fields[I].Value in BeforeQBE event, displayed value is right, but on second execution of ExecuteQBE acces violation is raised.
Thanks for your help or ideas!
