Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>(.t.) ". At this point the local view source table (People) is updated with all fields from the local view except for the key field (people_id). The key field (people_id) is correct in the local view but blank in the source table.
>>>
>>>This of course causes an update conflict when the second new reord is added, because both have blank keys.
>>>
>>>I made the key field updatable in the local view. This does not help. Local view has "Send SQL updates" checked, SQL where clause includes "SQL Key fields only" and Update using "SQL Update".
>>>
>>>I feel this is just a small thing I have overlooked, but I cannot pin down what it is.
>>
>>Is this a multi-table view? You might want to generate and look at the view code to see if anything unusual is happening.
>>
>>Dan
>
>No this is the simplest of views :
>
>SELECT *;
> FROM people;
> WHERE People.address_id = ?address.address_id
Can you post the code including all the update code. If you don't have code that will gen the views, I believe that Erik Moore has some code in the files section that handles this.
Dan
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement