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 [email protected] -----Original Message----- From: use-livecode [mailto:[email protected]] 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 <[email protected]> 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 [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
