Database quick tip please... 1

[PLV]

I need to know how to pinpoint if a database query has returned a NULL value.

I do a left join with 2 tables so it is possible that I have NULL values in one of my table fields.

I've tried to use NVL like this:
RFX_Text(pFX, _T("NVL([CPG], "REC_NULL&quot&quot, m_CPG);

It's not working...

I've looked on the IsFieldNULL function of the CRecordset and I cannot find a way to use it!

I only need to raise a flag if I found a NULL value.
If U could give me a little example it would be nice!!!

Thx Alot guys!!!

 

[Cagliostro]

is it an SQL question? If so put it in other forums. John Fill

ivfmd@mail.md