Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot see the updated value
Message
De
24/10/2001 07:56:35
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
23/10/2001 23:09:09
Jimi Lee
Pop Electronic Products Ltd.
Hong Kong, Hong Kong
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00572000
Message ID:
00572509
Vues:
28
Jimi,
No I didn't mean to create less tags. When a table is buffered accept its cdx is also buffered :
create table myTable (F1 c(10), F2 i)
index on F1 tag F1
index on F2 tag F2
close all

use myTable in 0 alias t1
use myTable in 0 again alias t2
cursorsetprop('Buffering',5,'t1')
for ix = 1 to 10
 insert into t1 (F1, F2) values (chr(asc('A')-1+ix), ix)
endfor
=seek('A','t1','f1')
? recno('t1')
lnRec = recno('t1')
go lnRec in 't2' && Record is out of range
go lnRec in 't1' && OK here
? seek('A','t2','f1') && .F.
tableupdate(2,.t.,'t1')
? seek('A','t2','f1') && .T.
go lnRec in 't2' && Record is out of range
go lnRec in 't1' && Record is out of range 
* lnRec was negative before tableupdate() now it has :
=seek('A','t1','f1')
? recno('t1')
You can do seek w/o changing aliases or orders if you use :
seek(cSearcExpr, cAlias, cTagName)
Cetin



>Oh :)
>Because when I use the current tag to do serveral actions, sometimes I encounter record out of range, and some other errors, I know this can be prevented by other methods but I just create more tags for different actions... are there any disadvantage to do so? I may change the code asap if there's some hidden risk..
>
>jimi
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform