>Hi Borislav
>
>See my previous reply. I took it forward. New the simply created record was SCATTERed / GATHERed and it is generating and error
>---------------------------
>X-cize - Professionals Customs and Cen. Ex. Appeals Docu.
>---------------------------
>Dynamic SQL Error
>SQL error code = -303
>conversion error from string ""
>---------------------------
>OK
>---------------------------
>the error that is at the client. The backend has rejected the GATHERed record and the GATHERed data is lost.
>


Maybe you have a routine which convert EMPTY/BLANK date fields to NULL, but because fields containing NULL is not EMPTY that is why you get error.




>UPDATE: There are no contraints on the backend I just confirmed it