sp_sql_add_dr_2

sp_sql_add_dr_2

This section is applicable to Virtual Ticket only.

This table modifier adds a digital resource to the database, using the parameters listed below. It is identical to the sp_sql_add_dr procedure described above, except for the optional @id parameter, which allows the user to specify the ID of the digital resource.

sp_sql_add_dr_2

 

 

Parameters

Value

Description

Notes

@object_handle

integer = null

The handle of the object.

 

@id

integer = null output

The ID of the DR.

 

@name

varchar(64)

The file/folder name.

 

@location

varchar(255)

The file/folder location.

 

@size

integer

The size of the file or -1 if it is a folder.

 

@type

varchar(255)

Document type of the DR.

 

@date_created

t_date_value

Date created.

 

@time_created

t_time_value

Time created.

 

@date_last_modified

t_date_value

Date last modified.

 

@time_last_modified

t_time_value

Time last modified.

 

@date_thumbnailed

t_date_value

Date thumbnailed.

 

@time_thumbnailed

t_time_value

Time thumbnailed.

 

@thumbnail_method

integer

Thumbnailing method.

1 - Get preview

2 - Sample

3 - Get icon

4 - Use standard icon

5 - Thumbnail pending

 

@mac_creator

varchar(4)

Mac creator.

 

@mac_type

varchar(4)

Mac type.

 

@keywords

text = null

Keywords, comma delimited

 

@keywords_info

t_string = null

A string that is a part of the select statement where the keywords are located. (i.e. 1 keyword from my_keyword where id = 1).

 

@thumbnail

image = null

Thumbnail.

 

@thumbnail_info

t_string = null

A string that is a part of the select statement where the thumbnail is located. (i.e. 1 thumbnail from my_thumbnails where id = 1).

 

@user_name

t_user_name = ‘Administrator’

The name of the user adding the DR (for history). By default, it is set to ‘Administrator’.

 

@extended_info

text = null

Extended info in XML format.

 

@extended_info_location

t_string = null

Extended info in XML format.

 

@ext_preview_format

varchar(255) = null

Extended info in XML format.

 

 


Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.