FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour VARCHAR Field AND null values
vilian
Posts: 1067
Joined: Wed Nov 09, 2005 02:17 AM
VARCHAR Field AND null values
Posted: Thu Sep 17, 2020 07: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
nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: VARCHAR Field AND null values
Posted: Thu Sep 17, 2020 07: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
vilian
Posts: 1067
Joined: Wed Nov 09, 2005 02:17 AM
Re: VARCHAR Field AND null values
Posted: Thu Sep 17, 2020 07:56 PM

thanks

Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Belém-Pa-Brazil

Continue the discussion

Static archive · New replies & topics via GitHub Discussions