Hello,

I have a simple html page (similar to a form) that takes in few inputs through text fields, dropdowns and other controls. I would like to save that input information as a record in a master file every time I submit the form. Given that, the master file has already been created with all the required input fields. Is this even possible through WebFOCUS? Does anyone know how to accomplish this? Could you also provide an example for it? Thank you for your help.

-Radhika

This message has been edited. Last edited by: <Emily McAllister>,

Radhika,

quote:

I would like to save that input information as a record in a master file

In what form?

Hi Daniel,

I am not sure what you meant by "in what form". I am trying to build a small web application (for my own learning purposes) and am not sure how to do the database connectivity. To give you a clear example -

TABLE FILE CAR
PRINT *
END

gives you all cars from ENGLAND, JAPAN, ITALY, GERMANY and FRANCE. And let us assume that this car synonym is built using the data in an excel sheet.

Now the user of the web application has the capability to add a new car or a country using a form in a html page and that information from the form should be saved as a new record in the database(in our case the excel sheet with car data should be updated dynamically). The insertion of a record should be done every time the form is submitted(checking uniqueness of the data that is if the give data already exists or not). If the user enters FORD car from USA which previously did not exist, then that information should be updated in the excel sheet so that, when you do a PRINT * on CAR.mas, it gives you all the records including the new records for the country USA.

I am not sure if I made myself clear enough. I would really appreciate if you have any idea on how to accomplish it or have any better suggestions to get it done. Thank you!

-Radhika

You must look at MAINTAIN or (maybe) MODIFY.
But according to your last post, I think that MAINTAIN will be a better solution.

Thank you Martin. That was helpful! ^_^