 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] Question About MODIFY | Login/Join |
| Platinum Member |
I'm migrating a daily file creation process from MS Access into WebFOCUS. The current process: 1. Select all records where the "Send" field equals 1. 2. Save the records resulting from #1 to a TABT output. 3. Update all the records where the "Send" field is equal to 1, so that they equal 0. Will the MODIFY command allow me to update the field values in a data source table from my WebFOCUS query code?This message has been edited. Last edited by: Kerry, Production - 7.6.4 Sandbox - 7.6.4 | ||
|
| Virtuoso |
Yes, as long as your iWay server has update access to the data source. WebFOCUS 7.7.05 | |||
|
| Expert |
MODIFY does not update Flat files. What is the source file type ? Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Virtuoso |
I would assume it's just MS Access since that's what he's migrating from. For updating flat files (which is rare because there's usually a better way), just redefine the field and output (i.e. SAVE) it again. Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Expert |
You know what happens when you assume....  Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Platinum Member |
It is a MS Access Back-End database, that I have migrated the tables up to SQL Server so that I can connect them to WebFOCUS. I then take the data from the table records, and build a text file as the final output that gets sent to a vendor. So I'm hoping that I can use WebFOCUS to update the boolean field (it is actually just numeric that stores a 0 or a 1) in the table record to indicate that the record has been sent to the vendor. Production - 7.6.4 Sandbox - 7.6.4 | |||
|
| Expert |
If its just a numeric, then this should be simple. You do need to make sure that your connection to access is updateable. It would be along the lines of: TABLE FILE ..
COMUPTE BOOL/I1 = 1;
BY KEY
WHERE {Remove other values not to be updated}
ON TABLE HOLD AS LOADFILE
END
MODIFY FILE ..
FIXFORM FROM LOADFILE
MATCH KEY
ON MATCH UPDATE BOOL
ON NOMATCH REJECT
DATA ON LOADFILE
END
Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Virtuoso |
You didn't test this, did you? GamP
| |||||||||
| ||||||||||
| Expert |
Yes I Did.... Must be the l;ong list of LET statements to correct my typign prolbens. Just add LET COMUPTE = COMPUTE to the code.  Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Virtuoso |
 makes my day...
| |||||||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |