Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Row updates from SQL based cursor
Message
 
 
À
07/08/2004 05:04:21
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00931295
Message ID:
00931568
Vues:
15
Derek,

Take a look at if mskb #Q138094 How to Create Updatable Views by Using SQL Passthrough> and faq #8153 How to make SQL Pass-Through cursor updatable


>I've tried that already, tableupdate() returns .T. so I've been unable to trace any error.
>
>I'm executing an SQL stored procedure to return 1 record, i.e. the selected user record that I'd like to edit. There are three records in my user table and although the SQL procedure will select any other those, it will ONLY update the very first record; strange.........?
>
>I've even played around with the record ID's and it still only allows updates on the very first record in ANY of my SQL tables.
>
>Would it have anything to do with the row/record buffering settings from within VFP itself?
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform