Re: FRM-40301 - Help needed on "trapping" this.
From: Neville Sweet <sweet.neville.nj_at_bhp.com.au.no_junk_email>
Date: Wed, 17 Nov 1999 13:43:30 +1100
Message-ID: <80t4tr$95f2_at_atbhp.corpmel.bhp.com.au>
Date: Wed, 17 Nov 1999 13:43:30 +1100
Message-ID: <80t4tr$95f2_at_atbhp.corpmel.bhp.com.au>
Hi Jim,
After you execute the query, check that it found something, eg.
Execute_Query;
IF Form_Success
THEN
go_item(
- etc. END IF;
> When the user calls up this form, the QUERY tab page is displayed
>and is in ENTER-QUERY mode.
>followed by an EXECUTE_QUERY statement that
>is then followed by a go_item (SUMMARY.FIELD1) statement.
>
> If data is found, the SUMMARY tab page is displayed and the cursor
>is on the first field of the first record. All is good.
>
> If however, no records are returned. FRM-40301: Query caused no
>records to be returned. The SUMMARY tab page is on top and the form
>is still in ENTER-QUERY mode. In this case I would like the QUERY tab
>page to remain on top.
Received on Wed Nov 17 1999 - 03:43:30 CET