RE: Interrupt Problem

There was a bug Bz6081 http://www.4js.com/exclude/bugs/bz/tmp/issue_bz_6081.html that prevented the interrupt interrupting the OPEN
statement.  The FETCH would be interrupted OK but not the OPEN.  If the OPEN has an ORDER BY on a non-indexed column then this can
take a large amount of time and give the appearance of the interrupt not working.  This required a fix to fglrun, not the GDC but
I'm not sure which version, it was around Nov 2005.

Another thing I've run across was having a COMMAND "Interrupt" or ACTION interrupt in your 4GL stopped it working as well.  I  could
never figure out why my interrupt worked in my programs but not in my little test program, and it was because my test program had a
COMMAND "Interrupt".  Once I renamed that to COMMAND "TestInterrupt" it was ok.

Hope that helps,

Reuben

PS There is another mailing list for Genero users, contact your support office for details.  Looking through it I find 57 posts with
SQL interrupt in the title.

> -----Original Message-----
> From: [email protected] [mailto:[email protected]]On
> Behalf Of Adam Tommasi
> Sent: Thursday, 13 July 2006 6:45 a.m.
> To: [email protected]
> Subject: [fourjs-users] Interrupt Problem
>
>
> I've asked about this before but I am still unable to get this to work.
> I'm trying to get the interrupt action to stop an sql query from running.
>
> Here is my scenerio:
> - I've created an action default for the interrupt action,
> acceleratorname=Control-F12
> - In the program I have sql interrupt on and am checking for int_flag.
> - Running the latest GDC (1.33.1d), pressing control-F12 does nothing.
> I can however, press control-c from the fgltty to stop the query so I
> know the 4GL code is working as expected.
> Manually sending the process the interrupt signal using kill -2 also
> stops the query.
> It seems like the DVM is not sending the process the interrupt signal or
> the DVM is not receiving the interrupt from the client.
>
> I've attempted to set fglrun.signalOOB in fglprofile to 1 or 2 to no avail.
>
> We're running HP Tru64 Unix.
> Connecting using RLOGIN.
>
> Am I missing something? Is there anything else I should be doing?
>
> Thank you in advance for your help.
> ----------------------------------------------------------------------
> S&S Worldwide is the leading supplier of recreation products in North America.
> Our purpose is to improve the social fabric by helping people play.
>
> Learn more about us at http://www.ssww.com
>
> This e-mail is intended for the addressee only and may contain
> confidential information.  If you are not the intended recipient, you
> must not copy, distribute or take any action in reliance on this message
> or attachments.  If this e-mail has been sent to you in error, please
> notify me immediately by telephone or by e-mail.
>
>
>