[RBASE-L] - Re: -ERROR- Specified default value is not valid for column ReleaseDate (2793)

[Dawn Hast]

Alastair

 

Check to see if your DATE FORMAT and DATE SEQUENCE differ. (Is one mm/dd/yyyy and the other yyyymmdd)?

 

Dawn Hast

-------------- Original message from "Alastair Burr" <alastair.b...@ntlworld.com>: --------------

I'm reloading a table and I guess this is a tightening up that I have missed.

 

The column is (not surprisingly) a DATE column and the default is : (.#DATE) 

 

I've tried un-dotted and without brackets but still get the error.

 

Stranger, I have two other similar columns, Entry_Date & Up_Date, one of which has the same default but the other is computed rather than defaulted and uses an _expression_ with the calculation: (.#DATE). Both these columns follow the ReleaseDate in the table so I don't know (yet) if either will fail also.

 

Any thoughts, anybody?

  

Regards, 

Alastair 

 

----------------------------

Alastair Burr

St. Albans, UK.

alastair.b...@ntlworld.com

-----------------------------