Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tableupdate
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Tableupdate
Versions des environnements
Visual FoxPro:
VFP 6
OS:
Windows XP
Database:
MS SQL Server
Divers
Thread ID:
01008214
Message ID:
01008214
Vues:
64
Hi All:
I have a remote view that suppose to updates the data on sql server.
However, this remote view is not update anything. What am I doing wrong?

Here is my code

USE rv_regview IN 0 NODATA
APPEND BLANK
****
m.created = datetime()
m.creatorid = g_oApp.r_cUserId
m.batchdate = g_oapp.r_dBatchdate
m.batchcode = g_oapp.r_cBatchcode
m.rcvdate = g_oapp.r_drcvddate
m.housowe = 0.00
*08/27/2001
m.credenwho = null
m.credendate= null
m.dateconf = null
m.datebadge = null
m.conftype = null
m.noconfos = null
m.credentime= null
m.arrline = null
m.depline = null
m.arrdate = null
m.depdate = null
m.arrtime = null
m.deptime = null
m.arrflight = null
m.depflight = null
m.donotconf = 0
****
GATHER MEMVAR

=TABLEUPDATE(.T.,.T.) ** I think the problem is here. I am open to any suggestions.

Thanks
MA
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform