Problems with VarChar inserts after DeleteAllRecords

Dave Addey listmail1 at dsl.pipex.com
Thu Jul 6 16:51:35 CDT 2006


As I mentioned earlier, I¹m having problems with dropping and reinstating
tables when multiple databases are open.  So, rather than drop and reinstate
tables, I tried using VTable.DeleteAllRecords.

However, I have found a bug when using this command, and it seems to be a
problem with VarChar fields.  After calling DeleteAllRecords, if I then add
new records to the table, I find that some (but not all) of the records I
add have some of their VarChar field values missing.  It¹s not long before
my application crashes.

I¹m sure I remember mentioning this problem a while back, when I first
started using V4RB 2.  In fact, I¹m sure this was why I stopped using
DeleteAllRecords back then, and started using Drop Table instead.
Unfortunately, the VarChar problem doesn¹t seem to have been fixed in the
meantime.

So, as it stands, I don¹t have a way to open two (or more) databases, and
delete all values from a table (or drop and reinstate the table), due to
these two bugs.  Unfortunately, this means I have no workaround :-(

I can post a database affected by the VarChar problem, as soon as I have my
Mantis password :-)

Dave.


More information about the Valentina mailing list