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

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