VARCHAR Field AND null values

[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 !

[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.

[vilian]

thanks