Checking the Replace Select '*' with field names changes this code

! Embed Point of BSTBooking "Day" Before Header SQL Statement (resources).****

  EMPLOYEE{PROP:SQL}= ' SELECT ' &|

  '* ' &|

  ' FROM ' & 'EMPLOYEE' & ' ' &|

  ' ORDER BY  EMPLOYEEID '

! Embed Point of BSTBooking "Day" After Header SQL Statement (resources).****

to the following code:

! Embed Point of BSTBooking "Day" Before Header SQL Statement (resources).****

  EMPLOYEE{PROP:SQL}= ' SELECT ' &|

  ' EMPLOYEEID, SOCIALSECURITYNUMBER, FIRSTNAME, MIDDLEINITIAL, LASTNAME ' &|

  ' , ADDRESS_, ADDRESS2, CITY, STATECODE, ZIP ' &|

  ' , MARITALSTATUS, BIRTHDATE, DATEHIRED, JOBTITLE, DEPARTMENT ' &|

  ' , EMERGENCYCONTACT, EMERGENCYCONTACTPHONE ' &|

  ' FROM ' & 'EMPLOYEE' & ' ' &|

  ' ORDER BY  EMPLOYEEID '

! Embed Point of BSTBooking "Day" After Header SQL Statement (resources).****

If you are using external field names for the SQL tables that are different than the field names used in the clarion dictionary, you will need to check the Use "External Field Names" so the template has knowledge to use the correct Field names in constructing the Prop:SQL statements.

The Prepend and Append Characters default to those used for MSSQL and you will need to change them if your backend uses something else.  Caution: If you change the default characters, you need to go into The resource file and the appointment file and click on the Reset/Load Fields Button to reload the corrected external field names.

This code example shows a mix of regular field names, and some external field names.

BS_WorkOrder{PROP:SQL}='SELECT ' &|

'BS_WorkOrder_PK, BS_FK, People_FK, [Location_FK], [Copy]' &|

', [Status], [ServiceLocation], [Received], [Due], [DueDescription]' &|

', [ServiceDescription], [Canvas_Work], [Name_Work], [Upholstery_Work], [COD]' &|  ...etc