Re: [Lazarus] SQLQuery1: Field not Found: "enquiryreferencenumber"

2008-05-28 Thread Dave Coventry
Hi Joost, On Wed, May 28, 2008 at 10:46 AM, Joost van der Sluis <[EMAIL PROTECTED]> wrote: > And which version of fpc are you using? It could be a releaf if you use > a recent 2.2.1 snapshot. I'm using fpc 2.2.0. Do you think that might be the cause? __

Re: [Lazarus] SQLQuery1: Field not Found: "enquiryreferencenumber"

2008-05-28 Thread Joost van der Sluis
Op woensdag 28-05-2008 om 06:02 uur [tijdzone +0200], schreef Dave Coventry: > Hi. > > Following Damien's instructions I have DROPped my original table and > created a new one in it's place: > > CREATE table registration ( > fname char(50), > sname char(50), > enquiryreferencenumber INT4 PRIMARY

Re: [Lazarus] SQLQuery1: Field not Found: "enquiryreferencenumber"

2008-05-28 Thread Damien Gerard
Le May 28, 2008 à 6:02 AM, Dave Coventry a écrit : > Hi. > > Following Damien's instructions I have DROPped my original table and > created a new one in it's place: > > CREATE table registration ( > fname char(50), > sname char(50), > enquiryreferencenumber INT4 PRIMARY KEY DEFAULT nextval('reg_s

[Lazarus] SQLQuery1: Field not Found: "enquiryreferencenumber"

2008-05-27 Thread Dave Coventry
Hi. Following Damien's instructions I have DROPped my original table and created a new one in it's place: CREATE table registration ( fname char(50), sname char(50), enquiryreferencenumber INT4 PRIMARY KEY DEFAULT nextval('reg_seq')) WITHOUT OIDS; I have run my INSERT Query under PQConnection1 u