In the end three-tier database how to add data to the database ah? I used clientdataset.commandtext: = 'insert ....'; clientdataset.excute; but it says in the data set is opened

Category: Delphi -> Network Author: qq906231049 Date: 2006-06-11 18:44:42
 
qq906231049
2006-06-11 18:44:42
Delphi Network Programming / Distributed Development <> Mias development
not understand do not understand in;
little coming ~ ~ ~ ~ ~
related stickers child can go to www.nxit.net / bbs find the
TClientDataSet -> TProviderDataSet -> DataSet.SQLText: = ......;
TClientDataSet -> TProviderDataSet -> DataSet.Active: = False;
TClientDataSet-> TProviderDataSet.Options: = Options + [poAllowCommandText]
OK;
with TClientDataSet do
begin
Close;
CommandText; = 'Insert ... . ';
ExceSQL;
end;
get; if you paste it into Midas in or www.nxit.net / bbs, I think we should have buttoned up;
Good luck
joyce_zxj
2006-06-11 18:50:06
to come on, is a good place to have a lot of original information Oh
z64111369
2006-06-11 18:54:36
you this data set is, of course, is not allowed to open it
, you can use another ClientDataSet to update.
kangbing2009
2006-06-11 19:02:41
clientdataset.close;
clientdataset.commandtext: = 'insert ....';
clientdataset.excute;

connected with clientdataset DataSetProvider of poAllowCommandText should be set to true
skjinhao
2006-06-11 19:10:40
Upstairs is right
jianying0201
2006-06-11 19:15:25
Upstairs is right upstairs upstairs is also correct. I was right.
liangsong1990
2006-06-11 19:23:19
did not speak, do not mess! !

I have also been dealing with this issue, you said that the possibility of I do not exist, but there the same prompt (adoquery: cannt perform this operation on an open dataset) ! have expert help to look busy? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
catfishlin
2006-06-11 19:42:39
TClientDataSet -> TProviderDataSet -> DataSet.Active: = False ;/ / / is False
ExceSQL ;/ / / / / / / / Correction: Execute;
jsnjzoyo
2006-06-11 20:00:01
Landlord brother, little is right, I solved it. My QQ: 39058347 together to exchange it!
wangshawn123
2006-06-11 20:19:41
Oh, now in the cafe, so will try to go home. Thank you.