FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

Patrick Dunnigan wrote:
> Does dblib support the use of bind variables or placeholder syntax for
> sql statements?

db-lib does not support placeholders per se; that is, it does not support
any kind of syntax that uses '?' to represent a text-substitution
location.  

db-lib does have a set of functions that support calling stored
procedures: the rpc functions.  If you convert your query to a stored
procedure, you can use them.  

I do most of my db-lib work in C++, and find that the string-handling
features in the C++ standard library convenient for composing the SQL and
calling dbsqlexec(), easier than describing the parameter with
dbrpcparam().  But YMMV.  

HTH.

--jkl