Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Tableupdate
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01008214
Message ID:
01008214
Views:
65
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
Next
Reply
Map
View

Click here to load this message in the networking platform