[V4MD] index & update

[Ruslan Zasukhin]

on 11/5/03 1:59 PM, Martin Kloss at martin.kloss at gmx.de wrote:

Hi Martin,

> two things:
> 
> 1. when and how can the index file get corrupted?

E.g. Valentina WRITE into index file and system fails.

> I have a table with a field "id", which is a pseudo-auto-increment
> field, meaning I auto-increment is myself and check
> for inconsistencies. The field is unique and indexed.

> After many add, update, delete operations I get totally
> freaky results for a "SELECT id, name FROM data ORDER BY id ASC",
> which before was fine:
> 
> (exerpt from vStudio)
> 
> id
> ------------------
> ....
> 65
> 70
> 71
> 72
> 66
> 67
> 68
> 69
> 73
> 74
> ...
> 
> How can this be?

This have happens once?

> After trashing the index file and re-opening the db, everything
> was fixed and the result was fine !?

Looks like index break.


> 2. Updating fields with "" empty string
> When I update a field in a record with an empty string "",
> the record does not get updated, using "UPDATE" SQL with binded
> values. Do the fields have to be nullable and the value in
> the binded list NULL ? Why can't the empty string overwrite
> what's in the field?

Hmm, this can be a bug.

-- 
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
-------------------------------------------------------------