Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. David Edmunds

David Edmunds

Community Learner
Share
78Questions
79Answers
139.6KViews on questions

How can I skip trigger execution?

You can implement that logic by yourself. You can write an UtilClass to check if you execute or not the skip Trigger Logicpublic class ByPassUtils { public static Map triggerNameBypassed = new Map(); public static void ByPass(String triggerName){ triggerNameBypassed.put(triggerName,true); } public static void…

Salesforce

Answered May 1, 2023 · 660 Views Read answer →

How to decrypt md5?

By its very nature you cannot decrypt MD5. It's a one way hash algorithm. There are some sites that claim to decrypt certain phrases but all they do is store known phrases to return them. Reference Md5 (Message Digest 5) is a cryptographic function that allows you to make a 128-bits (32 characters) "hash" from any…

Salesforce

Answered Apr 28, 2023 · 1.5K Views Read answer →

Why a record cannot be updated in after trigger?

Apex triggers allow you to choose to run code at specific points in a database operation where the semantics are well defined: before trigger: before the database has been updated after trigger: after the database has been updated So by design, if the platform allowed modification of the record in an after trigger,…

Salesforce

Answered Apr 19, 2023 · 744 Views Read answer →

What to do when select permission was denied on the object?

If select permission was denied on the object- Database Administrators Receiving "The SELECT permission was denied on the object" even though it's been granted Asked 11 years, 3 months ago Modified 3 years, 9 months ago Viewed 54k times12I'm a programmer, not a dba... I know just enough to be dangerous. I've inherited…

SQL Server

Answered Mar 20, 2023 · 9.0K Views Read answer →

How to cast an interval postgresql?

date + interval → timestamp Add an interval postgresql to a date date '2001-09-28' + interval '1 hour' → 2001-09-28 01:00:00 SELECT to_timestamp('2020-01-10 08:00', 'YYYY-MM-DD hh24:mi')::timestamp without time zone at time zone 'Asia/Calcutta' - to_timestamp('2020-01-10 08:00', 'YYYY-MM-DD hh24:mi')::timestamp…

SQL Server

Answered Mar 17, 2023 · 1.1K Views Read answer →

What to do when #1698 - access denied for user 'root'@'localhost'?

In case of #1698 - access denied for user 'root'@'localhost' - 0. login to MySQL $ sudo mysql -u root use mysql; 1. Change Password UPDATE user SET authentication_string=PASSWORD('yourpass') WHERE User='root'; 2.Change Plugin UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE User='root'; 3. Finish It flush…

SQL Server

Answered Mar 16, 2023 · 822 Views Read answer →

How to speed up mysql update join query between 2 tables?

Your query should be taking a long time. Why ??? Look at your query: UPDATE content a JOIN peers_data b ON a.hash = b.hash SET a.seeders = b.seeders, a.leechers = b.leechers, a.is_updated = b.is_updated; Please note the columns begin mysql update join by the query in the content table: seeders leechers is_updated…

SQL Server

Answered Mar 14, 2023 · 672 Views Read answer →

How to return values for stored procedure in postgresql?

Both your sources are plain wrong. A FUNCTION basically always returns something. void at the minimum, a single value, a row, or a set of rows ("set-returning function", a.k.a. "table-function") - the only variant that can return nothing, i.e. no row. Called from within plpgsql code, you have to actively dismiss…

SQL Server

Answered Mar 14, 2023 · 8.4K Views Read answer →

Explain psql drop constraint?

Indeed the only good way to solve this issue of psql drop constraint seems to be to drop the constraint anyway by adding CASCADE to the SQL. Then you have to add back the constraints that were dropped. When the migration runs, flyway will see that some constraints were dropped and log. DB: drop cascades to 4 other…

SQL Server

Answered Mar 13, 2023 · 708 Views Read answer →

More members from the Salesforce community

Learners asking and answering questions on the same topics — follow their questions and join in.

Latest Salesforce Blogs

Guides, tips and career advice on Salesforce from JanBask experts.

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.