Focal Point
User input data to a Focus Database

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1341069003

September 29, 2008, 05:52 PM
Daren
User input data to a Focus Database
I created reports that display valuable info from JDE.

I would like to allow the user to click a data point and allow them to enter comments, so later the next time the report is ran, a column showing the user input notes will be displayed.

What is the best way to do this?


Web Focus 7.6.5
JDE World
September 29, 2008, 08:22 PM
susannah
build you focus database
write a report that reads that database
write a drilldown on one of the fields
have the drilldown run a 2nd fex that produces
and htmlform that contains a dataentry form
have the Submit button on that form run a 3rd fex that performs a MODIFY with the &variables collected by the form and that MODIFY updates the original focus database, and then that same fex reproduces the initial report (fex #1) containing the updated data entered.
ok?



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
September 30, 2008, 08:54 AM
PBrightwell
Are you using JDE data with a cut off point (through end of previous month's invoices for example) or current data?


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
September 30, 2008, 12:02 PM
TexasStingray
Daren, If you are going to use a FOCUS database to allow multiple user to enter comments, you may need a license for the WebFOCUS DBMS Server also known as the FOCUS Sink Machine or SU.




Scott

September 30, 2008, 05:38 PM
Waz
Daren, There are several ways to do this.

Susannah's is the simple solution, I have done this my self.

Are you going to have a single lline comment or multiple?

Multiple lines may cause you problems. In 71 the FEX will error with 
(FOC257) MISSING QUOTE MARKS
.
In 76, the CRLF is removed.

You will have to change the CRLF to something else and CTRAN it back.

Your other option, if you are licenced for it, is to use Maintain.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!