Hi Pauline,
This question seems to be a VFP and Crystal Reports issue. You might get a better response asking this in the VFP forum instead of the .NET forum.
>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
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi