Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Having Trouble updating an updateable remote view
Message
De
24/01/2002 11:32:41
 
 
À
24/01/2002 10:12:43
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00609728
Message ID:
00609799
Vues:
15
Richard,

Sounds like you're not really using a Remote View since you say you're getting the cursor through SPT, so I'm not really sure what table you're attempting to TableUpdate(). I think you should probably update the table the same way ... with SPT.

~~Bonnie


>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.)
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform