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
by the way by default it shows 1000 in the data tab,can i change the value to say 10000 from the data tab or no. i mean i want it to show 1000 by default but i want to increase more records.how can i do it.now when i enter 10000,nothing seems to happen.am i missng something