sp_sql_get_type_field

sp_sql_get_<type>_field

These pool viewers are type oriented versions of the sp_sql_get_field stored procedure.

sp_sql_get_char_field - This stored procedure is used for character fields.

sp_sql_get_char_field

Parameters	Value	Description	Notes
@handle	integer	The handle of the object from which you are retrieving the character field.
@field_name	t_field_name	The name of the field being retrieved.
@field_value	varchar(8000) output	The variable receiving the value of the field.

sp_sql_get_int_field - This stored procedure is used for integer fields.

sp_sql_get_int_field

Parameters	Value	Description	Notes
@handle	integer	The handle of the object from which you are retrieving the integer field.
@field_name	t_field_name	The name of the field being retrieved.
@field_value	integer output	The variable receiving the value of the field.

sp_sql_get_float_field - This stored procedure is used for decimal fields.

sp_sql_get_float_field

Parameters	Value	Description	Notes
@handle	integer	The handle of the object from which you are retrieving the decimal field.
@field_name	t_field_name	The name of the field being retrieved.
@field_value	integer output	The variable receiving the value of the field.

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

sp_sql_get_hdecimal_field

Parameters	Value	Description	Notes
@handle	integer	The handle of the object from which you are retrieving the decimal high field.
@field_name	t_field_name	The name of the field being retrieved.
@field_value	decimal(15,4) output	The variable receiving the value of the field.

sp_sql_get_date_field - This stored procedure is used for date fields.

sp_sql_get_date_field

Parameters	Value	Description	Notes
@handle	integer	The handle of the object from which you are retrieving the date field.
@field_name	t_field_name	The name of the field being retrieved.
@field_value	t_date_value output	The variable receiving the value of the field.

sp_sql_get_time_field - This stored procedure is used for time fields.

sp_sql_get_time_field

Parameters	Value	Description	Notes
@handle	integer	The handle of the object from which you are retrieving the time field.
@field_name	t_field_name	The name of the field being retrieved.
@field_value	t_time_value output	The variable receiving the value of the field.

NOTE: The following four procedures are the reverse of the set_memo and set_blob stored procedures mentioned below. They allow you to retrieve the contents of memo or file collector fields. They work with blocks of 8000 bytes. sp_sql_blob_xxxx procedures are recommended for manipulating text or image data. The procedures below are supported in order to provide compatibility with previous versions of SQL SDK.

sp_sql_get_memo_field - This stored procedure retrieves the first 8000 bytes of the memo field for the object specified in the handle parameter.

sp_sql_get_memo_field

Parameters	Value	Description	Notes
	integer	The handle of the object from which you are retrieving the memo field.
@field_name	t_field_name	The name of the field being retrieved.
@field_value	varchar(8000) output	The variable receiving the first 8000 bytes of field value.

sp_sql_get_memo_field_part - This stored procedure retrieves the nth 8000 byte block of the memo field for the object specified in the handle parameter.

sp_sql_get_memo_field_part

P arameters		Description
@handle	integer	The handle of the object from which you are retrieving part of the memo field.
@field_name	t_field_name	The name of the field being retrieved.
@block_num	integer	The number of the block to be retrieved.
@field_value	varchar(8000)	The variable receiving the nth 8000 byte block of the field value.

sp_sql_get_blob_field - This stored procedure retrieves the first 8000 bytes of the file collection field for the object specified in the handle parameter.

sp_sql_get_blob_field

Parameters	Value	Description	Notes
@handle	integer	The handle of the object from which you are retrieving the blob field.
@field_name	t_field_name	The name of the field being retrieved.
@field_value	varbinary (8000) output	The variable receiving the first 8000 bytes of field value.

sp_sql_get_blob_field_part - This stored procedure retrieves the nth 8000 byte block of the file collection field for the object specified in the handle parameter.

sp_sql_get_blob_field_part

Parameters	Value	Description	Notes
@handle	integer	The handle of the object from which you are retrieving part of the blob field.
@field_name	t_field_name	The name of the field being retrieved.
@block_num	integer	The number of the block to be retrieved.
@field_value	varbinary (8000) output	The variable receiving the nth 8000 byte block of the field value.

sp_sql_get_type_field

Labels