Subject Re: [IBO] Fast Help with IB_DATE and PARAMNAME
Author radevojvodic
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.

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 then i can't pick date from drop
down calendar (it simply does not retrieve date value, in IB_Date you
can just type-in the date but can't pick one). When I left Datasource
property of IB_Date empty then i can pick value from dropdovn
calendar but then i have to assign stored procedure's parameter
values manualy(have to write code for it). 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?

P.S.
IB_DateTimePicker works the same way.

--- In IBObjects@y..., "Helen Borrie (TeamIBO)" <helebor@t...> wrote:
> At 06:48 AM 18-04-02 +0000, you wrote:
> >Hi,
> >
> >I have a
> >IB_StoredProc,
> >IB_Datasource.Dataset = IB_StoredProc.
> >IB_Date1.PARAMNAME = STARTDATE,
> >IB_Date2.PARAMNAME = ENDDATE
> >
> >If I assign IB_Date1(2).Datasource = IB_Datasource then I cant pick
> >date from a calendar. I still can enter date and call
> >IB_StoredProc.Updatedata to retreive param values before execute.
>
> TIB_StoredProc doesn't have an UpdateData method.
>
>
> >If I don't assign datasouce to IB_Date components then Updatedata
> >does not assign param values to storedproc but i can pick date from
> >calendar.
> >
> >What is the right way to setup properties to be able to pick dates
> >AND to assign parameter values to stored procedure.
>
> Please tell us:
> what kind of stored procedure is this and what are you trying to
use it for?
>
>
> regards,
> 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
> www.ibobjects.com