Database Query Builder: workaround please
David Wilkinson
dwilk at globalnet.co.uk
Thu Nov 13 02:56:36 EST 2003
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.
More information about the use-livecode
mailing list