List of open show stoppers todo

[Dave Addey]

Hi Ruslan,

Thanks for this!

Bad news: I have tried adding in these calls to db.flush, and I still get
the problem.  I added in the following line to my project:

  // insert lots of values
  LogListBox.AddRow "About to insert values for the first time"
  // and flush the database
  TestDatabase1.Flush // <-- this line has been added
  // diagnose the library to a file
  WriteDiagnostics(TestDatabase1, DateString+"
Diagnostics_1_after_first_insert.txt")
  
...and...

  // insert all values into the database again
  LogListBox.AddRow "About to insert values for the second time"
  InsertVarCharValues(TestDatabase1)
  TestDatabase1.Flush // <-- this line has been added
  // diagnose the library to a file
  WriteDiagnostics(TestDatabase1, DateString+"
Diagnostics_4_after_second_insert.txt")
  
...but I still see exactly the same problem when I insert large numbers of
records.

Actually, this has made a change, but only for small numbers of records...

...If I add in these calls to db.flush, then I can now insert 1,000 and
10,000 records with no problems (without db.flush, this would have caused a
corrupt database when the database is re-opened).  But, if I insert 100,000
records and then call db.flush, then I *still* have the same problem as
before, even before the database is closed.

Do I have to call db.flush more often?  If so, how often do I have to call
it to be ³safe²? 

Dave.

> From: Ruslan Zasukhin <sunshine at public.kherson.ua>
> Reply-To: Valentina Developers <valentina at lists.macserve.net>
> Date: Sat, 08 Jul 2006 10:11:18 +0300
> To: "valentina-beta at lists.macserve.net" <valentina-beta at lists.macserve.net>,
> "valentina at lists.macserve.net" <valentina at lists.macserve.net>
> Conversation: List of open show stoppers todo
> Subject: Re: List of open show stoppers todo
> 
> On 7/7/06 11:24 PM, "Dave Addey" <listmail1 at dsl.pipex.com> wrote:
> 
>> Hi Ruslan,
>> 
>> If there is no way for me to use the class-way to drop and then re-create a
>> table, then 1676 is very much a show-stopper for me.
>> 
>> Thanks for making this a priority!
> 
> Dave,
> 
> Yes I see that diagnose4 show problems.
> 
> Fix is easy:
> 
>     you have forget after loop of inserts do db.flush
> 
> Add this one line, and everything start work.
> 
> 
> But thank you for your project!
> I will start debug where from comes problem.
> 
> Your code also should work...db.close() self must do db.flush..
> So I do not understand what is going..
> 
> 
> -- 
> 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