SQL Server Field Type to store Reports

rbuser

What fied type should we use for storing report formats in MS SQL Server?
In Interbase I used a Blob field, I am not sure what to use in SQL Server.
Bill

nicocizik

Hi Bill,

Below is the SQL code we use to create the rbItem table in SQL Server. The
type used for the report template is IMAGE.

CREATE TABLE rb_item
(item_id INTEGER NOT NULL IDENTITY (1, 1),
folder_id INTEGER NOT NULL,
item_name VARCHAR(60) NOT NULL,
item_size INTEGER,
item_type INTEGER NOT NULL,
modified DATETIME NOT NULL,
deleted DATETIME,
template IMAGE,
PRIMARY KEY (folder_id, item_type, item_name, modified) );

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com