Subject Re: [IBO] Firebird 2: "default" parameters in stored procedures
Author Martijn Tonies
Hello Dmitry,



> PARAMNAME=ParamValue
> begin
> for i:=0 to Pred(ParamCount) do
> begin
> if Params[i].IsNull then
> S:=FDefParamValues.LinkValues[Params[i].FieldName];
> if (S<>'') then
> begin
> if UpperCase(S)='NULL' then Params[i].Clear // set to NULL
> else Params[i]:=S; // set value
> end;
> end;
> end;
> end;

Not quite what I wanted :-) :-)

I do not want to supply any values myself, I want IBO not to pass
any values to the server, so that the server can use the default
values it has in its procedure definition.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com