VARCHAR Field AND null values

VARCHAR Field AND null values

Postby vilian » Thu Sep 17, 2020 7:18 pm

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 !
Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Belém-Pa-Brazil
User avatar
vilian
 
Posts: 972
Joined: Wed Nov 09, 2005 2:17 am
Location: Brazil

Re: VARCHAR Field AND null values

Postby nageswaragunupudi » Thu Sep 17, 2020 7:49 pm

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

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10620
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: VARCHAR Field AND null values

Postby vilian » Thu Sep 17, 2020 7:56 pm

thanks
Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Belém-Pa-Brazil
User avatar
vilian
 
Posts: 972
Joined: Wed Nov 09, 2005 2:17 am
Location: Brazil


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 43 guests