Data Controls

Before adding a data or lookup controls, ensure all the required fields to map data to are added to the script.
 
SQL usage in CallScripter
 
1) Don’t use variables as they are re-calculated every time an agent moves from field to field, and page to page.  Write your data to a field, a hidden field if you do not display it anywhere in the script.
 
2) CallScripter places single quotes around field data e.g. ‘[Field]’
 
e.g.
 
Code in CallScripter will look like this
 
select * from table where id = [id]
 
The Query will be passed through in SQL with single quotes around the data field.
 
select * from table where id = '1'
 
3) When referencing a column with spaces in the name you would use square brackets however CallScripter will interpret this as a field reference.
 
Query in CallScripter will look like this
 
select * from [table with spaces in name] where id = [id]
 
The Query passed through in SQL will contain 'CsFieldNotFound ' in place of the column name.
 
select * from CsFieldNotFound where id = '1'
 
in order to get around these issue you would need to set quoted identifier on in SQL by placing the following Query at the top of your query
 
SET QUOTED_IDENTIFIER OFF
 
Please note the following knowledge base article relating to CallScripter SQL query substitution: