Page 1 of 1

SQL Query format error

Posted: Tue Jun 08, 2010 9:01 pm
by laschapas
Hi Nick,

There is a problem with how the SQL query window formats a query when the query SELECT statement will not fit on one line. I select a database in SQL query, select none of the selected fields, then add fields until the number of selected fields causes the query to spill into a following line in the query box. The line wrap causes the query to expect a FROM statement at the start of the new line. I can reproduce the error with the Sources, Pictures & Objects databases but not with the other databases. Working with the pictures database I can create the problem without the SELECT statement wrapping onto a second line. I only have to select RecordType, RecordCode, Code & Order, to create the problem.

I hope you can reproduce this problem,

John Wood

Posted: Fri Jun 11, 2010 8:38 am
by Nick Hunter

There does seem to be a problem with this. We will get it fixed in the next release.

Thanks for reporting this issue.

Posted: Tue Feb 15, 2011 9:11 am
by Nick Hunter
This was fixed in V3.1.1