HomeActive Query Buildersetting QueryBuilder.SQL is causing the program to hang/crash/stop

setting QueryBuilder.SQL is causing the program to hang/crash/stop


Hi,

Certain SQL statements are causing the Active Query Builder to hang. Here is the schema and sql statement which is causing the Active Query Builder to hang.

http://cid-836b15b2b35822e3.skydrive.live.com/self.aspx/Code/ProblemWithActiveQueryBuilder.zip

Is there a way to TEST out sql statements before setting the SQL property?

Or perhaps you could tell me what it doesn't like and i'll strip out the problem parts of the sql statement.

Thanks

Dave
Dave Craft | email
May 21 2009, 06:40 AM
Use the following code to validate SQL statement:

MSSQLSyntaxProvider syntax = new MSSQLSyntaxProvider();
string errorInfo = "";

if (!syntax.ValidateQuery("select * from Orders", ref errorInfo))
{
MessageBox.Show(errorInfo);
}

We will investigate the problem and let you know about results.
Sergey Smagin | email
20 hours, 2 mins since original post
Hi,

Passing the SQL into the validate method still Hangs/Crashes the program. It just sits there i guess in some never ending loop. Without the source code I couldn't tell?
Dave Craft | email
23 hours, 57 mins since original post
This topic is closed