V4MD 1.10

Roland Hildebrandt r.hildebrandt at sbt.fr
Tue Jan 27 10:15:38 CST 2004


Hi all,

We have been using valentina for director for over a year (version 1.9.6.) for CD-Rom projects.

We now have three recurrent problems which I want to post to know if someone has any ideas :

*******************************
Problem 1 :

Using Xtra 1.10 or 1.9.8.
When importing data into a text field of an encrypted database, everything works fine the first time until we close the database.
When we reopen the database every new insert will insert no data into the text field(s). 

The database diagnose gives the following problems for the text field(s) :
Block 6 has wrong mIndex must be 1 in fact 0.
Reindexing database doesn't solve the problem.

When using a non crypted database the problem doesn't appear.

When using a long varchar field (4000+) instead of text everything works fine even when the database is crypted. But the documentation says this is not optimal for long strings.
**********************************

Problem 2 :

When importing a lot of data we use importascii from a delimited text file. This seems to be much faster than any other method.

Using Xtra 1.10.

The import fails (?!) if there is a varchar field in the table more than 511 characters long. There is no error message and the database diagnose displays no error. In fact nothing happens, no line is added in the table. The problem appears with a crypted and a non crypted database.

When replacing all varchars longer than 511 characters by text fields, everything works fine.


Using Xtra 1.9.8

Suprisingly everything works fine even with crypted database and long varchars.

**********************************

Problem 3 :

When creating a database and inserting data, we quickly get this message for a lot of fields when we make a database diagnose :

(!) Table has 6 physical records but field has 256
 
This creates no problems when using the database but we don't understand this message.
It make it also more difficult to detect if the database is corrupted because there are always problems found when we call Database diagnose.


Thanks a lot for any ideas



SBT / HAPPYneuron
Roland HILDEBRANDT


More information about the Valentina mailing list