Having some trouble with default values.
My table already exists. I want to update default values so I go to the
table properties box and enter the new value for date - CURRENT_DATE.
Clicked OK and in the Log view I get:
1/30/2002 4:42:43 PM - SQL (jbsdata): ALTER TABLE "note" ALTER COLUMN
"date" DROP DEFAULT
The new default value shows up under the table properties, but when I do a
refresh the value is cleared. I'm new to this but the above sql does not
seem correct for adding a new value? Am I doing something wrong here?
Thanks for your help.
George