I got a database problem:

Using the exact same dbf data, VarIsNull on a field tests true on my
machine,
but tests false on the client's machine. Any ideas as to why?

OS is the same (Windows 95b)

Network OS is the same (Novell 4.1)

Thanks,

This is how it looks now with your suggestion, but it still executes the
code in the If block even though Query['CREDITACCT'] is Null.

If (not VarIsNull(Query['CREDITACCT'])) or (not
Query.FieldByName('CREDITACCT').IsNull) then begin

    ShowMessage('VarType: ' + IntToStr(VarType(Query['CREDITACCT'])));

End;

The ShowMessage will not execute on my machine, but will display
"VarType: 256" on the client's machine.

I've even gone so far as to have the contents of the Field copied to the
clipboard and pasted in a DOS box. It was a Smiley face.

Any suggestions will be greatly appreciated.  Thanks again,

Elie

Thanks for writing.

To answer you questions:

If (not VarIsNull(Query['CREDITACCT'])) then begin
    // Code that credits the loan account...
End;

I have an idea as to what may cause the problem. It may have to
do with the data-entry screen. I'm going to check it out and post
back here.

If you have any insights that might solve this problem, my first two
boys will be named Bruce and Robert. Thanks in advance.

Elie

I've tracked down the problem. Bruce Robert made me ask the client
what version of the BDE the were using, and what did they say?
"Version 4." Same as me. But when I got there this afternoon, I
checked it out myself and it was actually version 4.5!

So, as it turns out, VarIsNull returns False on an empty field when
using the BDE V4.5, but not when using V4.00 or, I was happy to
discover, V5.01, which I installed everywhere.

I also believe I compounded the problem by initializing a variable
to '' (empty string) then posting it to an Inserted record.

Thanks for your help Steve Koterski and Bruce Roberts.

-Elie Tordjman