Drew Jensen wrote:
Andreas Saeger wrote:
[...]
Today I found that it can not even group by calculated fields:
SELECT "Forname"||','||"Surname" AS "Patient Info",
[...]
GROUP BY "Patient Info"
Works for me using the 3.2 pre-release build
*http://tinyurl.com/kp5yrf
Drew
*
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).
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
