Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2013-11

Stored Procedure Params

1 message · 1 person ·

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Leonardo M. Ramé

Hi, I have to pass parameters to a PostgreSql stored procedure, but when I try to use SqlQuery1.ParamByName('myparam') I get a null pointer.

The SqlQuery1.Sql.Text is "select * from mystoredproc(:param1, :param2)", and I'm trying to write param values as:

SqlQuery1.ParamByName('param1').AsString := 'value1';
SqlQuery1.ParamByName('param2').AsString := 'value2';

What I'm doing wrong?.

Regards,