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 TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
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.
Anybody ever had a problem updating a Focus db? Until yesterday I had not, and I have used Maintain sence 4.3.6. I've tried all different varaiants, e.g.
FOR ALL REVISE column FROM stk;
REPEAT stk.foccount FOR 1 REVISE column FROM stk(index); ENDREPEAT
etc
Because it should have been finished yesterday (how unusual), I had to find a workaround. I type it out to a a normal text file and created a Master file for that, but it does'nt seem to be the idea of Maintain.
Any ideas?
We're on Win 2003, 7.6.10
HåkanThis message has been edited. Last edited by: Kerry,
What is the problem, does it not update anything ?, or some records ?
What is the structure of the FOCUS DB, are there cross referenced fields ?
Did you know that a REVISE is the "lazy" way to update records. It checked to see if the record exists, then either does an insert of update.
You could do the same in your code and check to see if the records exist, then update the existing, and input the new. with this method, you have more control.
it's so very simple(or that was my guess). A single segment Focus db, with 16 rows per Id and row No. I'm using two db, one is the first mentioned which i loop thru, comparing with the second one, which contains 16 dates. If the date in table 1 match the date in the second one, I'll put a mark in one of the columns in the stack of the first db. I can type it on the screen and on a text file, but it refuses to update the db.
You're not by any chance accidentily using stkA to update fileB, are you? I've come across this quite a number of times. Every time something like this happens, it's the first thing I look at and make 100% sure I use stkA ONLY for fileA etc. etc.
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007
thnx for your ideas. The problem was, a bit embarrasing, I must admit, there was another .mas with the same name in an app which was prior in the search order....