Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Buffering and Tableupdate()
Message
De
13/04/2006 11:55:26
 
 
À
13/04/2006 11:41:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01113462
Message ID:
01113479
Vues:
19
>If the controls on a form display and operate on data contained in a temporary cursor, how do you save the revised data back into the original table? I'm experimenting with the following code sequence to try and figure this out but I can't seem to get it right.
>
>
>select * from test_financing into cursor crstemp readwrite
>set multilocks on
>=cursorsetprop("buffering",5,"test_financing")
>select crstemp
>go top
>replace amount with 2000
>=tableupdate()
>
>
>Any help will be appreciated.

Don

1. You select the newly created cursor in which to do the change and buffer it, so TableUpdate()ing won't affect the test_financing table

2. Strikes me that the whole exercise is futile. With buffering, your changes are effectively made to the buffer and only reflected in the table after update. So why copy it all to a cursor too?

3. Even if you used a view, what's the point of having a view of the whoile unadulterated table, with no related data from others?

HTH

Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform