0

Verification functionality: add checking of SQL-Syntax if WHERE clause is used (for ex. in object...

I had added in a data base source table a clause "IDCheckAttribute = 1", this provokes in preview mode the message:

error opening data base reader. Incorrect syntax near '<'.

expected is clause "WHERE IDCheckAttribute = 1".
a) the correct syntax of SQL statement should be checked when pressing button "Start Verification"
b) the error message should be more precise and self-explaning!

... it needed 1 hour to find this mistake in my specification... !

 

0 comments

Please sign in to leave a comment.