SQL Query format error
Posted: Tue Jun 08, 2010 9:01 pm
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
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