ADSDBE and SQL Null problem

[rdonnay]

I am struggling with NULL values in a CDX database only when doing a SQL use.

If I do an ISAM use (ADSDBE and dbUseArea), no problem. All empty fields are proper values.

If I do a SELECT statement on the same table (via ADSDBE and dbUseArea), then empty fields come back a NIL values.

I have tried Set(_SET_NULLVALUE,.f.) and dbSetNullValue(.f.) to no avail.

I worked on a SQL project with a customer a few years back doing exactly the same stuff and don't recall any problem with this, but now I can't get past the problem.

It is inconvenient on this project to wrap all field access in IsNull() functions.

Does anyone have any ideas?

[MIGUELON]

Hi Roger, I think the sentence is correct in the following SQL

SELECT * FROM Article WHERE pvp IS NULL

Greetings
Miguel