Setting Local Variables

wankdanker / node-odbc

ODBC bindings for node

MIT License

174 stars 79 forks source link

Setting Local Variables #70

Closed sjmorales closed 5 years ago

sjmorales commented 5 years ago

Hi,

Is there a way to do "SET :LOCALVARIABLE = SOME_VALUE" ?

The only work-a-round I could find is to read it as a table with "VALUES (SOME_VALUE)"

I was hoping there was a better way.

Thanks, Steve

markdirish commented 5 years ago

Hi Steve,

This seems a little outside the scope of the node odbc package, but what DBMS are you running? There is no API call in this package to set a local variable, you will have to do it with a query, and then use it according the restrictions of your DBMS.