>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
Can you give us a syntax for Update command and the structure of the view?
If it's not broken, fix it until it is.
My Blog