Results 1 to 19 of 19

Thread: dhRichClient3 "Cannot execute SQL-Statement: out of memory"

Threaded View

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2017
    Posts
    761

    Question dhRichClient3 "Cannot execute SQL-Statement: out of memory"

    Hello!

    I am using dhRichClient3.

    I do a lot with sqlite, and at everything works fine for some time, but then at some point of time I get the error "Cannot execute SQL-Statement: out of memory" when calling an update like this:

    Code:
        Dim Cmd As dhRichClient3.cCommand
        Set Cmd = cnUser.CreateCommand("UPDATE pages SET pagedatetimemodified=?,pagethumbdirty=? WHERE pageguid=? AND pagebookguid=?")
    
        Cmd.SetDate 1, Now
        Cmd.SetBoolean 2, True
        Cmd.SetText 3, tPage.Guid
        Cmd.SetText 4, tBook.Guid
    
        Cmd.Execute
    This code is fine. I can call it like 20 times, but then at some point of time, it throws this error: "Cannot execute SQL-Statement: out of memory"

    I can't really say under which circumstance it happens.

    My app shows ~400 mb in the taskmanager.
    In the taskmanager, I see that for a split second (right after cmd.Execute) the taskmanager shows 1350 mb for my app.
    Then, immediately it flips back to ~400 mb.

    So obviously dhRichClient3 does something internally which consumes really much memory for some a small amount of time. What might that be?

    How could I debug what causes this out of memory error?

    I am using an undo-redo logic with triggers, so the problem is a bit too complex to post it.

    That is why I would like to know what I can check first.

    Thank you for any hint!
    Last edited by tmighty2; Jan 5th, 2022 at 09:04 PM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width