Hello,

I am trying to append records from a local cursor into an updateable remote SQL view. This not only doesn't work, but gives me no error indicating failure. What am I doing wrong? Code is below:


lcAlias = This.OpenView('rv_Errorlog', DB_FULFILL)
loSelect = CREATEOBJECT('cSelect', lcAlias)
SELECT(lcAlias)

APPEND FROM DBF('ERRORS') &&local cursor

llsaved = TABLEUPDATE(.T., .T.)


TableUpdate always returns .T., even though no update occurred. If I put a SET STEP ON before this code and step into the APPEND statement, it goes through some error routines, but never displays an error.

TIA,

-Justin