Dear ut-user,
I would like to know if it is possible to run VFP set statements (set exact on, set ansi on) via the ADO.NET command object. I have made an attempt, but no luck, alas.
What am I doing wrong here?
myCon.ConnectionString = CFH.getConnectionString(); // external helper.
string sql = "runsetstatements()"; // vfp storedproc that executes.
OleDbCommand myCom = new OleDbCommand(sql,myCon);
myCon.Open();
myCom.ExecuteNonQuery();
sql = "SELECT * FROM zorglevr WHERE zoeknaam='B'";
myCom.CommandText = sql;
myRdr = myCom.ExecuteReader(CommandBehavior.CloseConnection);
The reader keeps returning results that it shouldn't accourding to the set statements. Perhaps, my approach is just totally wrong.
Thanks for giving attention to my problem.
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