SQL Query format error

Our genealogy database program.

Moderator: Nick Hunter

Post Reply
laschapas
Posts: 74
Joined: Tue Jan 24, 2006 9:48 am
Location: Derbyshire, UK

SQL Query format error

Post by laschapas » 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

Nick Hunter
Posts: 669
Joined: Sun Dec 18, 2005 9:36 am
Location: SpanSoft, Scotland
Contact:

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

Hi,

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

Thanks for reporting this issue.

Nick Hunter
Posts: 669
Joined: Sun Dec 18, 2005 9:36 am
Location: SpanSoft, Scotland
Contact:

Post by Nick Hunter » Tue Feb 15, 2011 9:11 am

This was fixed in V3.1.1

Post Reply