More Info from SQL monitor:

SELECT ALL T_RECORD.*
FROM T_RECORD
WHERE (T_RDATE > = AND '11/30/2000' AND T_RDATE AND < = '11/30/2000
11:59:59 PM' AND T_RTYPE = 'I')
ORDER BY T_RDATE ASC
, T_DRAWERCODE ASC

Where are these extra AND's coming from? Looks like a bug.

Thanks, Peter.

--- In IBObjects@egroups.com, peter@m... wrote:
> I'm getting an error message from the following filter. This
filter
> worked in early 3.6B version and prior but does not work now in
> TIBOTABLE with IBO 3.6Ca, Interbase 6.01, Deplhi 5.
>
> wwT_RECORD3.filter := 'T_RDATE >= ''' + datetostr(dailydate) +
> ''' AND T_RDATE <= ''' + datetostr(dailydate) +
> ' 11:59:59 PM'' AND T_RTYPE = ''I''';
>
> T_RDATE is a TIMESTAMP
> T_RTYPE is VARCHAR
>
> The error is:
> ISC ERROR CODE:335544569
>
> ISC ERROR MESSAGE:
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line3, char 16
> =
>
> Thanks,
>
> Peter
> MagnaPro