Docs: SpeedGen: RecordSource Field Markers

RecordSource Field Markers are used in a Source Workbook to specify where data from a database will be inserted. Whenever a Field Marker is found, it will be replaced with the corresponding data or blanked out if there is none. You can specify RecordSource Field Markers by Name or Index.

If you have more than one row of data then SpeedGen will stretch the rows of the Spreadsheet to accommodate the inserted data. ( unless you disable Stretching )

Sample Picture of Source Workbook using RecordSource Field Markers

• You can use Aliases to isolate your Source Workbook from the structure of the underlying data.
• Fieldname Markers will insert the names of the Fields.
• You can use RecordSource Field Markers to insert an unknown number of fields. Any extra fields will be blanked out. But you should still use the minimum required since extra fields result in extra processing and thus slower performance.
• Use the #across command to insert data from Left-to-Right across the spreadsheet
• Use the #b command to convert Numeric Data to Boolean

  Sometimes you might have a database with Boolean fields represented as numeric data (e.g. 1 or 0) instead of real Boolean values. You can force SpeedGen to interpret those numbers as Boolean values.

  Just append the #b specifier to the end of your Field Marker and any values of 0 will be interpreted as False and any non-zero values as True.

  Example

  >>2^Retired#b means:

  Insert the "Retired" Field from the 2nd RecordSource into this cell and treat it as an Excel Boolean Type (even though it is a Numeric value in the database)

• This Spreadsheet contains many Index Field Markers, so you can just cut and paste them into your spreadsheet.

Click here to find out how to use RecordSource Field Markers

Fieldname Markers and Specifying by Index Sample

• SpeedGen ASP
• SpeedGen Desktop

Other Samples

• SpeedGen ASP Sample
• SpeedGen Desktop Sample

Most of the Samples use RecordSource Field Markers, so you can look at those also.