Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unable to update remote view
Message
From
17/05/2006 15:12:01
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Unable to update remote view
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01122950
Message ID:
01122950
Views:
56
I am trying to remove records from a report cursor in the BeforeOpen Tables method. This is for an accounting package using a MS SQL 2000 backend. When I try to delete and record and skip to the next I get the following error. "No update tables are specified. Use the Tables property of the cursor (Error 1491)" I have attached the cursor properties. I can not figure out why it will not let me update the cursor. Any idea what I am doing wrong?
AllowSimultaneousFetch     F

AutoIncError               T

BatchUpdateCount           1

Buffering                  3

CompareMemo                T

ConnectHandle              2

ConnectName                cnxReport

Database                   D:\TEMP\SZ0W8XBN.DBC

FetchAsNeeded              T

FetchMemo                  T

FetchSize                  100

KeyFieldList               id_col

MaxRecords                 -1

ParameterList              

Prepared                   F

SendUpdates                T

SourceName                 T05414361_14

SourceType                 2

SQL                        SELECT * FROM PROTEMP..t05414361_14 a_dttx WITH (NOLOCK)  ORDER BY a_dttx.jurid ,a_dttx.trptseq ,a_dttx.taxid ,a_dttx.empllast ,a_dttx.emplfirst ,a_dttx.prseqno, a_dttx.id_col

Tables                     T05414361_14

UpdatableFieldList         

UpdateNameList             prseqno prseqno, taxid taxid, jurid jurid, tliaacc tliaacc, texpacc texpacc, taxrate taxrate, taxamt taxamt, txblwge txblwge, stxwage stxwage, gtxwage gtxwage, taxprio taxprio, trptseq trptseq, prempl prempl, empllast empllast, emplfirst emplfirst, checkno checkno, ddseqno ddseqno, id_col id_col

UpdateType                 1

UseMemoSize                255

WhereType                       3
Next
Reply
Map
View

Click here to load this message in the networking platform