Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


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 <alex.thurgood@gmail.com>
To: users@global.libreoffice.org 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: users+help@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





--
For unsubscribe instructions e-mail to: users+help@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.