>Paul,
>
>I connect to an ORACLE database (read-only) and the only "gotcha" I ran into was formatting of dates. If I were doing a specific query on a date, I would need to use '... WHERE TheDate = "Jan-10-1999"'
>
>The alternative is to say dMyDate = {01/10/1999} and then say '... WHERE TheDate = dMyDate' and let Fox convert for you.
>
>I am developing an application in Foxpro that will need to be used with Oracle as the back end in the future and was looking for information on the subject. If anyone knows of websites, usefull books or applications that would help, I would appreciate the input.
>
>Thanks,
>
>Paul

I do a lot of work with VFP 6.0 connected to an Oracle 7.3 database. When you're using ODBC into Oracle, your SQL statement has to be written using Oracle's "flavor" of SQL. Dates in Oracle are recorded and stored as numbers. Try this whenever you need to use a date in a WHERE clause (or just about anywhere else): TO_DATE('06/11/1998','MM/DD/YYYY')

To help us get up and running in Oracle, we bought a product called TOAD. There is a demo version but I don't have the URL here at home. It is a nice graphical interface for PL/SQL programming in Oracle. I had the company buy me a copy of PL/SQL Knowledge Base from the folks at http:\\www.revealnet.com\. They've got a demo version that you might want to look at. Their full version is rather pricey but it has done me more good than going to classes.

If I can be of any help, let me know.

Gregg