Andreas Saeger wrote:
Next one converting 2-digit years into 4 digit years (1909-2008):
SELECT (CASE WHEN ("P"."Jahr"+2000)>=YEAR(CURRENT_DATE) THEN 1900 ELSE
2000 END)+ "P"."Jahr" AS "Four Digit Year"
Yields an SQL syntax error. Does works in direct mode. However, direct
mode is read-only and fails in subforms (relation to parent form fails
silently).
And another one merging tables and queries:
SELECT ... WHERE ("qryA"."XID"="tblA"."ID")AND("tblB"."X"="tblC"."Y")...
Fails with unknown column, strips "quryA" when loaded in design mode,
but runs well while testing in parsed SQL mode.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
