NULL INT field gives strange value in CRecordset class.

[Matthew Stanfield]

Hi,

My software uses a MFC CRecordset derived class.

Occasionally when I am doing a query 2 integer fields have strange
values. It seems that in the Database Table they are NULL. I'm accessing
them as a long in my MFC code, they are integers in the actual table.

The values are both '1246576928' (they should be 5 digits) - I had
assumed that NULL values in the database table would translate as 0 in
the member of the CRecordset class.

How do I tell in my MFC class when I'm getting a NULL value? It would be
hard to replace all NULL values in the table with 0 as there are many
tables involved.

Thanks and regards,

..matthew

PS. Using Vis C++6, Client is Win 2000 Pro, Server is Win 2000 Advanced
Server).

[Scot T Brennecke]

See this article: "PRB: C Datatype's Pseudo Null Values Are Not Inserted into
SQL Database Correctly"
ID: Q231875

[Matthew Stanfield]

Thanks Scot. IsFieldNull() is my baby.

..matthew

[Ian McCoubrey]

See Knowledge Base article Q231875.

'1246576928' is '4a4d4120' in hex, this the pseudo-NULL value for long.

Ian.

"Matthew Stanfield" <mat...@propertyknowledge.com> wrote in message
news:3AF95577...@propertyknowledge.com...