Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate(2) Question
Message
From
29/03/2002 11:23:44
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00638675
Message ID:
00638951
Views:
21
Hi Jim,

Thank you for replying to my post, here is as much information that I have currently have. However, I am able to re-create this error consistently so if there is more I can do to help you help me just let me know what I should do.

The line of tableupdate code (straight from the Hackers guide on table update) is
IF NOT TableUpdate(2, .T., laALIAS, aSaveErrors)
* force changes on all rows, but just in case, track
* any errors in an array
* You'll want something a little more sophisticated here.
set step on (my code so I could see the results)
WAIT WINDOW "Unexpected problem with " + ;
ALEN(aSaveErrors,1) + " records"
ENDIF

laAlias is the remote view name

TableUpdate(2,.T.,remoteview name, aSaveErrors) returns –1 in the array aSaveErrors

Cursorgetprop(‘Buffering’) = 3
Cursorgetprop(‘SourceType’) = 1
GetFldState(-1) = 112111111111
aerror(laError) as follows
LaError[1,1] = 10
LaError[1,2] = Syntax Error
(I stand corrected from my early post)

Table update returned "syntax error". I was unsure what this means because all I did was remove / delete 7 character from the end of this entry "$ 20 / 50% testing" so the value after editing was "$ 20 / 50%" (this is a character field in a remote view). Do you have any ideas? What else should I look for so you can help me with this issue.

Thank you for your help

Andy
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform