"Could not convert variant of type (String) into type (Date)" on Insert

(egold2005) #1

I have defined a simple dataset in schema with corresponding update statements. The back-end is Firebird,
and the underlying table has TIMESTAMP data type in FB, which are being converted into datDateTime on client side.

As soon as i click Ins in a grid - i have the above-mentioned exception.

It looks like it was a known issue some time ago…how do i fix?


(EvgenyK) #2

clear DefaultValue property for your datDateTime field. looks like it has Now value.

(egold2005) #3

Thanks Evgeny, that was the reason…it carried over current_timestamp default field value from backend over to client as DefaultValue.