[Lazarus] Stored Procedure Params

Leonardo M. Ramé l.rame at griensu.com
Mon Nov 18 15:04:10 CET 2013


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,
-- 
Leonardo M. Ramé
http://leonardorame.blogspot.com




More information about the Lazarus mailing list