Problems with VarChar inserts after DeleteAllRecords

[Ruslan Zasukhin]

On 7/6/06 6:51 PM, "Dave Addey" <listmail1 at dsl.pipex.com> wrote:

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

You do already.

So add your projects to Mantis, we will check them asap.




-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]