>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
>

You miss UpdatableFieldList

UpdatableFieldList  prseqno, taxid, jurid, tliaacc, texpacc, taxrate, taxamt, txblwge, stxwage, gtxwage, taxprio,
                            trptseq, prempl, empllast, emplfirst, checkno,
                            ddseqno, id_col && not sure about last field -> id_col 
*** Also in UpdateNameList pairs must include table:
UpdateNameList             prseqno T05414361_14.prseqno, taxid T05414361_14.taxid etc.