Re: Accessing Lookup Tables via API
Posted: Mon Mar 02, 2009 1:01 pm
Actually, several wierd occurences after testing further.
1 - I delete manually 1 by 1 records hundreds of records from the table via the SPAdmin-Managers-Lookups. There error continued to occur. Then I had already figured out how all the data was stored in the datamap table via columnmapid's entryid's, etc. When I selected from that table, I saw that none of the records that I manually deleted and saved (and kept opening and closing becuase I was testing the API at the same time), were deleted from this datamap table. Then I ran a delete statement, then my API did "somewhat" work.
2 - Even though the first GetTable worked with only 10 records in my Client (Copy) table, when I do another GetTable into another temp datatable to delete the record, it gives that same service entry point error again.
1 - I delete manually 1 by 1 records hundreds of records from the table via the SPAdmin-Managers-Lookups. There error continued to occur. Then I had already figured out how all the data was stored in the datamap table via columnmapid's entryid's, etc. When I selected from that table, I saw that none of the records that I manually deleted and saved (and kept opening and closing becuase I was testing the API at the same time), were deleted from this datamap table. Then I ran a delete statement, then my API did "somewhat" work.
2 - Even though the first GetTable worked with only 10 records in my Client (Copy) table, when I do another GetTable into another temp datatable to delete the record, it gives that same service entry point error again.