Database Query Builder: workaround please

[David Wilkinson]

This behaviour is observable in 2.0.1, although perhaps not as 
severely.

My experience is that there appear to be three iterations of the 
query loop, and they are repeated for each object on the card that 
is attached to the query.  Each iteration produces the error message.

FWIW, deleting the query seems to fix the problem here.  I also 
found using a stack with query & response fields and a submit button 
useful for testing/tuning  queries. Sarah Reichelt also has a very 
useful stack MySQLTests on her site, which shortens the learning 
curve considerably. 

 I did mention the issue in bug #630 but it was put off till later.

HTH



On Wednesday 12 November 2003 5:19 am, you wrote:
> I can't believe I'm the only one being hassled by this bug, so is
> there a workaround I am missing?
>
> In the Database Query Builder, Record Set tab, if you enter some
> bad SQL into the field labeled "SQL Query:", a popup error message
> says "An error resulted for the SQL command in the database ...".
> You click OK, then "SQL Query" field gets focus for a moment, then
> loses focus and the same modal error message pops up. Repeatedly.