Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with CursorRefresh after adding a new record
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01192972
Message ID:
01193009
Vues:
16
>>When I refresh CA after tableupdate I still don't get PK in my CA, it remains empty.
>>
>>In other words, I add a new record to the parent table, I save the information and now I need to add a record to the child, but I keep receiving the message that I need to save the parent first (since my ID is still empty).
>
>OOOOO, that is the case. Then you need a way to get the parent ID Before you save the records in child CA.
>Add the parent record and add all child records you need. Then:
>BEGIN TRANSACION
>1. Save the record in Parent table
>2. Get the PK from parent
>3. REPLACE ALL Fk WITH Parent.Pk in Child
>4. Save Child Records
>END TRANSACTION

No, I decided against this already. After I add a new record to the parent, I need to save it first. I do save it, but after I do CursorRefresh I still do not get my ID in the CA alias. That's my problem. Since you now have all the source code, you may be able to see what my attempts are.

Thanks a million again for your generous help.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform