Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Refresh
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00897786
Message ID:
00897828
Vues:
16
>I have 2 tables related by code on a form data environment. It works just fine. I have the parent table code stored in the form textbox and the corresponding information on the child table store to a combobox which has all the child´s records stored. Whenever I move the parent table the child move to the correspondent record. But when I choose a record from the child table and cancel the action on the form, the information from the parent table are all restore to the original data from the table, but the combobox remains with the selection I made. Is there any way to reallign the tables without moving the parent or seeking into the child. Something like:
>dataenvironment.cusror1.relation1.refresh
>I hope i made myself clear.

I'd say that what you need to do is save the current record number, issue a REQUERY(), the going to the original record number you've saved. In addition, if you issue a THISFORM.LockScreen = .T. before the requery, then set it to .T. after you've moved the record pointer, you'll get the results you're looking for.
George

Ubi caritas et amor, deus ibi est
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform