Hi All,
Theorical question:
Here's two formulations for the same update:
A- SqlExec (nConn, "update pmsyst set cFreeChar1 = ?CurTemp2.cPeriod " )
B- SqlExec (nConn, "update pmsyst set cFreeChar1 = '" + CurTemp2.cPeriod + "' ")
CurTemp2 is a temporary local cursor created in my foxpro program.
Are A and B equal in performance?
Does the formulation A require the server to ask the value for CurTemp2.cPeriod thus increasing network traffic?
TIA
Diane Robitaille eng.