Delphi TTable with filter does not work

From: Jan Doggen <massoft_at_tref.nl>
Date: Wed, 19 Sep 2001 21:02:38 +0200
Message-ID: <9oapp6$3td$1@reader05.wxs.nl>

Hi everyone,

we're accessing Oracle 8 tables through TCP/IP with Delphi 4 (+BDE).

TTables with a filter seem to randomly work/not work. We're using both design time filters and run-time filters allocated like:
> WITH DModConfig.TblTables DO
> BEGIN
> Filter := 'Tbl_Source_Module_ID = 5';
> Filtered := TRUE;
> Open;

The tables were created with SQL statements. They generally have a primary key on one field.
The app can also work with MS-SQL, there the filters work fine.

Any suggestions/ideas what we might be doing wrong or what we could try?

Thanks in advance,
Jan Received on Wed Sep 19 2001 - 14:02:38 CDT