|
-
Jan 5th, 2022, 06:50 PM
#1
Thread Starter
Fanatic Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|