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
Précédent
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