xe6
xe6,
i use the clientdataset to insert & update the records in sql .....
i'm getting error (cannot perform this operation on a on a closeddataset).
code :(cds27 : clientdataset)
CDS27.Close;
CDS27.Insert;
cds27.CommandText := 'Update Company Set Comp_psswd = :A where Compid = :B';
CDS27.params.ParamByName('A').AsString := GblPassword;
CDS27.params.ParamByName('B').AsString := Gbledtcompid;
CDS27.Post;
CDS27.ApplyUpdates(0);
i use the clientdataset to insert & update the records in sql .....
i'm getting error (cannot perform this operation on a on a closeddataset).
code :(cds27 : clientdataset)
CDS27.Close;
CDS27.Insert;
cds27.CommandText := 'Update Company Set Comp_psswd = :A where Compid = :B';
CDS27.params.ParamByName('A').AsString := GblPassword;
CDS27.params.ParamByName('B').AsString := Gbledtcompid;
CDS27.Post;
CDS27.ApplyUpdates(0);
Don't use Insert, Post and ApplyUpdates, it's just something like CDS27.Execute if you're using CommandText and it doesn't return a result set.
ReplyDeleteJean-Marc Kiener
ReplyDeletethanks marc