Tom,
One thing that popped out at me is that you used double quotes (")
around your names. So I checked one of my queries to be sure and
confirmed Base is using the single reverse quote ` ( not '). You might
try that. The "...unexpected $end..." is a clue. It sounds like it is
finding an end-of-statement prematurely. On my keyboard, the single
reverse quote is the quote under the "~" tilde key, not the single quote
under the " key.
Hope this helps.
Girvin Herr
Tom Davies wrote:
Hi :)
Thanks guys :) Ok, so i am starting out with the embedded database against all advice but just so
that i can keep emailing it to myself easily until i get to grips with it better. Then i hope to
export this table to whatever small back-end seems best. My Sql coding gets rejected "Syntax
error in SQL expression" and then these "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"
Here's 'my' code
INSERT INTO OrgTable
("IdOfOrg", "IdOfPerson", "OrgName")
SELECT ("IdOfOrg", "IdOfPerson", "OrgName")
FROM "zzQuery1"
WHERE OrgName IS NOT NULL;
Regards from
Tom :)
________________________________
From: Alex Thurgood <[email protected]>
To: [email protected]
Sent: Friday, 11 January 2013, 20:46
Subject: [libreoffice-users] Re: Base: Action Queries
Le 11/01/2013 21:28, Tom Davies a écrit :
Hi Tom,
I've exported a tiny part of the data, and ended up with 2 columns
ClientID
CompanyName
Not all clients have a company name so there are a lot of blanks in the 2nd
column. I've written a query to just show the non-blanks (=non-nulls) but now
i want to make that into a table in it's own right. Is there an easy way to
get a query to create the table for me or should i export as a Csv?
This might help
http://www.techonthenet.com/sql/insert.php
using INSERT ... SELECT
Alex
--
For unsubscribe instructions e-mail to: [email protected]
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
--
For unsubscribe instructions e-mail to: [email protected]
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
