troubleshooting Question

Table / Cursor Needs Tableupdate

Avatar of fmoore0001
fmoore0001 asked on
FoxPro
11 Comments1 Solution1384 ViewsLast Modified:
I have a form that last some 200 tables opened that we buffer and require a TABLEUPDATE() for record additions and edits.   We have a routine called UpdateAll() that make an array of all table object  then runs through a check to TABLEUPDATE() all the tables:

For i = 1 TO LEN(atu[i, 1])
     m.lSuccess = TABLEUPDATE(.T.,.F., atu(i, 1))
ENDFOR

However, with some 200 tables some saves are quite lengthy and clients are complaining.  The fact is that while any of the 200 tables may be changed and require an update, usually it is only a couple of tables needing an update, but I have a feeling TABLEUPDATE is doing an entire scan of a table.

It stuck me if Foxpro has a routine to check IF a table/cursor has been changed (buffered?) THEN my TABLEUPDATE() routine could kick in, otherwise ignore that TABLEUPDATE.  VFP has routines for individual fields fields being changed, but is there a method to check if the table itself requires TABLEUPDATE?

Any ideas on that?

Frank
ASKER CERTIFIED SOLUTION
pcelba

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros