Re: [libreoffice-users] Re: Base: Action Queries

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