It would be could if it was possible to prevent an SQL error when a table
has a name with an SQL operator like a minus character.
My table's name was interpeted as an SQL string minus string substraction
witch isn't logical and breaks the original query we want to have.
Debbuged using this line (69) in file viewTableFrame.asp
response.write("<p><span>Debug code: the SQL query is</span> <span
style='color:#F20C0C;'>SELECT * FROM " & strTableName & strOrderSql &
"</span></p>")
(I normally dont put anything that would mess up the SQL but I imported
from somebody else's stuff so it took me a while to understand the
problem.)
Nobody/Anonymous
MyAccess
None
Public
|
Date: 2009-06-12 14:11 strSql = "SELECT * FROM [" & strTableName & "]" & strOrderSql |