Page 1 of 1

VARCHAR Field AND null values

Posted: Thu Sep 17, 2020 7:18 pm
by vilian
Hi Guys,

I have a VARCHAR field in a oRs (E.g. oRs:cupom ). How could I set a null value to this field ?
I tried oRs:cupom := NIL, but it's generating a type mismatch error !

Re: VARCHAR Field AND null values

Posted: Thu Sep 17, 2020 7:49 pm
by nageswaragunupudi
Assign oRs:cupom := ""
This will be saved as NULL , if you did not define the column as NOT NULL and in that case it will save as DEFAULT.

Re: VARCHAR Field AND null values

Posted: Thu Sep 17, 2020 7:56 pm
by vilian
thanks