Forum OpenACS Development: Response to Bind variable emulation in Tcl?
The only requirement is that expressions like:
foo_id = '123'
work, i.e. that integers can be quoted and will be interpreted as numbers. Oracle and PG both allow this (though the Oracle driver does
real bind vars, of course) and I think it's standard SQL 92.
Doing it at the Tcl level wouldn't be that hard - check out the regexps in the PG or Oracle driver that identify :tcl_var constructs.
But doing it right in nsodbc would be more efficient.