The parameter of type 61 did not have a valid value
This is an error from the Sybade Database.
It means that a variable of type 61 (Date) does not have a valid value.
This is ususally caused by your Date time not being Nullable in your EO or you CV and because
Microsoft and Sybase have different Epochs, or Minimum Dates values.
Microsofts EPOCH for a DateTime is: 00:00:00.0000000, January 1, 0001
and Sybases depends on the exat type in your DB see the chart here:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc35400.1550/html/osref/osref281.htm
But in essence here is what happens.
In the DB the Date is null,
In your EO the dateTime is not nullable
Net converts the null to DateTime.Min (01/01/01)
during an update this value is smaller than the allowed (for us ususally 01/01/1900)
Best fix, it to change the Datetimes in your EO & CV toall be nullable, OR to use a CV that does not contain any of the date fields for updating, and let JCDCHelper deal with it..
See here for the codes of all Sybase datatypes : http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.tables/html/tables/tables69.htm
No comments:
Post a Comment