TSimpleDataSet filtering

[bmarinel]

Hi,

I am trying to convert a simple BDE application to dbExpress in Delphi 7. I am using the dbexpsyb.dll library with a TSQLConnection. Then I connect a TSimpleDataSet. It seems to work until I turn on filtering. I can't get any records once I aply a filter. The same filter worked with the BDE. Any ideas?

Regards,

Bill

[VISOCO Support]

We have checked some simple cases but a problem was not found.
(Just assign a necessary expression to a Filter property and set Filtered to True)
Can you send any sample illustrating a problem to our support team (support@visoco.com) ?

[bmarinel]

I finally got it working. It seems that in my filter (with dbExpress) I have to pad my constant expression with trailing blanks.

If column is defined as a char(10), and I specify my filter as:

column = 'X'

It doesn't work. If I use:

column = 'X ' { X with nine trailing spaces }

It does work. I guess I will need to be very careful with trailing blanks. Other than this problem, things seem to be working pretty well. I have some more testing to do, but I am hopeful that I can use your product for my application.

Thanks for your reply.

Bill

[VISOCO Support]

There is a feature of the driver. It doesn't trim a trailing blanks of "char" fields.
So, a query