Posted By: giga QBE - allow operators - 03/19/04 01:05 PM
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!
Posted By: Marco Kalter Re: QBE - allow operators - 03/19/04 09:30 PM
1.
This seems like a bug. We'll try to fix it.

2.
This also seems like a bug, and will be fixed too. It works okay if you type:

10 or 20 or 30

3.
We'll try to reproduce this.
© Allround Automations forums