Hi,

At May 14, 2004, 17:46, jaguarius2003 wrote:

> Can anyone tell my why this code doesn't work?

What do you mean by "doesn't work"?
Is it an exception error?
Does the error occur when preparing the query, or when assigning
values to the parameters?
Is the query prepared before assigning the parameter values?
Not the expected result?
Which dialect is the database created with?
Which dialect are you connecting with?
Which server(Firebird or Interbase) and version are you using?

> I am using IB_Query
> components.

> SELECT WORKINGDOCKET.DOCKETID AS WORKDOCKETDOCKETID
> , DATEOPENED
> , DATECLOSED
> , COURTFILENUMBER
> , CLIENTTYPE
> , COMMENTSLINE
> , WTIMEENTRY.DOCKETID AS TIMEENTRYDOCKETID
> , WORKTYPE
> , TIMEW
> , COSTS
> , ENTRYDATE
> , CONTACTFIRSTNAME
> , CONTACTLASTNAME
> FROM WORKINGDOCKET INNER JOIN WTIMEENTRY ON WORKINGDOCKET.DOCKETID =
> WTIMEENTRY.DOCKETID
> INNER JOIN CLIENTS ON CLIENTS.SOCIALSECURITY =
> WORKINGDOCKET.SOCIALSECURITY
> WHERE WORKINGDOCKET.DATEOPENED BETWEEN :DATE1 AND :DATE2
> ORDER BY WORKINGDOCKET.DOCKETID, WTIMEENTRY.ENTRYDATE

> Its definitely this line WHERE WORKINGDOCKET.DATEOPENED BETWEEN :DATE1
> AND :DATE2

> that causes the trouble, and I assume its because the date1 and date2
> parameters are not specifically defined as timestamps - but I cant
> find anywhere to do that. I know when I was using ADO the parameter
> type had to be specified as datetime for it to work.

If WORKINGDOCKET.DATEOPENED is a timestamp, then DATE1 and DATE2
should be of timstamp type.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)