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.
You may want an ORACLE PL/SQL book for the details of ORACLE commands like CASE statements. I had one from an ORACLE class a previous employer sent me to. Otherwise it's pretty much like any other SQL database.
>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
Previous
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