>Has anyone used VFP 5 with Oracle 8? If so, I have two questions:
>
>1. Which ODBC driver are you using?
>2. Are you using views or just pass-through sql?
>
>Microsoft has confirmed that VFP 5 wont allow you to save parameterised views when using the Oracle ODBC driver with Oracle 8. Microsoft's solution is to use the MS ODBC for Oracle driver. However, this driver gives me a different problem. If I use pass-through SQL and my select statement performs a sum (as in 'SELECT SUM( HOURS ) TOTALHRS FROM TIMESHEET') the field TOTALHRS is returned as type character!!! The values are correct but the datatype is wrong. The field being summed is defined as NUMBER 15,4. Given that my application is not specific to a particular backend, it's not feasible to use conditional code to convert the field.
>
>Anyone have any suggestions/solutions?
>
>Thanks,
>Jamie
Hi Jamie,
I faced same problem working with ORACLE 7.3 (UNIX). This problem also occurs with views. Eventually I decided to use ODBC driver supplied by ORACLE
CORPORATION. You can download this driver from oracle's web site that is 'www.oracle.com'. It is in shareware section. (Don't waste your time asking Oracle/MS online help because they even don't know the solution.)
Bye
Jayesh
- Jayesh