Search:

Type: Posts; User: wqweto

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: [RESOLVED] I need SHA256 hashing code (not WinAPI based)

    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...
  2. Replies
    10
    Views
    199

    Re: Mysql Nested sub query

    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...
  3. Replies
    196
    Views
    21,337

    Re: VB SQLite Library (COM-Wrapper)

    Tested latest source from github repo with Value fixes on an Intel i9-12900k desktop machine.
  4. Replies
    196
    Views
    21,337

    Re: VB SQLite Library (COM-Wrapper)

    Try replacing


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


    FL =...
  5. Replies
    196
    Views
    21,337

    Re: VB SQLite Library (COM-Wrapper)

    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...
  6. Replies
    11
    Views
    940

    Re: Encrypted File Transfer

    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...
  7. Replies
    2
    Views
    209

    Re: Compiling TLBs with midl for VB6

    > I need my unrestricted definitions of IUnknown and IDispatch.

    Is this your final goal? You want these redefinitions same-named?
  8. Replies
    196
    Views
    21,337

    Re: VB SQLite Library (COM-Wrapper)

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

    cheers,
    </wqw>
  9. Replies
    196
    Views
    21,337

    Re: VB SQLite Library (COM-Wrapper)

    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...
  10. Re: Simple and fast, lightweight HashList-Class (no APIs)

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

    cheers,
    </wqw>
  11. Replies
    25
    Views
    521

    Re: ActiveX dll's that reference each other

    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...
  12. Replies
    25
    Views
    521

    Re: ActiveX dll's that reference each other

    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...
  13. Replies
    196
    Views
    21,337

    Re: VB SQLite Library (COM-Wrapper)

    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.
    ...
  14. Replies
    31
    Views
    575

    Re: Assume no aliasing

    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...
  15. Replies
    31
    Views
    575

    Re: Assume no aliasing

    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...
  16. Replies
    196
    Views
    21,337

    Re: VB SQLite Library (COM-Wrapper)

    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...
  17. Replies
    31
    Views
    575

    Re: Assume no aliasing

    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...
  18. Thread: TwinBasic

    by wqweto
    Replies
    1,130
    Views
    412,387

    Re: TwinBasic

    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>
  19. Re: Convert binary data to a valid Unicode string whitout wasting (much) space ❓

    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...
  20. Re: Convert binary data to a valid Unicode string whitout wasting (much) space ❓

    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>
  21. Re: Convert binary data to a valid Unicode string whitout wasting (much) space ❓

    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...
  22. Re: Convert binary data to a valid Unicode string whitout wasting (much) space ❓

    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)...
  23. Replies
    7
    Views
    388

    Re: RC6, about the CAILib class

    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...
  24. Replies
    31
    Views
    575

    Re: Assume no aliasing

    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...
  25. Replies
    31
    Views
    575

    Re: Assume no aliasing

    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...
  26. Replies
    7
    Views
    388

    Re: RC6, about the CAILib class

    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,...
  27. Re: Convert binary data to a valid Unicode string whitout wasting (much) space ❓

    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...
  28. Re: Convert binary data to a valid Unicode string whitout wasting (much) space ❓

    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...
  29. Re: Convert binary data to a valid Unicode string whitout wasting (much) space ❓

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

    cheers,
    </wqw>
  30. Replies
    8
    Views
    544

    Re: Alpha Drawing via Gdi32

    Always wondered if its named after that song.
  31. Replies
    196
    Views
    21,337

    Re: VB SQLite Library (COM-Wrapper)

    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....
  32. Re: Crashing when reading UNICODE_STRING

    Probably the ReadProcessMemory declare is weird.

    cheers,
    </wqw>
  33. Replies
    7
    Views
    19,666

    Re: VB6 IDE Linker AddIn

    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...
  34. Replies
    7
    Views
    19,666

    Re: VB6 IDE Linker AddIn

    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...
  35. Replies
    196
    Views
    21,337

    Re: VB SQLite Library (COM-Wrapper)

    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...
  36. Replies
    196
    Views
    21,337

    Re: VB SQLite Library (COM-Wrapper)

    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...
  37. Replies
    196
    Views
    21,337

    Re: VB SQLite Library (COM-Wrapper)

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

    cheers,
    </wqw>
  38. Replies
    196
    Views
    21,337

    Re: VB SQLite Library (COM-Wrapper)

    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...
  39. Replies
    196
    Views
    21,337

    Re: VB SQLite Library (COM-Wrapper)

    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>
  40. Thread: find jpg files

    by wqweto
    Replies
    14
    Views
    665

    Re: find jpg files

    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...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width