Subject | Re: [IBO] Firebird 2: "default" parameters in stored procedures |
---|---|
Author | Martijn Tonies |
Post date | 2006-01-20T13:27:55Z |
Hello Dmitry,
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
> PARAMNAME=ParamValueNot quite what I wanted :-) :-)
> 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;
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