General information
Title:
VFP/Crystal & selection of recs depending on boolean
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only