Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with CursorRefresh after adding a new record
Message
 
 
To
06/02/2007 16:23:54
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01192972
Message ID:
01193009
Views:
17
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform