>>didn't, but I was wrong), someone (Barbara?) suggested that the solution
>>may be to Use the table Again under another alias, and do all the
>>locomotion in it, not leaving the record in the buffer.
>
>This has been my practice for validating Social Security numbers. (Well not
>really USE AGAIN, but using two aliases of the same table in the DE of the
>form that does the checking). It works well, and I notice very little if
>any effect in form load.
>Supposedly using a table for the second (or third) time is much faster than
>the first use, but I have not found this to be significantly true. Many
>sources recommend that your application open all needed tables in the
>initialization of the app, so all DEs will effectively be using USE AGAIN,
>and forms will load faster. But my testing (private datasessions) showed
>only about a 15 percent improvement in form load in my more complex (read:
>use a lot of cursors) forms. This was just not worth the extra 20-25
>seconds it took the app to load while opening 80+ tables.
The practice of opening all the tables at startup was in common use by
our local Clipper programmers; due to various user's habits (like
leaving the app open while they go to lunch, having bad electricity with
lots of brownouts and blackouts), I've always sticked to the practice of
closing all the tables whenever I don't need them for the current task,
and opening only those I need. Saved me a lot of trouble.
I think that using the same table with two aliases is effectively Use
Again, so I'm glad to hear it's no big overhead. Seems to be the way to
go.
>> - how do the (updatable) views behave in this case, can they be Used
>
>This one I have not tried, but I am curious to know as well.
Now I've had to try, and it works. I've opened an updatable view
(underlying table is an Excel sheet), and it took a second or two to
open (as it always does). I've Used it Again, and it opened in a
millisecond. I browsed them both, and changed some value in one of them;
it refreshed when I switched to other window. Just nice.
