tedcarbone / excel-connector

Automatically exported from code.google.com/p/excel-connector
0 stars 0 forks source link

Query selected rows - query stops after error #35

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
First of all thanks for creating this, the excel-connector is brilliant.

I have a list of account IDs which need various fields updating.

To do this I run the table query wizard, select the object and then the fields 
and on step 3 close the wizard so I'm left with the relevant columns and a 
blank table.

I paste the IDs into the left most column then highlight the cells and select 
query selected rows and this populates all the columns and I can update as 
required.

All so far so good, the issue I have is with records which have been 
subsequently deleted, when I run the query and it hits an ID which no longer 
exists I receive the following error:

Salesforce: Update()
invalid Range, missing data type, or other error, type is: Account Object 
variable or With block variable not set

Understandable since the account record in question has been deleted but how 
can I get the query to carry on querying the other rows?

Currently I receive the error and the cell is highlighted in yellow, I skip the 
dodgy one and select the next bunch or rows and run the query again, it 
populates the data until it hits a deleted one and I again have to stop, select 
the next batch and run again which is very time consuming.

Many thanks in advance.

Dean

Original issue reported on code.google.com by ddv...@gmail.com on 28 Jun 2011 at 11:31