Information générale
Titre:
Crystal with VFP & select with logical
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement