SQL Yoga version 1.1.0 build 4 :: Visit website

Printer friendly version

command sqlrecord_set

Sets a property of a SQL Record object.

command sqlrecord_set @pRecordA, pProp, pValue, pPassThru
Parameters
TypeNameDescription
Simple parameter. @pRecordsA SQL Record object that you want to set the property for.
Simple parameter. pProp The property to set.
Simple parameter. pValue The value to set the property to.
Simple parameter. pPassThru Set to true if SQL Yoga should not quote and escape the value you set. This is useful when setting the value of an expression or a value like CURRENT_TIMESTAMP. Default is false.
Description

pProp can be either a built-in property, a column in the SQL Record's table or a custom property that you have defined in the Table Object for the SQL Record's table.

The built-in properties are:

@table: The name of the table to associate the SQL Record with.

@database: The name of the database object the SQL record is associated with.

@connection: The name of the database connection the SQL Record should use.

@passthru: A comma delimited list of fields that will not be escaped or quoted, but rather passed directly to the database as is.

If pProp is a custom property the the property would be defined in the 'table objects behavior' script for your Database Object. The function that will be called will be tableobj.set.TABLE_NAME.pProp. For example:

command tableobj.set.lessons.searchTerms pRecordA, pValue

Return

Error message