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