Real simple question.
I have a table in my database that I would like to update using a webfocus .fex file. Is this something that is possible?

Is there another piece of software we would need to buy to update database tables using webfocus? If I just knew the name of the product I could get a demo.

Thanks!

This message has been edited. Last edited by: <Kathryn Henning>,

Yes it is possible as long as you have access to update in to the database.

Kamesh: what should I look for in the documentation to see an example of how to do this?

It's going to be a same way you write your SELECT sql.

SQL ENGINE SET SERVER CONNECTIONNAME
SQL SQLORA

UPDATE TABLE
SET COLUMN = VALUE
;

TABLE FILE SQLOUT
PRINT *
END
-EXIT

Hi Jason, You could use SQL, if the underlying DB understands SQL.

Or, you may be able to use MAINTAIN - but that is a WebFOCUS module that you would need to buy.

And, if you're willing to roll up your sleeves and write code i.e. no GUI!, then you could use MODIFY.

We use a combination of HTMLFORMs and MODIFY quite a bit for really simple Add/Update/Delete programs. I'm not sure whether anyone will give you a demo though ;-)

Look at Modify. It is simple and will probably solve your problem.

All of the commands are in the WebFocus Keysheet from Aviter..also maintain if you choose to go that route. But IMHO
Modify is simpler.

Vivian

Jason,
Use MODIFY: it is free.
If you need some help drop me a line.