sp_sql_set_type_field

sp_sql_set_<type>_field

These pool modifiers are type oriented versions of the sp_sql_set_field stored procedure. They also check whether the field matches the type requirements.

sp_sql_set_char_field - This stored procedure is used for character fields.

sp_sql_set_char_field

Parameters	Value	Description	Notes
@handle	integer	The handle of the object for which you are setting the character field.
@field_name	t_field_name	The name of the field being set.
@field_value	t_char_value	The new value for the field.

sp_sql_set_int_field - This stored procedure is used for integer fields.

sp_sql_set_int_field

Parameters	Value	Description	Notes
@handle	integer	The handle of the object for which you are setting the integer field.
@field_name	t_field_name	The name of the field being set.
@field_value	integer	The new value for the field.

sp_sql_set_float_field - This stored procedure is used for decimal fields. Note that in Virtual Ticket/Job Manager, and Digital Storage Manager, decimals are mapped into Microsoft SQL float columns.

sp_sql_set_float_field

Parameters	Value	Description	Notes
@handle	integer	The handle of the object for which you are setting the decimal field.
@field_name	t_field_name	The name of the field being set.
@field_value	float	The new value for the field.

sp_sql_set_hdecimal_field - This stored procedure is used for decimal high fields.

sp_sql_set_hdecimal_field

Parameters	Value	Description	Notes
@handle	integer	The handle of the object for which you are setting the decimal high field.
@field_name	t_field_name	The name of the field being set.
@field_value	decimal(15,4)	The new value for the field.

sp_sql_set_date_field - This stored procedure is used for date fields, and accepts either datetime or varchar values.

sp_sql_set_date_field

Parameters	Value	Description	Notes
@handle	integer	The handle of the object for which you are setting the date field.
@field_name	t_field_name	The name of the field being set.
@field_value	t_date_value	The new value for the field.

sp_sql_set_time_field - This stored procedure is used for time fields, and accepts either datetime or varchar values.

sp_sql_set_time_field

Parameters	Value	Description	Notes
@handle	integer	The handle of the object for which you are setting the time field.
@field_name	t_field_name	The name of the field being set.
@field_value	t_time_value	The new value for the field.

NOTE: The following procedures work with blocks of 8000 bytes. It is recommended that you use sp_sql_blob_xxxx procedures to manipulate text or image objects/data. The procedures below are supported to provide compatibility with previous versions of SQL SDK.

sp_sql_set_memo_field - This stored procedure sets the first 8000 bytes memo field for the specified object.

sp_sql_set_memo_field

Parameters	Value	Description	Notes
@handle	integer	The handle of the object for which you are setting the memo field.
@field_name	t_field_name	The name of the field being set.
@field_value	varchar(8000)	The new value for the field.

sp_sql_set_memo_field_part - This stored procedure sets the nth 8000 byte block of the memo field for the object specified in the handle parameter. You must call sp_sql_set_memo_field to set the first 8000 bytes of the memo field. This block is considered as having a number.

sp_sql_set_memo_field_part

Parameters	Value	Description	Notes
@handle	integer	The handle of the object for which you are setting a part of the memo field.
@field_name	t_field_name	The name of the field being set.
@block_num	integer	The number of the block to be set.
@field_value	varchar(8000)	The nth 8000 byte of the field value to be written to the memo field.

sp_sql_set_blob_field - This stored procedure sets the value of the file collection field for the object specified in the handle parameter.

sp_sql_set_blob_field

Parameters	Value	Description	Notes
@handle	integer	The handle of the object for which you are setting the blob field.
@field_name	t_field_name	The name of the field being set.
@field_value	varchar(8000)	The first 8000 bytes of field value to be written to the file collector.

sp_sql_set_blob_field_part - This stored procedure sets the nth 8000 byte block of the file collection field for the object specified in the handle parameter. You must call sp_sql_set_blob_field to set the first 8000 bytes of the file collector field. This block is considered to have a number. The file collection field has the following structure: <file id>, <file id>, <file id>, etc., where <file id> is the ID of the digital resource you want to put into the collector.

sp_sql_set_blob_field_part

Parameters	Value	Description	Notes
@handle	integer	The handle of the object for which you are setting part of the blob field.
@field_name	t_field_name	The name of the field being set.
@block_num	integer	The number of the block to be set.
@field_value	varchar(8000)	The first 8000 bytes of field value to be written to the file collector.

sp_sql_set_type_field

Labels