Re: What is this Notation? : "{call pack.proc(?, {resultset 10..."

> "{call packperson.oneperson(?, {resultset 2, ssn, fname, lname})}"

This is the ODBC Procedure call ESCAPE syntax. This is documented in the ODBC Programmers Guide (from MS, included with MSDN docs). The '?' are replaceable parameters that will be substituted and bound by the driver.

If you use the native OLEDB provider, it will generate native procedure call code (something like BEGIN procedure(?,?); END;). The bind variables and replaceble parameters will still be represented by some sort of token.

--
-cheers
  DW
--------------------------------------------------------------------
"It is a kind of good deed to say well; and yet words are not deeds.
  -William Shakespeare"


Sent via Deja.com
http://www.deja.com/