Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » how to get sql server special data type(like image) via dtp's dse
how to get sql server special data type(like image) via dtp's dse [message #587089] Thu, 09 August 2007 07:51
Jet  is currently offline Jet Friend
Messages: 5
Registered: July 2009
Junior Member
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!
Previous Topic:how to get sql server special data type(like image) via dtp's dse
Next Topic:SQLResults and Editor Problems with Oracle timestamps
Goto Forum:
  


Current Time: Thu Nov 27 00:29:58 GMT 2014

Powered by FUDForum. Page generated in 0.01928 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software