Avenue: SetFromTables won't take > 1 attrib

Avenue: SetFromTables won't take > 1 attrib

Post by Jarkko Kuoppam?k » Tue, 09 Jan 2001 17:40:40



Hi,

I'm trying to delete records from an SDE table by Avenue (ArcView 3.2)
with the following script:

      MyQuery = QueryDef.Make(SDEConnection)
      MyQuery.SetSelectColumns({"Shape", "Id", "Name"})
      MyQuery.SetFromTables({"table1","table2"})
      MyRSet = MyQuery.OpenRecordSet
      if (not (MyRSet.CanUpdate)) then
        ErrorList.Add ("Couldn't update recordset.")
      end
      if (MyRSet <> nil) then
        MyRSet.Delete("id = " + theId.asString)
        MyRSet.EndUpdate
        MyRSet.Close
      else
        ErrorList.Add ("MyRSet = nil.")
      end
    end

This results in error "A(n) nil object does not recognize request
CanUpdate".
However, if I use SetFromTables with either one of the arguments alone,
the script works fine, in other words deletes the records from table1 or

table2 - I'd like to delete them from both of them, something like
"delete from table1, table2 where id = 12345" in SQL. Is this possible?

Thanks in advance,

--Jarkko
please remove the 'removethis' section from my address if replying.

 
 
 

1. Excel 5 => Comparing Dates => won't work

I am having all sorts of trouble comparing two dates.

I have some historical records that have dates recorded on them using
a  cell.value = date  statement
now I want to delete all records more than 6 months old.   As in
something along the lines....
if date - cell.value > 180 then entirerow.delete.

I keep getting type mismatch errors, and every combination of
functions and types doesn't seem to help. I'm LOST!!!

Please can anyone help me.

Ted Gallop

Many thanks....

2. Free Agent Win-OS2 Setup Problem

3. Excel 5 ==>> Dates Comparison won't work

4. NCR stall -- normal condition?

5. Tape drive won't work, Scanner won' work Win 95

6. TDD Modems

7. Visio won't allow creation of <<responsibility>> as Comment

8. Excel and Schedule+

9. thats their email on the right >>>>>>>>>>>>>>>>>

10. ICD9->>SAS>>DRG's

11. <<<<EMERGENCY>>>> Can't LOAD QNX anymore

12. >>>>How 'bout dem Winstone archived programs?<<<<