I have a simple select that do grouping where X is varchar (string) field:
select x, count(*) from table group by x;
When I do QBE on the field X, it generates having clause without quotas and select crash!!!
select x, count(*) from table group by x;
having (x = 01002)
/* Modified for QBE */
This works correctly at version 4.1.1.0 where is generated:
having (x = '01002')
How can I fix this behaviour?
Reagrds Vlada