Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update SQL Express Table
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01415993
Message ID:
01415994
Vues:
57
>I am new to using SQL Express and have been having difficulty updating a remote table. Here's the scenario:
>
>I am querying a remote table residing on an SQL Express server using multiple joins. (Using SQL PassThrough commands. I am creating the view in code and using a connection string and SQLEXEC().) I then take the data and transfer it to VFP local tables. No problem, I was able to do this. I have a field on the remote table called the TransQueue which I want to update with a logical to indicate it was processed. I want to scan through each row in the remote view, and then update the FMS_processed field on the SQL table so when I query it again for unprocessed data, those records transferred will not be included in the query. I tried CURSORSETPROP's with nothing but errors. This seems to be a simple process but I'm hitting a wall....any help and/or code samples for this scenario will appreciated.
>I am using Win XP and VFP6 .
>
>Thanks in advance,
>
>Bill Todoro

Do you get the remote view to open? Does UPDATE myView SET FMS_Processed = 1
work?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform