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
SQL Query format error
Moderator: Nick Hunter
-
- Posts: 669
- Joined: Sun Dec 18, 2005 9:36 am
- Location: SpanSoft, Scotland
- Contact:
-
- Posts: 669
- Joined: Sun Dec 18, 2005 9:36 am
- Location: SpanSoft, Scotland
- Contact: