I'm building a Delphi multi-database application which was originally developed to work with Oracle. Now, I'm facing the message "column "userid" is of type numeric but expression is of type character varying" when I try to assign an integer value as a valid string like the code below.
Code: Select all
ClientDataSet1.ParamByName('userid').AsString := Trim(MaskEdit1.Text);
ClientDataSet1.Active := True;
How can I make a workaround there?