The Programming Farmer

Musing, tips, tricks, on programming and farming. I am a technologist (CIO/CTO) at a pharmaceutical research company who also loves to grow fruits/nuts/berries/grapes/etc. Cyberspace plus dirt -- a great combination!

Thursday, December 9, 2010

I Just Saved a Lot of Time....

A number of Salesforce price updates were entered by hand (100s) and the "UseStandardPrice" flag was set to true. It should have been set to false. The data was fixed in a couple of minutes with SQLForce.



UPDATE PriceBookEntry SET useStandardPrice=false WHERE useStandardPrice=true AND pricebook2.isStandard=false

One line of SQLForce instead an afternoon of Apex batch...I love it.
Posted by Father of Eight at 3:20 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2015 (2)
    • ►  July (1)
    • ►  June (1)
  • ►  2014 (8)
    • ►  September (1)
    • ►  May (1)
    • ►  April (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (3)
  • ►  2013 (5)
    • ►  November (2)
    • ►  July (1)
    • ►  March (2)
  • ►  2012 (1)
    • ►  August (1)
  • ►  2011 (12)
    • ►  December (1)
    • ►  September (1)
    • ►  August (1)
    • ►  July (2)
    • ►  May (1)
    • ►  April (1)
    • ►  March (1)
    • ►  February (3)
    • ►  January (1)
  • ▼  2010 (15)
    • ▼  December (6)
      • Beware the Salesforce QueryOptions parameter
      • Cranking with CopyForceOracle
      • CopyForceOracle or Something else?
      • I Just Saved a Lot of Time....
      • Lovely Salesforce (for Non-Admin Users)
      • A Busy SQLForce week in Flyover Land
    • ►  November (1)
    • ►  October (2)
    • ►  September (1)
    • ►  May (1)
    • ►  March (1)
    • ►  February (3)
  • ►  2009 (1)
    • ►  August (1)
Picture Window theme. Theme images by sndr. Powered by Blogger.