There is something in the FAQ on this which could be a good start...
I would use "Microsoft ODBC driver for Oracle" from experience over the Oracle drivers they are highly unstable...
And I personally prefer the SQL transaction method rather than remote views...
via SQLEXEC(). I also read a good article somewhere in FoxTalk on the subject.
Several key things I recall about oracle.
1) An empty column is null on Oracle... so if you check for
EMPTY(column) you also need to do ISNULL(column)
2) There is no logical data type so you need to use 1 and 0
3) There are several reserved words example: COMMENT that you saidn't use as tablenames and identifiers
4)Use stored procedures where apppropriate...
5)Use bind variables on all sql example: "select * from styles where pk=?varpk"
Good Luck..
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