Strange database behaviour

[Ivan Smahin]

Hello Vansh,

Friday, August 14, 2009, 6:49:16 PM, you wrote:

> Hi,

> I have a Valentina database that was created by Valentina 4.0 Xtra

> Now, I open this database in VStudio. I run a query and it gets me 1
> result. This is a simple select query going after 1 table with a where
> condition using the 'like' keyword. I am sure it should get me tens of
> results. So I open up the table and scroll through it. I expand the
> column that I have the where condition on; to look at the data. I see
> that there should be a lot more hits.

> So, I run the same query again, now it gets me tens of results. What is
> going on here? Some invisible character at play here? I have never seen
> this happen before.

> I can re-create this issue.

Do you run a "diagnose" for the database?


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com