| how to get sql server special data type(like image) via dtp's dse [message #34222] |
Thu, 09 August 2007 03:51 |
Eclipse User |
|
|
|
Hi:
i create a table in sql server 2000, just as follow:
CREATE TABLE [dbo].[testtable1] (
[id] [numeric](18, 0) NOT NULL ,
[parentid] [numeric](18, 0) NULL ,
[Ttext] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[Tfloat] [float] NULL ,
[tchar] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[Tbinary] [binary] (50) NULL ,
[tvarchar] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[tdatatime] [datetime] NULL ,
[timage] [image] NULL ,
[tint] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
when i view the new table in DES, i can see all fields but can not get the
timage field type.
then i want to edit data in the table by popup menu item "Edit", the
system give me a message " An unknown or unsupported data type encountered
for column timgage.,"
Has anyone give me some advices,thanks in advance!
|
|
|
Powered by
FUDForum. Page generated in 0.05157 seconds
Home