Skip to main content

mSQL - Table Triggers and CreateUniqueRefField

Lauren Wheeler
  • Updated

msp_CreateTableTriggers 

Input Parameters:

  • Configuration file – the file path of the configuration file to be used when this procedure is run.
  • Datasource ID – specifies the data source to be used within the configuration file, which contains database connection string and table/column mappings.

Creates dynamic key update triggers on each table defined in the specified data source in the specified configuration file. This means that the keys table for the selected datasource will automatically be updated should records in the source data be modified in some way.

 

msp_DeleteTableTriggers

Input Parameters:

  • Configuration file – the file path of the configuration file to be used when this procedure is run.
  • Datasource ID – specifies the data source to be used within the configuration file, which contains database connection string and table/column mappings.

Deletes dynamic key update triggers on each table defined in the specified data source in the specified configuration file.

 

msp_GenerateSingleKeys 

Input Parameters:

  • Configuration file – the file path of the configuration file to be used when this procedure is run.
  • Datasource ID – specifies the data source to be used within the configuration file, which contains database connection string and table/column mappings.
  • Record ID – unique ref of the record to update the keys for.
  • Table Name – name of the keys table to be updated.
  • Action – “update” or “delete”

 

This method is called by the key update triggers on tables defined in the data source.  It updates, creates or deletes the keys entry(s) for the specified record in the specified data source.

 

msp_CreateUniqueRefField

Input Parameters:

  • Configuration file – the file path of the configuration file to be used when this procedure is run.
  • Datasource ID – specifies the data source to be used within the configuration file, which contains database connection string and table/column mappings.
  • Table name – table in which to create the primary key column.
  • Column name – name of the column to create.

Creates a primary key column with a specified name within the named table in the data source in the given datasource.