Re: FRONTBASE add not null constraint?
Re: FRONTBASE add not null constraint?
- Subject: Re: FRONTBASE add not null constraint?
- From: Chuck Hill <email@hidden>
- Date: Sun, 26 Jul 2009 22:16:03 -0700
FrontBase (and most other good databases) is based on the SQL92
standard. Google will turn up many pages on SQL syntax.
Chuck
On Jul 25, 2009, at 9:56 PM, Shravan Kumar. M wrote:
Hello Group,
I was trying to increase the column size of a column in frontbase,
but failed due to some constraint issues. I have searched and got a
solution posted way back by Chuck:
http://markmail.org/message/uk46b2su2wb654up#query:frontbase:
Semantic error 278+page:1+mid:uk46b2su2wb654up+state:results
I have first dropped the constraint. Then increased the column size.
Noe the problem is am unable to add constraint. Please help.
Following is the alter statement failing to work:
ALTER TABLE "MYDB"."CUSTOMER" ADD CONSTRAINT
NOT_NULL_MYDB_CUSTOMER__DESCRIPTION NOT NULL (DESCRIPTION) DEFAULT "
";
Thank you,
Shravan Kumar. M
-----------------------------
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
--
Chuck Hill Senior Consultant / VP Development
Learn WO at WOWODC'09 East in Montréal this August!
http://www.wocommunity.org/wowodc09/east
http://arstechnica.com/apple/news/2009/07/webobjects-sliced-from-106but-prognosis-of-death-premature.ars
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden