Problems with VarChar inserts after DeleteAllRecords

[Dave Addey]

Hi Ruslan,

It has taken 6 hours of hunting, but I have finally tracked down the cause
of this bug!  I have posted a project to Mantis (0001676), which shows this
bug in action.  I have narrowed it down as much as possible - hopefully this
will help you to fix it.

The problem comes from using "ORDER BY TestVarChar".  Unfortunately this
means I have no workaround, as I need to be able to order by VarChar fields.

Dave.

> From: Ruslan Zasukhin <sunshine at public.kherson.ua>
> Reply-To: Valentina Developers <valentina at lists.macserve.net>
> Date: Thu, 06 Jul 2006 19:08:25 +0300
> To: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
> Conversation: Problems with VarChar inserts after DeleteAllRecords
> Subject: Re: Problems with VarChar inserts after DeleteAllRecords
> 
> 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]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina