Subject Re: [IBO] Fast Help with IB_DATE and PARAMNAME
Author Helen Borrie (TeamIBO)
At 11:20 AM 18-04-02 +0000, you wrote:
>I'm using IBO 4.2G, Delphi 6 and Ibase 6.
>When I let code completion to finish my statement IB_StoredProc1.Upd..
>Delphi will show IB_StoredProc1.UpdateData so I think that
>IB_StoredProc have UpdateData method.

IB_StoredProc has an EditSQL property - perhaps this is what you are
referring to. This property is only valid for a selectable SP (which is a
dataset) - not valid for one that has to be executed.

>But it is not so important now. I have an Executable stored procedure
>that should insert some records in one of my tables. Two parameters
>for the stored procedure are StartDate (date type) and Enddate.
>I tried to Use IB_Date to fill parameter values with properly
>configured Datasource and ParamName properties. Problem is that when
>i have datasource property assigned

You actually don't need to use data-aware controls for this task. You can
use regular TDateTimePicker and TEdit components when collecting parameters
supplied by the user. It's very small work to assign the parameters in the
BeforeExecute event...

>So, is there a way to use
>benefit of assigning datasource and paramname properties to
>automaticaly assign parameter values to stored procedure and still to
>be able to pick values from dropdown calendar in IB_Date component?

Yes. Use a TIB_Datasource (not a TDatasource) which you connect to the
IB_StoredProc. Type the name of the parameter into the ParamName property
to convert the control into a parameter input control and leave the
Datafield property BLANK. Make sure that the storedproc is prepared at the
time the user enters the parameter, otherwise it won't work.

If you are using IB 6, then it has a bug with stored procedures, where you
need to prepare an executable stored proc EVERY time before you assign new
values to parameters and call Execute. (I've gotten so used to using
Firebird, I had forgotten about this.)

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at