Subject | Filter error with 3.6Ca |
---|---|
Author | peter@magnapro.com |
Post date | 2000-12-13T20:41Z |
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
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