Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating a View Primary Key
Message
 
To
24/01/2006 15:41:11
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01089683
Message ID:
01090277
Views:
24
>>>>Hi,
>>>>
>>>>I´m using a SQL Server Integer Identity Field to populate some Table´s Primary keys. My problem is that after updating the Table (everything goes fine), my the Primary Key of my Remote View is not updated.
>>>>What do I have to do?
>>>>
>>>>Regards,
>>>
>>>Issue a Requery() after you insert a new record (but only after that :o))
>>
>>Thanks Borislav.
>>The problem is that I don´t want to Requery the View. Just update the PK.
>
>Then just do with the view what you've done with the table. The view may be slightly out of sync with the table, or at least the oldval() would differ from current field content, but if you do it right, you should be fine.
>
>Disclaimer: this is the wrong way to do it, but if you do it right, it may be OK. I'd rather requery the view - it shouldn't take that long, because the table is already open, pretty much all you need is already in memory.

Dragan, I don´t think that I understood your first solution (mother languages problems). Could you please explain it to me?

Regards,
José Augusto Cavalcanti
Global Connection
jose.cavalcanti@globalconnection.com.br
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform