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);

Comments

  1. 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.

    ReplyDelete

Post a Comment