Donate Share

MyAccess Online Database Editor

Tracker: Bugs

5 SQL error - ID: 2805471
Last Update: Comment added ( maxizinsane )

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.)


Maxime Lafontaine ( maxizinsane ) - 2009-06-12 14:01

5

Open

None

Nobody/Anonymous

MyAccess

None

Public


Comment ( 1 )




Date: 2009-06-12 14:11
Sender: maxizinsane

strSql = "SELECT * FROM [" & strTableName & "]" & strOrderSql
solves the problem


Log in to comment.

Attached File

No Files Currently Attached

Change

No changes have been made to this artifact.