Le 12/01/2013 13:38, Tom Davies a écrit :
Hi Tom,
> Nope. Thanks for the suggestion! Another thing i think i was doing wrong
> was to use
> Insert - "Query using Sql"
The Query using SQL and Query Design modes only work for pure retrieval
queries, i.e. SELECTS. You can not insert or update w
and regards from
Tom :)
>
> From: Alex Thurgood
>To: users@global.libreoffice.org
>Sent: Saturday, 12 January 2013, 11:53
>Subject: [libreoffice-users] Re: Base: Action Queries
>
>Le 11/01/2013 22:42, Tom Davies a écrit :
>
>Hi Tom,
>
>
>> "SQL Status: HY
Le 11/01/2013 22:42, Tom Davies a écrit :
Hi Tom,
"SQL Status: HY000 Error code: 1000"
"SQL Status: HY000 Error code: 1000 syntax error, unexpected $end, expecting
BETWEEN or IN or SQL_TOKEN_LIKE"
I hope that you are using the Tools > Options > SQL menu instead of
trying to do this
Lewis
To: users@global.libreoffice.org
Sent: Friday, 11 January 2013, 23:08
Subject: Re: [libreoffice-users] Re: Base: Action Queries
I wonder about the last line of your code:
WHERE OrgName IS NOT NULL;
Above this line you used "OrgName"
Your field has upper and lo
;Sent: Friday, 11 January 2013, 23:08
>Subject: Re: [libreoffice-users] Re: Base: Action Queries
>
> I wonder about the last line of your code:
>
>WHERE OrgName IS NOT NULL;
>
>Above this line you used "OrgName"
> Your field has upper and lower case lett
RT INTO OrgTable
("IdOfOrg", "IdOfPerson", "OrgName")
SELECT ("IdOfOrg", "IdOfPerson", "OrgName")
FROM "zzQuery1"
WHERE OrgName IS NOT NULL;
Regards from
Tom :)
________
From: Alex Thurgood
To: users@
le
("IdOfOrg", "IdOfPerson", "OrgName")
SELECT ("IdOfOrg", "IdOfPerson", "OrgName")
FROM "zzQuery1"
WHERE OrgName IS NOT NULL;
Regards from
Tom :)
____________
From: Alex Thurgood
To: users@glo
________
> From: Alex Thurgood
>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 export
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
