[V4RB] SQL error

[Ivan Smahin]

Hello Bill,

Monday, July 31, 2006, 7:24:46 PM, you wrote:

> I have a database with a column (named TYPE) where all the records  
> have the value 5. I issue the following SQL:

> select * from XXXXX where TYPE between 1 and 5

> No records are returned. Then I tried:

> select * from XXXXX where TYPE between 1 and 6

> It found all the records (even though the manual says "between 1 and  
> 5" is the same as TYPE >= 1 and TYPE <=5)

> I did the same exercises within code (SQLSELECT) and Studio.

> Any suggestions?

I have just checked this and found nothing strange. It works all right.
So you should get all records.

The reason for wrong answer would be broken index.
So try to reindex that field please.

-- 
Best regards,
 Ivan                            mailto:ivan_smahin ÎÁ valentina-db.com