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