[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Long Field Type -Reply



I just checked that in a process of mine with long fields,
I placed a show statement on it and it was a Null value...I.e. '' field,
not a ' '.  Hope that helps...oh, and I insert that into a table like that and it
works fine

Mark Kraft
kraftm@gunet.georgetown.edu

>>> David Anderson <DANDERS1@SMTPGW.IS.HFH.EDU> 09/30/98
11:06am >>>
I am trying to insert into a PeopleSoft record using SQR which contains a
field of type LONG.  Are there "special handling" instructions for this type
of field?  Specifically, what is the null value?
     number fields have null value of 0 (zero)
     text fields have null value of ' ' (space)
     date fields have null value of '' (two tick marks)
     long fields have null value of ????????????????????????

Thanks,
Dave