SQLText=Text

Uses a SQL query to retrieve and assign values to the LabelX, LabelY, and XLProp=text parameters from the specified database table. This only occurs if no values were set for the mentioned parameters.

SQL query goes through the database table and uses the first field values that satisfy the specified criteria as values for the parameters.

for the chart if X,Y, or XL labels haven't been set. Sage CRM navigates through the fields in the table as defined in the SQL query and uses the first fields it finds and is able to use.

Values

Text. Specifies the SQL query to be used for retrieving and assigning values for the parameters. This must be a WideString value.

Examples

Chart = CRM.GetBlock('chart'): Chart.SQLText = 'Select * from OpportunityProgress Where '+ 'Oppo_OpportunityId='+OppId;