Parameters with Delphi 3 and IBODataset TDataset stuff is a little tricky.
Borland didn't separate their TParams stuff away from the BDE until version
4. Your problems may simply be due to a quirk that I have not come across
because I don't use Delphi 3 any longer for production apps.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Paul Schmidt" <paul@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, May 03, 2001 1:55 PM
Subject: [IBO] Parameters in 5,000,000 words or less


> Dear List:
>
> I am trying to figure out Parameters, and it is not going well:
>
> Here is the SQL:
>
> SELECT TIMECARD.HOURS, TIMECARD.START_DATE_TIME, PHASE.MYOB_TASK_NO,
> PHASE.DESCRIPTION, PROJECT.PROJECT_NAME,PROJECT.RATE_PER_HOUR,
> TIMECARD.HOURS*PROJECT.RATE_PER_HOUR AS CALCAMT
> FROM TIMECARD
> LEFT JOIN PHASE ON TIMECARD.PHASE_ID=PHASE.PHASE_ID
> LEFT JOIN PROJECT ON PHASE.PROJECT_ID=PROJECT.PROJECT_ID
> WHERE TIMECARD.START_DATE_TIME > :STARTDTTM
>
> As you can tell the Parameter is :STARTDTTM
> TIMECARD.START_DATE_TIME is defined as a DATE type under dialect 1
>
> I am using TIBOQuery to feed the result into ReportBuilder V4.23, the
> development tool is Delphi 3, and the parameter is filled thusly
>
> qryReport.ParamByName('STARTDTTM').AsDateTime := dtStart.Date;
>
> This gives back nothing, even when dtStart.Date is set to last week,
> and there are records from this week.
>
> I am using IBO V3.6.D.
>
> Anyone have a solution, or should I call The hairclub for men...
>
>
> Paul
>
>
>
>
>
> Paul Schmidt,
> Tricat Technologies
> Email: paul@...
> Website: www.tricattechnologies.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>