Watch out when using square brackets as sql delimiters - they're not standard sql and will probably be rejected in some implementations. Like Ralph I always use delimiters around table/column names but stick with the standard double quotes.
Pete lcSQL Software <http://www.lcsql.com> On Mon, Apr 22, 2013 at 11:37 AM, Ralph DiMola <[email protected]>wrote: > 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 > _______________________________________________ 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
