I think the following had been working for some time, but now it creates an
error:
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 )
produces
Error: syntax error at
On 22/04/2013, at 10:54 AM, Dr. Hawkins wrote:
> I think the following had been working for some time, but now it creates an
> error:
>
> 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
, 2013 12:18 AM
To: How to use LiveCode
Subject: Re: error creating table for postgres
On 22/04/2013, at 10:54 AM, Dr. Hawkins wrote:
> I think the following had been working for some time, but now it
> creates an
> error:
>
> CREATE TABLE plumber_joe_the__001_sofa (uniq_sfky
On Sun, Apr 21, 2013 at 9:18 PM, Igor de Oliveira Couto
wrote:
> On 22/04/2013, at 10:54 AM, Dr. Hawkins wrote:
>
>> I think the following had been working for some time, but now it creates an
>> error:
>>
>> CREATE TABLE plumber_joe_the__001_sofa (uniq_sfky INTEGER PRIMARY KEY ,
>> subq CHAR(3)
On Sun, Apr 21, 2013 at 9:50 PM, Ralph DiMola 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 ,
LiveCode
Subject: Re: error creating table for postgres
On Sun, Apr 21, 2013 at 9:50 PM, Ralph DiMola
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.
>
&g
From: use-livecode [mailto:use-livecode-boun...@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
> wrote:
> >