Hi,
Today there was an update of OOo packages, and now clicking on "list
content" in the form control throws this error message:
---<--------------------cut here---------------start------------------->---
Syntax error in SQL statement
syntax error, unexpected PUBLIC, expecting '(' or '{' or NAME
---<--------------------cut here---------------end--------------------->---
in the list box we were talking about in the earlier thread, where the
list box shows multiple concatenated columns. After clicking OK on the
error dialog box above, I'm taken to the SQL command editor, where the
statement I wrote is shown:
SELECT waypoint_number || ' | ' || to_char(lon, '999D99999') || ' | ' ||
to_char(lat, '99D99999') AS "DisplayText", waypoint_id FROM public.waypoints
The list box is working fine, nonetheless, but the error above makes me
cringe thinking something might go wrong when using the form with this
control. If I click "run query" from this editor, I'm shown a "Syntax
error in SQL expression" dialog and clicking "More" there, I get 3
errors in the error list with description:
,-----
| SQL Status: HY000
| Error code: 1000
|
| Syntax error in SQL expression
`-----
,-----
| SQL Status: HY000
| Error code: 1000
`-----
,-----
| SQL Status: HY000
| Error code: 1000
|
| syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE
`-----
Any thoughts what is causing this and whether it's something to loose
sleep over?
Cheers,
--
Seb
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
