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

Data Abstract
1

Hello,
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?

Thanks,
Eugene.

2

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

3

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