LOCAL oConn as "adodb.connection" >LOCAL oCmd as "adodb.command" >LOCAL oRs as "adodb.recordset" > >oConn = CREATEOBJECT("adodb.connection") >oConn.ConnectionString = 'Provider=VFPOLEDB.1;Data Source=C:\FOXTEST\testdbc.dbc;Password="";Collating Sequence=MACHINE' >oConn.Open >oCmd = CREATEOBJECT("adodb.command") >oCmd.ActiveConnection=oConn > >*-- Could do it this way, too, and not pass params to Execute method. >*-- oParam = oCmd.CreateParameter("?Cust_ID", 129, 1, 5, "ALFKI") >*-- oCmd.Parameters.Append(oParam) > >oCmd.CommandText = "USE VIEW1" >oRS = oCmd.Execute(null,"?Cust_ID")Should that read?
oRS = oCmd.Execute(null,"ALFKI")If not, I'm a little (or a lot<g>) confused. Where does the value of ?Cust_ID get set?