DB access:ODBC escape convert error
Posted: Sat Oct 02, 2004 10:33 pm
I^m trying to use the ParamaterRR field and getting the following error: DB access: ODBC escape convert error____Here is my environment:__. DB: PostgreSQL 7.03__. Default: {3/19/2004}__. Format: m/d/yyyy__. Prompt at runtime checked__. DisplayCaption: StartDate__. FieldName: StartDate____HARCODING method - This works in Filter:__TIMECARD.actionon is greater than or equal to {1/1/2004}__ShowSQL: timecards."actionon" >= {d ^2004-01-01^}____PARAMATERR method - DB access...error:__TIMECARD.actionon is greater than or equal to StartDate__ShowSQL: timecards."actionon" >= {d ^2004-03-19^}______Please help me!__Thanks...__Sergio__