S
sunwl
Unregistered / Unconfirmed
GUEST, unregistred user!
我在DELPHI中用代码动态创建一个表(DELPHI5+SQLSERVER 2000),
CREATE TABLE STUDENT(SID bigint not null IDENTITY,sbm varchar(14) primary key);
并建了索引create UNIQUE index IX_TSSY on STUDENT(sid);
此过程实现无问题,打开企业管理器查看也符合,但是当在DELPHI中对此表
进行APPEND、POST和Refresh时报错,信息为“Table does not support this operation
because it is not uniquely indexed.”为什么会报这样的错,如何解决呢?
CREATE TABLE STUDENT(SID bigint not null IDENTITY,sbm varchar(14) primary key);
并建了索引create UNIQUE index IX_TSSY on STUDENT(sid);
此过程实现无问题,打开企业管理器查看也符合,但是当在DELPHI中对此表
进行APPEND、POST和Refresh时报错,信息为“Table does not support this operation
because it is not uniquely indexed.”为什么会报这样的错,如何解决呢?