error creating table for postgres

[Ralph DiMola]

Dr,

Of course brain moved slower than then the fingers. I miss-placed the
bracket for the first field [uniq_sfky]. Should have been....

CREATE TABLE [plumber_joe_the__001_sofa]  ([uniq_sfky] INTEGER PRIMARY KEY ,
[subq] CHAR(3) , [a] TEXT, [b] TEXT, [c] TEXT, [d] TEXT, [ordr] INTEGER,
[user] CHAR(20), [tstmp] TIMESTAMP WITH TIMEZONE )


Ralph DiMola
IT Director
Evergreen Information Services
rdimola at evergreeninfo.net


-----Original Message-----
From: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] On Behalf
Of Dr. Hawkins
Sent: Monday, April 22, 2013 1:55 PM
To: How to use LiveCode
Subject: Re: error creating table for postgres

On Sun, Apr 21, 2013 at 9:50 PM, Ralph DiMola <rdimola at evergreeninfo.net>
wrote:
> I put brackets[] around table and field names to avoid this. I would 
> have written it like this. This convention also has the advantage of 
> being more readable.
>
> CREATE TABLE [plumber_joe_the__001_sofa]  (uniq_[sfky] INTEGER PRIMARY 
> KEY ,

Ahh, readability . . . so usueful when we come back later.

Of course, most of my queries get assembled over 2-5 lines of code, so . . .
thanks
--
Dr. Richard E. Hawkins, Esq.
(702) 508-8462

_______________________________________________
use-livecode mailing list
use-livecode at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode