Re: Column name: CHECK

2003-12-25 Thread Martijn Tonies
Hi Hans, > Yes, I have used ` > > I don't think check is reserverd because I can CREATE the column name! From > the mysql prompt its possible to insert a record, but not from my Delphi > Code. After that i try to alter / delete the column but thats impossible. > Other columns in the same table whe

Re: Column name: CHECK

2003-12-24 Thread Hans van Dalen
ent: Wednesday, December 24, 2003 16:41 Subject: Re: Column name: CHECK > > > I use the column name CHECK (smallint), but when I insert into the table I > > get an error : Check the manual for: Check) values ( etc.etc. > > > > When I try to change the column name (alter tabl

Re: Column name: CHECK

2003-12-24 Thread Director General: NEFACOMP
Have tried to use back sticks? Like `check` Thanks Emery - Original Message - From: "Martijn Tonies" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 24, 2003 16:41 Subject: Re: Column name: CHECK > > > I use the column name CHEC

Re: Column name: CHECK

2003-12-24 Thread Martijn Tonies
> I use the column name CHECK (smallint), but when I insert into the table I > get an error : Check the manual for: Check) values ( etc.etc. > > When I try to change the column name (alter table tablename change check > blabla smallint) I get an error too, check your manual.. > > Does anybody know