Hi,
I've two insert queries which are mutually exclusive.if my first query is successful then i want to skip the second one, and if first query doesnot do any insert then only i would like to get my 2nd query executed. Is there any keyword or syntax in WebFOCUS through which i could check whether a particular query was successful or not?
I am using Oracle8i,WinXP and WF713...
Thanks,
Shankar

Hi Shankar,

If you are using MODIFY for your inserts, then check out Statistical Variables
in Dialog Manager.

I do not know wether MAINTAIN is populating some variables also. And I am pretty sure SQL Passthrou will not. These two you would have to check out yourself.

Can you can post your code? This should be relatively easy to do.

Something like this should work
-*FEX1
TABLE FILE CAR
PRINT CAR
END
-IF &LINES GT 0 GOTO EXIT;
-RUN
-*FEX2
TABLE FILE CAR
PRINT SALES
END
-EXIT

-RUN
-IF &FOCERRNUM NE 0 THEN GOTO FOC_ERROR;