SupportSupport

Hello there,

I am using MSSql 2005 db and dbvis 8.07. the issue i have is in the Object view -- Data tab, when i enter a number to filter the col with that record,Dbvis does not return that row.but when i write i query like this it gets the row.

select * from receipt where
transactionNumber = 1059005503

why is it so. i also tried selecting the col in the filter.i have also attached a screenshot

cheers
Zold

Roger

thanks for your feedback. i also thought this was the case,so i increased the rows to 10000 and again typed the text in the search,but still it did not return the record.

Zolt,

The reason you still don't see any match is probably because the string you enter in the quick search does not match any of the rows in the result set displayed in DbVisualizer.

You should probably look into the "Where Filtering" feature which is used to limit the rows on the server side via a where clause. Read more here:

http://www.dbvis.com/products/dbvis/doc/main/doc/ug/databaseExplorer/databaseExplorer.html#mozTocId906372

This is also much better from a performance view since only the rows you are looking for will be handled.

Regards

Roger

Roger,

thanks for your help.appreciate it