Re: [libreoffice-users] syntax error in SQL - error 1000

Hi Peter,

> I have a query which works fine. But when I edited it in the graphical query> editor LO refused 
> to save it saying that there was an SQL error. The>
detailed message was "syntax error, unexpected $end, expecting BETWEEN
or IN> or SQL_TOKEN_LIKE". Even if I try to save the unedited version I
get the> error, which I find a bit bizarre. But it runs OK and gives the
correct> result.
This is the default-message when GUI doesn't know how to change the
code. You have designed the query after switchung from GUI to direct SQL
for adding
UCASE( "Wines"."Wine_Name" ) LIKE UCASE( '%' || ( SELECT "filterstring"
FROM "tblfilter" ) ) || '%'
and the query will work.
Could be better to change it a littel bit
UCASE( "Wines"."Wine_Name" ) LIKE '%' || UCASE( SELECT "filterstring"
FROM "tblfilter" ) || '%'
and to set the subquery for only one row, but could be it won't change
the behavior. Query will be opened for changing in GUI-Mode, but this
wouldn't work ...

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted