Information générale
Catégorie:
COM/DCOM et OLE Automation
I seem to have a lot of problem using ADO through VFP ODBC. It either doesn't work or it only works occassionally. Anyone knows why is that so? I can't make it work even if it is adCmdTable type.
oConn = Server.CreateObject("ADODB.Connection");
oConn.Open("logolist");
oRs = Server.CreateObject("ADODB.Recordset");
oRs.Open("SELECT * FROM logocategory", oConn, adOpenStatic, adLockOptimistic, adCmdText);
oRsLogo = Server.CreateObject("ADODB.Recordset");
oRsLogo.Open("select * from logolist where imageid=" + lLogoid, oConn, adOpenStatic, adLockOptimistic, adCmdText);
oRsLogo("category") = lCat;
oRsLogo("type") = "L*";
oRsLogo.Update();
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