It may be worth focussing on whether it is failing on the field value or
the parameter value.
As a matter of course I would have tested the value of the [parameter
":CustomerCode" and changed the where clause to either (CustomerCode =
:CustomerCode) or just (CustomerCode IS NULL).
I haven't experienced this problem, with "is null" that is, but I also
avoid complex mixtures of AND and OR since I found that 16 and 32 bit BDE
had different, and mutually exclusive, problems with complex WHERE clauses.
This was all from the transition from D1 to D2 so it's old info though.
Max
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of
Myles Penlington
Sent: Thursday, 1 April 1999 07:34
To: '[EMAIL PROTECTED]'
Subject: RE: [DUG]: Odd BDE problem with types
I've had lots of problems with the BDE when dealing with "Is null" in SQL
where statements, in my cases it always fails 100% of the time. I have
managed to avoid using "is null" and have not taken it any further.
Myles
-----Original Message-----
From: Terry Johnson [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, March 31, 1999 11:55 PM
To: Multiple recipients of list delphi
Subject: [DUG]: Odd BDE problem with types
Now this is a little weird. Picture this;
Client site using Delphi app with databases in the traditional paradox
tables. All runs faultlessly. After several months, a report fails with a
'type mismatch' error. With the same databases on my machine, it works
fine. Same DB, same BDE, same app. But on some other machines in the
office, it fails. It seems that on machines with Delphi 2 installed, it
runs fine.
The program is analysed, and found to be failing on an SQL statement in a
master/detail relationship;
.. and (CustomerCode=:CustomerCode) or ((CustomerCode is null) and
(:CustomerCode is null)) ...
If we remove the 'or' clause, it works fine on all machines. Any ideas?
Terry
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
winmail.dat
