Tag Archives: Visualforce Page

Save Record in Visualforce Page Without Fire of Validation Rule

Biswajeet   July 23, 2015   No Comments on Save Record in Visualforce Page Without Fire of Validation Rule

We can use immediate="true" in CommandButton & CommandLink, when we don’t want our validation rules to be fired during any server request.

Sample Code:

<apex:commandButton action="{!saveAccount}" value="Save" immediate="true"/>

Standard Page Layout Like Stylesheet For Inline Visualforce Page

Biswajeet   July 22, 2015   No Comments on Standard Page Layout Like Stylesheet For Inline Visualforce Page

Add below css into your visualforce page.
Sample Code:

<style type="text/css">
.bPageBlock {
	background-color: white !important;
	border-bottom: 0px !important;
	border-left: 0px !important;
	border-right: 0px !important;
	border-radius: 0px !important;
	border-top: 0px !important;
}
</style>

Difference Between Database.query() and Database.getQueryLocator()

Biswajeet   July 21, 2015   No Comments on Difference Between Database.query() and Database.getQueryLocator()

Database.query():

  • Database.query() allows to make a dynamic SOQL query at runtime. It returns a single sObject when the SOQL query returns a single record and it returns a list of sObjects when the SOQL query returns more than a single record.
  • We can retrieve up to 50,000 records using Database.query().
  • In Batch Apex, if we use Database.query(), it supports 50,000 records only.
  • If VF page doesn’t have read only attribute, use .
  • Use Database.query() in Visualforce page, if the readOnly attribute is false.

Database.getQueryLocator():

  • Database.getQueryLocator() returns a Query Locator that runs the selected SOQL query returning list that can be iterated over in batch apex and Visualforce page.
  • We can retrieve up to 10,000 records.
  • We can’t use getQueryLocator with any query that contains an aggregate function.
  • Use Database.getQueryLocator() in Visualforce page, if the readOnly attribute is true.
  • In Batch Apex, Database.getQueryLocator() supports up to 50 million records.
  • We can’t use the FOR UPDATE keywords with a getQueryLocator query to lock a set of records, In batch apex the start method automatically locks the set of records in the batch.