Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bug with views and tableupdate ?
Message
 
À
30/03/2000 10:06:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00352711
Message ID:
00352979
Vues:
17
Pascal,
What happens if the DLUD field in the second (not updateable) table is removed from the view? Does the update still have problems? Also, have you checked in the View Designer to be sure that the correct DLUD field is checked for updating?

HTH
Barbara

>I have a problem I'm fighting with since a while which I think is a bug (in VFP5.0) :
>
>I have a view which contains a table with several
>updatable fields and is joined to another table (without updatable fields). Both tables have a field called DLUD (which is a timestamp), but only the one of the first table is in the view (and updatable). When I try to update the field with the common name (DLUD) I get an update conflict. Updating the other fields in the view works as expected. I'm sure I'm picking the right field. I'm sure noone else is working on the tables so there can be no update conflict !!!
>When I force the update with tableupdate(2,.t.) then it works, as well when I use as WHERE clause only the key field.
>
>Anyone any idea ?
Barbara Paltiel, Paltiel Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform