>When I use the Ole DB provider for Visual Foxpro within Crystal reports, I get an error when using a date field. The error message contains the following:
>
>Failed to retrieve data from the database.
>Details: ADO Error Code: 0x80004005
>Source: MS Ole DB provider for Visual Foxpro
>Description: SQL: COlumn 'DATETIME' is not found.
>Native Error: 806
>
>When I view the generated SQL select statement, it is taking the date field and performing the following:
>
>`Schedule`.`sched_start`=CONVERT(DATETIME, '06-28-2007', 110)
>
>Does anyone know if a work around for this?
>
>Thanks you in advance.
This Select is generated for SQL Server not for VFP. VFP have no such function like convert.
Change it to
`Schedule`.`sched_start`=DATE(2007,6,28)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.