Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Having Trouble updating an updateable remote view
Hello All;
I have a remote view of a SQL table which is updateable. At the end of processing my records, I change a flag to true and send a =TableUpdate() however, I get the message "Update Conflict" when my replace statement executes.
No records within that view are modified throughout the process until the last line of code, so in other words only 1 modification is made and it will not allow it! I've never seen this before.... any suggestions??
Your help is greatly appreciated!
P.S. - The SQL Table itself has no Primary Index, and the Remote View is actually a SQL Passthrough query (Select * from sqltable where id = ?thisform.idno and isinput = .F.)
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