Hi,

I am reporting on a Visual FoxPro dbf file (Version 6.0)
using Crystal Report Writer (Version 8) via an ODBC
connection.

The problem I have is that I want to select only records
where a logical value is True. I have done this by
setting up a selection criteria, which is straight
forward, except that when I attempt to preview the results
I get the following error :-

Failed to open a rowset.
Details: 22018:[Microsoft][ODBC Visual Foxpro Driver]
Operator/Operand type mismatch.

I have also tried creating a query using the Crystal SQL
Designer and get the same crash. The query produced by
the SQL Query Expert is as follows:-

SELECT
property.`property`,
property.`known_as`,
property.`current`
FROM
`property` property
WHERE
property.`current` = 1

If I edit the query and remove the '= 1' from the end of
the query then the query runs as expected. I presume the
record selection within the Crystal Report writer must be
producing a similar SQL statement to the one which
crashes.

Although I have a workaround I would like to be able to
use the Crystal Report Writer directly - does anyone have
any ideas how to get this to work?

Thanks in advance,
Pauline