If you are sending queries, just create a string. For example:
oConn.Execute("Select * from x where y = .t.")
As long as you encapsulate the query in a string, you can handle things - regardless of environment...
< jvp >
>I have a logical field in one of the tables in my VFP database. I am trying to access the my database via ADO/ODBC connection and vbscript. While doing so, I am having to use .T. and .F. for true and false value in my queries to make VFP (ODBC driver) recognize my queries properly. I also have the database uploaded to Oracle and my scripts dont work because .T. and .F. are VFP specific. How is this issue generally handled? Is there any other way to address the true and false values in VFP?
>
>Thanx
>Gnana
Précédent
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