[V4MD] index & update

[Martin Kloss]

Hi Ruslan,

two things:

1. when and how can the index file get corrupted?
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?
After trashing the index file and re-opening the db, everything
was fixed and the result was fine !?

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?

Martin.


Martin Kloss

Need music? http://www.selling-sound.com

Like the author? Buy the book at:
http://www.amazon.de/exec/obidos/ASIN/3898422194/lingmmugd

Get your daily dose of Lingo at the LingoPark:
http://www.lingopark.de