Re: SQL Examples
Re: SQL Examples
- Subject: Re: SQL Examples
- From: Bruce Robertson <email@hidden>
- Date: Thu, 12 Mar 2009 13:37:15 -0700
Thanks for your suggestion but it doesn't work.
That's why I keep asking for working examples.
> Sorry for not following up with you earlier. I believe the course of
> action is to create the database as a separate step in the beginning,
> and THEN Apply SQL to that table later in the action, specifying the
> database created earlier.
>
>
> On Mar 12, 2009, at 12:16 PM, Bruce Robertson wrote:
>
>>> It would be helpful to see some simple examples of using the
>>> Automator SQL
>>> funtions like Convert CSV to SQL, Apply SQL, and Execute SQL.
>>>
>>> Bruce Robertson
>>
>> For instance if Do this in Convert CSV to SQL:
>>
>> Before:
>> BEGIN TRANSACTION;create table bikes( company);
>>
>> Per Row:
>> INSERT INTO bikes values (%{1}@);
>>
>> After:
>> end transaction;
>>
>>
>> And feed it to action Create SQLite Database, then the result does not
>> contain any of the data.
>>
>> Instead, it contains tables ZFIELD, ZRECORD, Z_METADATA, Z_PRIMARYKEY
>>
>> And none of these table contain my data.
>>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Automator-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden