Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Requery, Index and Transaction
Message
From
21/02/2002 08:24:07
 
 
To
21/02/2002 07:59:33
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00622396
Message ID:
00623083
Views:
60
>>By the way, 'SourceType'=2 is for remote views
>
>I know. A line before the code exposed an assertion to suppress 'SourceType'=2.
>don't want to have untested stuff
>
>Do you run a test? If you say it works, I will incorporate.
>
>Agnes

Agnes,

Being hooked up via TerminalServer to a customer having an AS400, I have done
use SocLabel && remote view
index on nam125 tag nam125
index on nrwg25 tag nrwg25
?CursorGetprop('SourceType') && 2
=requery()
index on strt25 tag strt25 of (cdx(1)) additive
begin transaction && OK
end transaction
Note: dbf() returned the same values before and after the requery !!

But either way,
index on strt25 tag strt25 of (cdx(1)) additive
cannot hurt
Gregory
Previous
Reply
Map
View

Click here to load this message in the networking platform