Board index » delphi » ADO for DB2

ADO for DB2

I'm using Delphi 6 ADO Command to update a AS/400 DB2 file.  The file
contains several packed decimal fields.  When I try to update one of these
fields (mfrprc below) I get the error message 'Type Name is Invalid'.  What
tecnique should I use to update DB2 packed decimal fields?

Thanks
Jim Burckhalter

  with ADOCommand do
    begin
      CommandText:='INSERT INTO devdata.mfritems '+
                  '(mfritm, mfrdsc, mfrprc ) ' +
                  'VALUES ( :mfritm, :mfrdsc, :mfrprc )';
      CommandType := cmdText;
      Parameters.ParamByName('mfritm').Value:=dxEdit2.Text;
      Parameters.ParamByName('mfrdsc').Value:=dxEdit1.Text;
      Parameters.ParamByName('mfrprc').Value:=dxCurrencyEdit1.Value;
      if NOT Prepared then Prepared:=True;
      Execute;
    end;

 

Re:ADO for DB2


hi,

sorry for not answering your question, but could you post the
connectionstring for ado and db2 ?

Thanks Max Odendahl

Other Threads