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
