You need to sign in to do that
Don't have an account?

Bulk uploader
Hi All,
This isn't really an APEX question but I still think you are the right crowd.
I've written a trigger on Account to catch the country field and populate a relevant tax field. Simple enough.
Now I want to run that query on all 30k account records that I have.
I thought I could just use the Bulk Uploader and perform an update on all Accounts and set Name=Name so that the trigger will execute. This works fine for about the first 56 records and then fails with 'Too many SOQL...'
Does anyone else have a good solution for this?
TIA
Can you post your trigger code?
I have two triggers on Account
and
and
thanks for your help.
You have SOQL statements inside your FOR loops, which is why you are exceeding the governor limits. See this link on how to code for "bulk" operations.
http://wiki.developerforce.com/index.php/Apex_Code_Best_Practices