>OTOH if you know CustomerCode can never be null ...< That's the interim solution. It was never intended to be a mandatory field, but making it so doesn't have significant impact. The bizarre thing was the query ran ok on some machines... Terry --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
- [DUG]: Odd BDE problem with types Terry Johnson
- RE: [DUG]: Odd BDE problem with types Myles Penlington
- RE: [DUG]: Odd BDE problem with types Max Renshaw-Fox
- RE: [DUG]: Odd BDE problem with types Terry Johnson
- RE: [DUG]: Odd BDE problem with types Max Renshaw-Fox
- Terry Johnson