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