Search:

JFYI, there is [VB6/VBA] Pure VB6 impl of SHA-2 thread in the CodeBank which has SHA-224, SHA-256, SHA-384, SHA-512, SHA-512/224 and SHA-512/256 variants incl. HMAC on top of these both for VB6 and...

Try this query without a window function (the ROW_NUMBER bit)

https://www.db-fiddle.com/f/tZJbvdrRUNUrx8g18Ui9Ev/1

It's less efficient than using window functions but a lot more compatible and...

Tested latest source from github repo with Value fixes on an Intel i9-12900k desktop machine.

Try replacing


' FL = iVBSQLiteCursor(3).Value
' DT = iVBSQLiteCursor(4).Value
' BD = iVBSQLiteCursor(5).Value
. . . with


FL =...

Time to fill DB: 0.45

RC6-Cursor: time searching 100,000 randoms records that are found: 0.26

DAO: time searching 100,000 randoms records that are found: 0.72

SQLiteCursor: time searching...

I just realized how close these sources are to a working TLS 1.3 implementation.

These look like a "primordial soup" out of which a living being will come out eventually, just need a lightning...

> I need my unrestricted definitions of IUnknown and IDispatch.

Is this your final goal? You want these redefinitions same-named?

That would be cool then, no need to "hammer" VS2015 .obj files although would be interesting to support more modern compilers.

cheers,
</wqw>

Yes, everything else would be too complicated or hacky. With VC6 using /MD it references MSVCRT.DLL which is a system dll (i.e. VC6 runtime does not have to be setup with separate installer).

I’ll...

Is the sentinel value missing couple of F's like in MAX_INT = &H7FFFFFFF or this is on purpose?

cheers,
</wqw>

No, you got it all reversed while I was posting my reply :-))

You keep A-->B but then make a new B-->C which might be way to much effort -- C now has to have all the class types from A which can...

So you now have project A with some custom VB6 classes and project B with cHashD and need B to reference A for the cHashD to return items of A class types but then you need A to reference B for A...

Yes, there is a problem with the ucrt.lib and vcruntime.lib linked files. Should have been libucrt.lib and libvcruntime.lib instead for a static build.
...

I'm using this all the time


Option Explicit

Private Declare Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (Destination As Any, Source As Any, ByVal Length As Long)
Private Declare...

This is an example of aliasing gone wrong in normal looking code, not of problems with "Assume no aliasing" option which would be hard to demonstrate.

In the example calling XorSwap A, A sets A to...

In Win10 and Win11 there are two registry "branches" for Admin users (every user in fact).

Technically you have to unregister both from elevated command prompt and unelevated command prompt to be...

The problem with this optimization *might* occur if you are passing a global (or module level) variable into a routine as a parameter *and* this routine uses both the parameter and the global (or...

No, not everything.

Here is a discussion how to figure out which one is implemented as intrinsic and you can even use different color in the Editor for intrinsics.

cheers,
</wqw>

You won’t be able to write aux table as the db is locked. There is no need (and no way) to remove any lock, this is not an Access MDB :))

There is no problem with sqlite locking model and...

Ahaa, and you open a second connection and want to fetch some extra data while the first connection is in a transaction and the DB is exclusively locked already?

cheers,
</wqw>

So you are using the cursor without wrapping the access in a transaction like in the benchmark test?


iSQLite.Execute "Begin"
Set iCur = iSQLite.CreateCursor("Select * From Files...

Hey, I said nothing about transactions. Connection <> Transaction. You can have multiple connections to a single sqlite DB but only of these can have a transaction with pending (uncommitted)...

I wouldn't mind including any of my classes shared under MIT license but I wouldn't exactly consider adding 400KB additional size to the binary just for this class with it's custom TLS implementation...

It's more like when you have pointers p1, p2, p3 and p4 on writing through one of these *p1 = 42 the compiler can't be sure if the value (the dereference) of any of the other pointer *p1, *p2 or *p3...

Assume no aliasing is purely optimization option for pointer/ByRef parameters vs other parameters or global data.

With or without this option dealing with aliased data can be tricky and can...

Best would be to post some links to other AI projects which you want for Olaf to consider for inclusion.

Search for "new CAILib" in google leads to nothing. What are you talking about?

cheers,...

Because when calling MyConn.Execute for instance I'm not prepared to handle Form_Unload *while* inside the method call i.e. I didn't put up special flags before each and every method call so to be...

This is a huge problem. It's a very bad design for (system) components to spin thread messages which usually is wreaking havoc on client applications.

For instance WinHttpRequest and ServerXMLHTTP...

No, there is no such restriction in sqlite or RC6 unless you are explicitly using PRAGMA locking_mode=EXCLUSIVE

cheers,
</wqw>

Always wondered if its named after that song.

BSTRs are both length prefixed and null terminated so these can be cast to LPWSTR without additional processing i.e. without null terminating.

Of course BSTRs *can* contain null characters (a.k.a....

Probably the ReadProcessMemory declare is weird.

cheers,
</wqw>

I'm using my own surrogate linker which automatically copies .cobj files to same named .obj if it finds these .cobj files in target directory. Krool had problems with it and that's why he created the...

This usually means that LinkSwitches or .cobj external dependencies are prevent the linker from producing executable.

For instance having KERNEL32.LIB in LinkSwitches means that this .lib file has...

Yes, this is somewhat tedious work that has to be done in the wrapper, combing through all the cases.

I already tweaked SQLiteCursor.SetParameterValue to use stub_sqlite3_bind_text16 for Case...

You do realize VBSQLite12.DLL has sqlite embedded already and does not need any extra DLL to work?

I didn't use nor tested this intermediate DLL at all because it's needed only for debugging...

Here is the VS2015 compiled version of VBSQLite12. Not sure if it's kept binary compatible with the original though.

cheers,
</wqw>

I just successfully recompiled VBSQLite12 with VS2015 but the performance of the latest test project as posted in the current thread was not affected at all.

The only sqlite compile option...

Try VS2015 which is the last with XP support (and use static build to not depend on the runtime DLLs).

Optimizations in release build are most welcome and expected of course.

cheers,
</wqw>

You can always install an utility called Everything from voidtools.com so you can search for all *.jpg file on your disks really fast.

Then just copy/paste everything found to your new drive I...