Unknown data type of parameter MyInt64
Posted: Thu 16 Sep 2021 19:09
How come I am getting 'Unknown data type' even though help says this:
---------------------------
Project Project4.exe raised exception class Exception with message 'Unknown data type of parameter MyInt64'.
---------------------------
I could add its a BigInt but it never gets past Param parsing..Use Value in generic code that manipulates the values of parameters without the need to know the field type the parameter represent.
---------------------------
Project Project4.exe raised exception class Exception with message 'Unknown data type of parameter MyInt64'.
---------------------------
Code: Select all
procedure TForm2.FormCreate(Sender: TObject);
var LMyInt64: UInt64;
begin
Con.SQL.SQL.Text := 'INSERT INTO MyTable (MyID, MyLevel, MyParent, MyName, MyInt64)' +
' VALUES (:MyID, :MyLevel, :MyParent, :MyName, :MyInt64)';
Con.SQL.Params[0].Value := 1;
Con.SQL.Params[1].Value := 0;
Con.SQL.Params[2].Value := 0;
Con.SQL.Params[3].Value := '\';
Con.SQL.Params[4].Value := LMyInt64;
Con.SQL.Execute;
end;