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
Delivered-to: email@hidden
Delivered-to: email@hidden
FrontBase (and most other good databases) is based on the SQL92
standard. Google will turn up many pages on SQL syntax. Chuck 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%3A
%20Semantic%20error%20278+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:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden This email sent to email@hidden
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:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden This email sent to email@hidden
Visit the Apple Store online or at retail locations.
Contact Apple | Terms of Use | Privacy Policy
Copyright © 2007 Apple Inc. All rights reserved.
