HI,
I am inserting the data in focus db uisng MODIFY procedure in my application . Data is inserting properly focus db , but not able see inserting data in my application with out cosing seesion . if close the session(application) and then only able to see inserted data.

I used SET COMMIT=ON, even though not able to see.I inserted data like below command


SET COMMIT =OFF
-RUN
MODIFY FILE EMP
MATCH EMPID
-------
-------
----------
DATA
--------
---------
--------,$
END
-RUN
SET COMMIT =ON
-RUN

please suggest how commit db properly, i am using first time this modify procedure.

This message has been edited. Last edited by: pink,

You should not SET COMMIT OFF before running your MODIFY procedure - if anything SET it ON. WebFOCUS should automatically issue a COMMIT at the end of the MODIFY process.

SET COMMIT = ON
-RUN
-*
MODIFY FILE EMP
MATCH EMPID 
-------
-------
----------
DATA 
--------
---------
--------,$
END
-RUN 

MODIFY FILE CAR
FIXFORM COUNTRY/10
MATCH COUNTRY
ON NOMATCH INCLUDE
ON MATCH   GOTO TOP
DATA
INDIA
END
-RUN

TABLE FILE CAR
PRINT
COUNTRY
END
-RUN

COUNTRY 
-------
ENGLAND 
JAPAN 
ITALY 
W GERMANY 
FRANCE 
INDIA 

I suggest getting a copy of the WebFOCUS Modify manual and make it your friend.

WebFOCUS Modify Reference

Thanx Dan n Francis
Thanx jgelona for ur suggestion, i already have that manual , but due to some other issue I was confused