Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating a View Primary Key
Message
 
À
24/01/2006 15:41:11
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01089683
Message ID:
01090277
Vues:
23
>>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform