Maria:
The developers need to read the PRO*C manual. What the developers need to do
is to use indicator variable. These are varaiables that indicate whether the
variable is NULL (or if the value was truncated when selected into).
Here is a short example.
char v_first_name[18];
short
If you use ODBC (CTransaction + CRecordset in MFC) there is no problem to
handle null values.
It isn't good idea to put 0 (zero) instead of null in number column.
JP
On Fri 19. October 2001 15:00, you wrote:
hello!
our developers here are requesting that I put defaults (' ' for
Hi,
sorry for the strong language, but the statement that VC++ isn't able to
retrieve NULL values is plain bullshit.
| Regards, |
| Stefan Jahnke |
| BOV AG |
| @:D2 Vodafone, Abt.: FBOM |
| Tel.: 0211/533-4893
Maria,
They need to use indicator variables. This is documented in the Pro*C
documentation. The application that I wrote is two years old but is still
operational against a 8.1.x database. I tried to find a small snippet of code
to include but since I haven't worked on the application in
I forget the values for the indicator variables, but that is in the PRO*C
manual.
I think the values are 0 1 (false true). At least they are in Cobol.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, October 19, 2001 9:50 AM
To: Multiple recipients of
Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
-Original Message-
From: Mercadante, Thomas F [SMTP:[EMAIL PROTECTED]]
Sent: Friday, October 19, 2001 09:25 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: slightly OT: visual c++ and null
Pro*C has indicator variables.
MFC's ODBC classes have IsNull functions.
Both methods add an extra step to the code to check for null, so it is a
pain to implement (and a major pain if all the columns are nullable), but it
is doable.
Brian Norrell
Manager, MPI Development
QuadraMed
511 E John
