Dan & Razzak Thanks for the help. I thought the syntax was correct ! The idquotes are set to [`]. Dan you're right there is data in the table. I don't use this particular command very often but it sure helps to have friends on the Rlist !
Many thanks..this list is terrific ! Bill Eyring -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Wednesday, January 07, 2009 5:49 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Syntax Question Try this: alter table dedcodes add GLCode TEXT 16 NOT NULL ('You Must Enter a GL Code !') Remember, the NOT NULL part will not work if the table contains rows. Dan Goldberg -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring Sent: Wednesday, January 07, 2009 2:41 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Syntax Question I want to add a column to a table and I've tried many permutations of the same command. The command is alter table dedcodes add column `GLCode` TEXT (16) NOT NULL ('You Must Enter a GL Code !') I keep getting an invalid message -ERROR- Invalid column constraint(2794) Can anyone tell me what's wrong with this syntax, I followed the syntax in RBase Help. I am using latest release of Turbo 8- 8.0.19.31229 Thanks, Bill Eyring
