This topic is locked

Edit SQL Manually

9/16/2005 10:34:29 AM
ASPRunnerPro General questions
author

All,
This is just to let you know that the SQL Editor Pane will NOT vaildate any syntax regarding Field Names, Commas, etc. in the SELECT Clause. Fields in the where clause are validated, however.
Be sure to verify your SQL in some other editor first...
Otherwise, you will get a few cryptic error messages that take a while to track.
Kyle Hancock

Sergey Kornilov admin 9/19/2005

Kyle,
you are one hundred percent right. This page says advanced users only for a good reason.
In most cases you cannot say if syntax is correct without sending query to the database. Also in most cases database won't tell what exactly is wrong. As a rule of thumb I always recommend to test complex queries in native database enviroment.