[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

FRONTBASE add not null constraint?

Subject: FRONTBASE add not null constraint?
From: "Shravan Kumar. M" <email@hidden>
Date: Sat, 25 Jul 2009 21:56:27 -0700 (PDT)
Delivered-to: email@hidden
Delivered-to: email@hidden
Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1248584187; bh=nCu3d17r5rOCuByGsBi1t7wRQlRhe8/yJTj7rXqUXl0=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=sWZg8n12e8AN60fl+g9bBe9hExuoDooUgSdMrdwR9Br+H9VMa1IzJZK4e2Am3r4SqG/dg834jh+o05w89gPxwRAv4taMx6ZbuqWejPgzpX/ZcMkbYeZDagBaLE+JJiHJBcs+pJ4q4WS30aPDtF+vrUwv+EwPg7WjcgD1jM+2fp0=
Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=Zbep9nz4GxhpDY+OC3k6CpOsCGElirOvmODAhghfxJg8R+xUzesM1NWDOsyBAf3L9H8HRh4YTwsDIREk7VP5AqmXuhtnpWDy5nfvGPQ2HqiJ16Rtu8RoudCoBu+YGlCIwizfiw0Uiq1rH/YswOr6E5EFzv0ODh2LTPq6Nmpsk/4=;

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

Follow-Ups:
- Re: FRONTBASE add not null constraint?
  - From: Chuck Hill <email@hidden>

Prev by Date: Re: Maven Resource / WebServerResource Flattening
Next by Date: Re: WebObjects apps in war; maven; where is ERXServletAdaptor; etc.
Previous by thread: War / Maven / Jar Build – How Does it Work with Eclipse's "Build Automatically"?
Next by thread: Re: FRONTBASE add not null constraint?
Index(es):
- Date
- Thread

Home