Search:

Well, a bit shorter than all this API-gymnastic would be a simple method-call on cFSO:
If New_c.FSO.IsFileWritable(YourDBFile) Then...

Olaf

Yep - and without any crashes of course...
(or any more "added complexity, due to insisting on calling DoEvents all over the place").

I'd even be willing to post an example (based on some source...

Well, I could ...
(but that's probably because I understand what's going on behind DoEvents)... ;)

Olaf

Which is the main-reason, why this thread goes on and on...
(as said, you've just fixed another problem, related to your own idea, to place DoEvens within a transaction)


You still don't...

[DoEvents within an ongoing, looong DB-Transaction]


No reason? Two postings above you've just posted a problem you've fixed, *caused* by that.
(where you were closing your App - from "inside of...

That's not necessary at all, because normally Transactions should be opened and closed:
- within the same function
- which has a proper ErrHandler, so that leaving the function is only possible...

Then ask JPBro, the trick, wqweto or anyone with a modicum of DB-experience - whether:
BeginTrans
... DoEvents, Eduardo-style
CommitTrans
is a good idea. ;)


As already advised, easily...

Which (as a file) will then have to be used "task-exclusively" - because:
- handling potential concurrent writes
- handling potential concurrent reads (on committed and/or uncommited data)
is what...

When you are not willing to follow advice, then your problems will continue I guess...

Here's my advice-list again:
- first and foremost: remove all DoEvents-calls which sit (even indirectly)...

Umhh, then don't?


If you mess-up the transaction-stack via your own coding (using DoEvents and stuff, then using the Stop-Button in the IDE),
then all the component can do is, to inform you...

You've probably messed up the transaction-stack again (due to DoEvents) -
or you pressed Stop in the IDE (when within a transaction) -
which left you with a set FileLock on the DB-File in...

And the other one cannot be compiled with exactly the same compiler-settings because...?

I mean, the whole RC6.dll (with 100+ Classes) is compiled this way
(all extra-compiler-Flags on, only the...

Please study (or at least search through) the postings of the discussion-thread you're currently in...
Cookie-retrieval was already a topic here in:...

Maybe that's the big misunderstanding all along -
because only after you have declared your process to be DPI-aware,
is Windows not "lying to you" anymore (about DPI-Settings and...

I always encapsulate such APIs in a Class, e.g. named cFinnApi -
usually split into:
- nice, speaking (low implementation-efforts requiring) Public Functions
- and a Private Helper-Routine, which...

The IDE is run (usually) "as Administrator" - whereas the compiled project is not.
Maybe the "normal UserAccount" has different locale- or registry-settings or something.

And/Or ... it could be...

Isn't the obvious solution, to put both Classes into the same Dll-Project?

Olaf

No, it isn't.

When cHashD performs something in:
- 100msec (in a risky fashion)
- or in 105msec (in a stable fashion)
I know, what I'd choose.


That's wrong.
Not all areas of a program...

From your Connection-String, you seem to be using your DB at:
App.Path & "\DataBase\Customers.mdb"

Now, if your App was placed under the "Programs" (or "Programs x86")-Folder,
then all kind of...

I'm absolutely sure... (no speculation here).

For example:
Sometimes (e.g. in the RC6.cSortedDictionary) I map StringKeys to Integer-Arrays with:
- an LBBound of -2: saK.lLbound1D = -2
- and...

You might want to take a look at this Codebank-Project:
https://www.vbforums.com/showthread.php?876311-VB6-JigsawPuzzle-using-Cairo-Paths

HTH

Olaf

For calculations, you'd have to convert your Texts in the Liter-Column,
into Real-Numbers (the Val(...) function is a good candidate for that.

The whole thing is more complicated though, because...

FWIW, I leave this option unchecked, when my code is using "SafeArray-Pointer-Tricks/Mappings".

Olaf

As you wish...
But keep in mind, that the "assigned SQLite-Cache" (which was a topic already in the other thread),
is "per Connection-instance" - not "per Process".

Also "opening an...

No, it's the same speed (the same internal sqlite3_reset-API is used in cCursor.Reset or
alternatively in cCursor.Setparameter (but there only - when not already in "resetted state").

Here the...

The Cursor (when explicitely reset via the COM-Method from the outside),
will not reset itself implicitely again when the COM-Method cCursor.SetBlobPtr(...) is called.

So, a single...

There will be no "limitation" (not with regards to multiple Connections in the same Process and Thread),
if you just reset your Cursor properly (after performing a Step), as shown in blue below:

...

Yes, the Cursor being low-level (and not being reset, still being in an implicite-transaction) introduces a problem,
when you try to do a write-operation (as e.g. Rs.UpdateBatch) on a *different*...

That's not what wqweto said, at all.


SQLite does allow multiple connections against the same database-file.

It just does not make much sense, to have several DB-Connections open (on the same...

No, the problem happened because you are dealing with another, separate Connection-Object (opened on the same DB-File).
If you change (as suggested already), your Class's OpenDatabase-Method to the...

Yes, but I would still avoid calling DoEvents in-between a Begin- and -CommitTrans.

There's just too much risk, that you mess up the transaction-stack this way,
when no re-entrancy protection is...

I'm aware of that - because you mentioned it already ... ;)

I had it prepared at that time (from guessing, what your problem might look like) -
and so I've posted it "as it was"...

I still...

Thanks.

Whilst I take a look, you could take a look at my "minimal-demo" with regards to FileScans as well...
(even if your approach is different, maybe you can steal some stuff from it).

It...

I've mentioned this new ClassName, when I talked about "planned, future inclusions" in the RC6.

Ah..well, since you're here already (regarding new inclusions) ... -
what about including your...

Because you have to really know:
- when to call it
- but especially "from where" to call it

I'd certainly not call it from within a Cnn.BeginTrans... Cnn.CommitTrans-CodeBlock.

IMO you are...

cRegExp and cAILib are "yet unfinished" (but planned to include in one of the next releases).

As for cAILib-wrapping of "existing OpenSource-libs":
- the lib in question should have a "compatible...

My guess is, that you use DoEvents somewhere in your Apps "larger loops" -
is that the case?

Also, when gDataBase is a true global Variable (in a *.bas-Module),
you should use it "everywhere in...

Glad you found the issue...

Though since everybody is currently in "C-compiling-mood" anyways,
why not make the jump two versions into the future at this occasion as well:...

Variant-Members (which will occupy 16Bytes in a given UDT, instead of 4) -
can contain all kind of Pointer-Types as well (even other UDTs).

Olaf

It's a COM-based Mini-Framework, which wraps OpenSource-libs (mainly cairo and SQLite) -
which provides (with a single Project-Reference-CheckIn) modern Classes for "nearly everything".

It is...