Re: [libreoffice-users] Selecting records in base to a CSV

On 12/09/2011 10:38 PM, Scott Jones wrote:
> I am trying to select records in Base to a CSV.
>
> I have tried this statement and it works:
>
> SELECT *
> INTO [Text;HDR=NO;Format=CSVDelimited;DATABASE=C:\].MyTable.CSV
> FROM `License Survey Response Code Table (Public)`;
>
> But that is all records.  I want a subset using a LIKE statement.  I've tried:
>
> SELECT * FROM "License Survey Response Code Table (Public)"
> WHERE "Survey Response Code" LIKE '04%')
> INTO [Text;HDR=NO;Format=CSVDelimited;DATABASE=C:\].MyTable.CSV;
>
> No Luck.  Is my syntax wrong?
The normal syntax is

SELECT selectlist
INTO     file or more often a table
FROM   database
WHERE selection criteria

--
Jay Lozier
jslozier@gmail.com


--
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