Forum Discussion

VishakhaB's avatar
VishakhaB
Visitor
10 years ago

DB connection query via notepad

Hello all, I have a very big query to be fetched from a notepad/sql file. Instead of passing an inline DB query like: strSQLQuery = "INSERT INTO " &strTblNM& " (" &strCols& ") VALUES (" &strVals& ...
Marsha_R's avatar
Marsha_R
Icon for Champion Level 3 rankChampion Level 3
10 years ago

Maybe there some implicit conversion happening when you do it inline.  

 

Try objCon.Execute eval(s)