Ask Your Question

SQL Syntax Error

asked 2015-04-05 19:57:38 +0200

GJim gravatar image

updated 2015-04-05 20:07:59 +0200

I have a MS-Access db that I wish to use under LibreOffice Base. Within the db, there is a query that works just fine when using MS-Access - but Base tells me that there is a syntax error in the query.

The code contains some html tags which get stripped out when I send this post to the forum.

Can't send an attachment since, as a new member, I don't have sufficient points.

I would be glad to send the .txt file to anyone who wishes to take a look at the code.

I'm unable to find any error in this code - admittedly it is a complicated statement.

Any help greatly appreciated.

G-Jim c):{-

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-04-08 17:12:41 +0200

GJim gravatar image

I have found the problem and the solution.

Within the query, I am adding html tags around the fields in a concatenation operation. In MSAcess, the html tags are bounded by the double-quote mark. LO Base requires the single-quote mark instead.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-04-05 19:57:38 +0200

Seen: 520 times

Last updated: Apr 08 '15