[V4RB] DELETE and Index Corruption

[Ruslan Zasukhin]

on 5/5/03 8:54 AM, Richard Altenburg at valentina at brainchild.nl wrote:

>> Now when I query that table with a simple SELECT * FROM myTable, I get
>> the record. But when I query that record as follows:
>> 
>>   SELECT * FROM myTable WHERE ObjectPtrField = 1234
>> 
>> I get the correct number of columns returned, but no rows! Now it gets
>> really weird. If I put quotes around the value like so:
>> 
>>   SELECT * FROM myTable WHERE ObjectPtrField = "1234"
>> 
>> Then it works!!
> 
> Looks like the problems I had when working woth large tables too (hundreds
> of thousands of records), where I had to put quotes around key values to
> retrieve records.
> 
> My current solution is to reindex at some key points in my software. That
> takes some time but is better then having the troubles you describe.

Let's hope Frank will be able isolate and reproduce this on small project.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------