Re: SQL Examples
Re: SQL Examples
- Subject: Re: SQL Examples
- From: Bruce Robertson <email@hidden>
- Date: Thu, 12 Mar 2009 10:16:48 -0700
> 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
References: | |
| >SQL Examples (From: Bruce Robertson <email@hidden>) |