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

quote:

insert queries

must be an oxymoron (a phrase in which two words of contradictory meaning are used together for special effect, for example, “wise fool” or “legal murder”) - "insert" suggests Update, "queries" suggests Retrieval.

I stick the following code after every END statement (as well as other WF statements):

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

Hi,
Thanks for all the suggestions.
I solved the issue using READ command of WebFOCUS.
Thanks,
Shankar