Can I use MODIFY to update a SQL table in WebFocus 7.6?
ThanksThis message has been edited. Last edited by: Kerry,
May
WebFOCUS 7.6.8 Servlet - MRE/BID/Self Service/ReportCaster - MS Windows Server 2003 - MS SQL Server 2005 - DataMigrator 7.6.9
April 17, 2009, 10:56 AM
Danny-SRL
Of course
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
April 17, 2009, 11:06 AM
May
Thanks.
May
WebFOCUS 7.6.8 Servlet - MRE/BID/Self Service/ReportCaster - MS Windows Server 2003 - MS SQL Server 2005 - DataMigrator 7.6.9
April 17, 2009, 11:16 AM
<JG>
May as Daniel says, yes you can used MODIFY as it is part of the standard license agreement.
However you can only use MAINTAIN if you have a license specifically for it.
April 17, 2009, 12:26 PM
May
Ok, I will check my licence agreement.
Thanks
May
WebFOCUS 7.6.8 Servlet - MRE/BID/Self Service/ReportCaster - MS Windows Server 2003 - MS SQL Server 2005 - DataMigrator 7.6.9
April 18, 2009, 08:21 PM
Jim Morrow
Another option is code UPDATE/INSERT SQL with Dialogue Manager viaable to pass the values. The use the SQL pass thought to send the SQL.
Either way the ID used for the connection will need update authority to the Data base / table.
Jim Morrow Web Focus 7.6.10 under Windows 2003 MVS 7.3.3
April 19, 2009, 01:56 PM
GamP
And, be aware that you can not do any interactive data entry using modify. It is just 'batch' data that you can process. Using maintain you can build interactive screens ...