Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View values
Message
De
21/01/2002 10:10:38
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00606715
Message ID:
00607744
Vues:
39
>>>>Yes views are buffered but why ? curval() returns on disk value. You could test that with an SQL select which always returns on disk values.
>>>>Cetin
>>>
>>>
>>>Cetin,
>>>
>>>Sorry to be a bore but
>>>
>>>Curval(, )
>>>
>>>doesn't return the tables current value just the last values collected by requery!
>>
>>Caroline,
>>You or someone else has never been a bore to me :)
>>I think Thomas filled the gap (wish he were here at the first place:). Curval() returns values from disk but when it's a view you need a refresh() :
>>
>>Refresh(1,0,'myview')
>>For ix=1 to fcount('myview')
>>  luOld = oldval(field(ix,'myview'))
>>  luNew = curval(field(ix,'myview'))
>>  If luOld # luNew
>>    Messagebox( 'Field : '+field(ix,'myview')+' has been changed :'+;
>>      chr(13)+ 'From  : '+trans(luOld)+;
>>      chr(13)+ 'To    : '+trans(luNew) )
>>  Endif
>>Endfor
Cetin
>
>Cetin,
>
>I believe that this is exactly what I want However, Refresh will only work for a REMOTE view not a LOCAL view - so what are you supposed to do with Local views?

Caroline,
It's working on local views too.
Cetin
Ç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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform