唧
唧唧歪歪
Unregistered / Unconfirmed
GUEST, unregistred user!
delphi 4.0 / sql server 7.0
有一表结构如下:
(
a char(6) not null,
b char(6) not null,
c char(6) not null,
d char(40) null ,
e char(20) null ,
f decimal(12,2) not null,
g datetime not null
default getdate(),
h int identity not null,
i char(1) not null
default '0'
constraint ckc_i_s check (i in ('0','1')),
constraint pk_s primary key (h)
)
问题:在BDE中通过ODBC连接该数据库表,在insert and update 是经常
出现以下错误信息,不知为何?
"BDE Error:13059 [$33] [$ 3]"
"
General SQL error.
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
"
=======================================================================================================
有一表结构如下:
(
a char(6) not null,
b char(6) not null,
c char(6) not null,
d char(40) null ,
e char(20) null ,
f decimal(12,2) not null,
g datetime not null
default getdate(),
h int identity not null,
i char(1) not null
default '0'
constraint ckc_i_s check (i in ('0','1')),
constraint pk_s primary key (h)
)
问题:在BDE中通过ODBC连接该数据库表,在insert and update 是经常
出现以下错误信息,不知为何?
"BDE Error:13059 [$33] [$ 3]"
"
General SQL error.
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
"
=======================================================================================================