Search:

Type: Posts; User: Schmidt

Page 1 of 13 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    15
    Views
    342

    Re: Monitor Scale Factor

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

    Re: Need to learn how to read RESTAPI into VB6

    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...
  3. Re: vb6 database query sql contains like operator fail to work in Window 11?

    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...
  4. Replies
    23
    Views
    439

    Re: ActiveX dll's that reference each other

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

    Olaf
  5. Replies
    31
    Views
    562

    Re: Assume no aliasing

    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...
  6. Re: Problem executing a query in VB6.0 on an Apple computer under Windows 10

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

    Re: Assume no aliasing

    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...
  8. Replies
    12
    Views
    1,321

    Re: [RESOLVED] Rotating image in a User Control

    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
  9. Re: please help data type mismatch select sum

    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...
  10. Replies
    31
    Views
    562

    Re: Assume no aliasing

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

    Olaf
  11. Re: Convert binary data to a valid Unicode string whitout wasting (much) space ❓

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

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

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

    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:

    ...
  15. Re: Convert binary data to a valid Unicode string whitout wasting (much) space ❓

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

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

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

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

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

    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...
  21. Replies
    7
    Views
    368

    Re: RC6, about the CAILib class

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

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

    Re: RC6, about the CAILib class

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

    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...
  25. Replies
    192
    Views
    21,166

    Re: VB SQLite Library (COM-Wrapper)

    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:...
  26. Re: How to use program to detect struct is contiguous memory or not ?

    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
  27. Replies
    6
    Views
    480

    Re: RC6 : New version ?

    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...
  28. Replies
    6
    Views
    480

    Re: RC6 : New version ?

    New version 6.0.10 is now "online" - and I hope the new Events are covering,
    what you were missing...

    Olaf
  29. Replies
    192
    Views
    21,166

    Re: VB SQLite Library (COM-Wrapper)

    Thanks for the confirmation (that it is the C-Compiler-settings)...

    Olaf
  30. Replies
    192
    Views
    21,166

    Re: VB SQLite Library (COM-Wrapper)

    I've tested this already - but it didn't make a large difference (so I left DAO with the shorter code).

    It's only about 3-4% you gain, when you set the DAO-Field-Objects outside the loop:


    ...
  31. Replies
    192
    Views
    21,166

    Re: VB SQLite Library (COM-Wrapper)

    Ah - didn't know about the new Value(Idx)-Prop...
    Although (if you look at my latest Test-code), I've already tried really hard,
    to not "go through your Columns->Item-sequece" (using explicit...
  32. Replies
    7
    Views
    328

    Re: send data ssdp and udp help

    If your tool "repeats this data in broadcast" (when triggered from within a "receive"),
    then you're effectively saturating your LAN-bandwidth... (due to a kind of "endless-loop").

    Olaf
  33. Replies
    192
    Views
    21,166

    Re: VB SQLite Library (COM-Wrapper)

    The new RC6-version (6.0.10) is now "online"...

    Here's the final Test-Result (also incorporating Krools latest version-update, from one posting above)...
    185411

    Here the Test-Code I've used:
    ...
  34. Re: Convert binary data to a valid Unicode string whitout wasting (much) space ❓

    Just define your SQLite HashField properly as Blob (instead of Text).

    And then ensure, that in cour SQLite Command or Cursor-Objects,
    you pass a ByteArray as the Parameter (to the Cursor-Class) -...
  35. Replies
    192
    Views
    21,166

    Re: VB SQLite Library (COM-Wrapper)

    Just a single enclosing Transaction for both operations is enough:



    Private Sub Form_Load()
    Dim Cnn As New SQLiteConnection, Cmd As SQLiteCommand, Cur As SQLiteCursor, V
    Cnn.OpenDB...
  36. Replies
    192
    Views
    21,166

    Re: VB SQLite Library (COM-Wrapper)

    Sure, ... and the result was 1.75sec (DAO-Seek was 1.39, RC6-cCursor was 0.39)...

    So, it's now playing in the same "ballpark" as DAO-Seek...
    The reason why it's still about factor 4.5 slower than...
  37. Replies
    192
    Views
    21,166

    Re: VB SQLite Library (COM-Wrapper)

    It's intuitive and "as one would expect", I'd say...
    ...when someone changes the "underlying conditions of a Set-representation" (by changing parameters),
    the Cursor will (unsurprisingly) be reset...
  38. Re: Simple and fast, lightweight HashList-Class (no APIs)

    It used these APIs, to avoid an "IsObject()"-check (followed by Set in case the Key or Item were of type Object).

    Olaf
  39. Re: Convert binary data to a valid Unicode string whitout wasting (much) space ❓

    Your current 16Byte-Raw (probably MD5)-Hashes can be stored in a VBStrinig-Variable with no problem...
    An assignment like:

    Dim Key As String
    Key = ByteArrayWith_16_HashBytes

    Should result in...
  40. Replies
    192
    Views
    21,166

    Re: VB SQLite Library (COM-Wrapper)

    The new Cursor-Class is not (yet) optimal, because it does not have "Command-Parameter-integration" (as I suggested before).

    Though it brings down the timing (with "DAO-like code-efficiency") - ...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width