Re: Database Query Builder: workaround please

[David Wilkinson]

On Thursday 13 November 2003 3:47 pm, you wrote:

> On the Database Query Builder, Record Set Tab, SQL query field:
>
> 1) enter some syntactically bad SQL
> 2) click the refresh query button (or close the Database Query
> Builder window)
> 3) now Rev gets stuck in an endless loop of modal error dialogs.
>

OK  The handlers appear to be identical, though I have not stepped 
through as yet.  However it is clear that on Linux and 2.0.1, the 
behaviour is not so extreme as you have reported, no matter what 
sort of garbage I enter in the query field.  By the way, I did not 
say three times , but three times for each db object, though I did 
not figure out how that observation could be true.  

Does the query builder work for you, if you enter syntactically 
correct sql?  If so,  why not  debug the query outside the query 
builder for the timebeing?Moreover, queries that attach to field 
objects, generally, are not very sophisticated : maybe an inner join 
between client_id  from invoice and client tables for example, in 
order to show the client name, or select detail rows corresponding 
to an invoice.  The Query Builder  is clearly designed to return a 
record view of each row.  In the end, I am not sure that the by 
field/column interrogation of the db is going to be fast enough 
though showall fields seem pretty quick.
___
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: Database Query Builder: workaround please

[Alex Rice]

On Nov 13, 2003, at 12:56 AM, David Wilkinson wrote:

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.
David, I think you are talking about something else. What I am seeing 
is a bug. A GUI bug, and doesn't have anything to do with the query 
loop going for 3 iterations.

On the Database Query Builder, Record Set Tab, SQL query field:

1) enter some syntactically bad SQL
2) click the refresh query button (or close the Database Query Builder 
window)
3) now Rev gets stuck in an endless loop of modal error dialogs.

The problem is this code in revDBQuerySetup stack / recordSet card. The 
SQL is evaluated, causing a modal error dialog, causing the keyboard 
focus to leave the field, then reenter it the field. Then another 
closeField fires, another modal error dialog. Endlessly.

on closefield
  put the cActiveQuery of this stack into tActiveQuery
  put revQueryLongName(tActiveQuery) into tObjects
  revSetSQLOfQuery tObjects,the text of me
  if revCursorOfQuery(tObjects) is not empty then
revUpdateRecordSourceDetails
  else
set the label of button "cREVDatabaseQuery[primarykey]" to "None"
disable button "cREVDatabaseQuery[primarykey]"
  end if
end closefield
So Runrev- the Database Query builder is effectively useless. How about 
a fix? I can't just comment out the handler, because then the query is 
not evaluated at all.

Alex Rice <[EMAIL PROTECTED]> | Mindlube Software | 


what a waste of thumbs that are opposable
to make machines that are disposable  -Ani DiFranco
___
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: Database Query Builder: workaround please

[Pierre Sahores]

Le mer 12/11/2003 Ã 06:35, Alex Rice a Ãcrit :

The same difficulties under Linux and Jaguar there...

> On Nov 11, 2003, at 10:19 PM, Alex Rice wrote:
> 
> > I can't believe I'm the only one being hassled by this bug, so is 
> > there a workaround I am missing?
> 
> And I mean other than *not using the query builder at all*.
> 
> It is appealing to use the GUI to maintain connections and recordsets, 
> and doing scripting only where necessary.
> 
> Alex Rice <[EMAIL PROTECTED]> | Mindlube Software | 
> 
> 
> what a waste of thumbs that are opposable
> to make machines that are disposable  -Ani DiFranco
> 
> ___
> use-revolution mailing list
> [EMAIL PROTECTED]
> http://lists.runrev.com/mailman/listinfo/use-revolution
-- 
Bien cordialement, Pierre Sahores

100, rue de Paris
F - 77140 Nemours

[EMAIL PROTECTED]

GSM:   +33 6 03 95 77 70
Pro:   +33 1 41 60 52 68
Dom:   +33 1 64 45 05 33
Fax:   +33 1 64 45 05 33

Inspection acadÃmique de Seine-Saint-Denis
Applications et SGBD ACID SQL (WEB et PGI)
Penser et produire "delta de productivitÃ"
___
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: Database Query Builder: workaround please

[Alex Rice]

On Nov 11, 2003, at 10:19 PM, Alex Rice wrote:

I can't believe I'm the only one being hassled by this bug, so is 
there a workaround I am missing?
And I mean other than *not using the query builder at all*.

It is appealing to use the GUI to maintain connections and recordsets, 
and doing scripting only where necessary.

Alex Rice <[EMAIL PROTECTED]> | Mindlube Software | 


what a waste of thumbs that are opposable
to make machines that are disposable  -Ani DiFranco
___
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution

Database Query Builder: workaround please

[Alex Rice]

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.

Now I've tried Command-period and I've tried to turn off the Messages 
using the Messages toolbar item, but neither has any effect because Rev 
is stuck in this loop of modal dialogs. So - I have to force-quit 
Revolution?

See bugzilla #696. This bug was opened 7 weeks ago.

Alex Rice <[EMAIL PROTECTED]> | Mindlube Software | 


what a waste of thumbs that are opposable
to make machines that are disposable  -Ani DiFranco
___
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution