Hi all
I have a CRecordset derived class, with some string fields which correspond to non-nullable columns in the database. Unfortunately, it seems that ODBC converts empty strings to null, so my updates fail if I have empty strings. I can't change the database or data. Any suggestions?
Thanks in advance
R
>> I can't change the database or data.
that makes it hard...
>>Any suggestions?
If string is empty
set string = "NULL"
"Man alone suffers so excruciatingly in the world that he was compelled to invent laughter."
Friedrich Nietzsche
"I spent a lot of my money on booze, birds and fast cars......the rest I squandered."
George Best
"If you are going through hell....keep going."
Winston Churchill
Thats correct. Not even ODBC, but probably the database. Some databases don't allow empty strings. An empty string indeed is null. You will need to fill the strings or build your own SQL statement for updates.it seems that ODBC converts empty strings to null, so my updates fail if I have empty strings.
hth
-nv
She was so Blonde, she spent 20 minutes looking at the orange juice can because it said "Concentrate."
When in doubt, read the FAQ.
Then ask a smart question.
Setting the strings = "NULL" would be changing the data.
Empty strings are not null. It's not the database, it is ODBC, which does if (field.IsEmpty()) field.m_null = true. The problem seems to be that MFC doesn't recognize a difference between empty and null.
