请教 project.exe raised exception class eoleexception with message "commandt

T

thomashukaidi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-14

• #1

请教 project.exe raised exception class eoleexception with message "commandtext change are not be allowed"(150分)<br />用socketconnection 和 adoconnection 写的多层应用
执行用的clientdataset1.commandtext :="select * from ..."

提示 project.exe raised exception class eoleexception with message "commandtext change are not be allowed"

 

T

taninsh

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-14

• #2

好像是服务端程序中应该把数据集关掉在改变sql text吧
没有测试

 

S

shangshang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-14

• #3

modify after close!

 

T

thomashukaidi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-14

• #4

//close 了 clientdataset1
sselect := 'select * from employee';
clientdataset1.Close;
clientdataset1.CommandText := sselect ;
clientdataset1.open ;

执行error project.exe raised exception class eoleexception with message "commandtext change are not be allowed"

 

J

jsxjd

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-14

• #5

关闭连接后才能进行修改！

 

D

dragonlee007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-15

• #6

来自：jsxjd, 时间：2002-11-14 20:55:00, ID：1432766
关闭连接后才能进行修改！

我覺得;
connection close
dataset close
modify command text
dataset open

 

W

wumeng

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-15

• #7

这个问题这样解决，在中间层服务器的RDM中，设置
TDatasetProvider.Options:=[poAllowCommandText]

 

T

thomashukaidi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-15

• #8

thank

 

W

wumeng

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-18

• #9

>>thank
问题解决了没有，如果已经解决，请结束本贴呀？！

 

T

thomashukaidi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-30

• #10

多人接受答案了。