Search:

Type: Posts; User: Schmidt

Page 1 of 13 1 2 3 4

Search: Search took 0.05 seconds.

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

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

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

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

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

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

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

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

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

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

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

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

    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...
  12. Re: ActiveX dll's that reference each other

    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...
  13. Replies
    177
    Views
    43,410

    Re: VB6 WebView2-Binding (Edge-Chromium)

    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:...
  14. Replies
    15
    Views
    391

    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...
  15. Replies
    10
    Views
    433

    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...
  16. 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...
  17. Re: ActiveX dll's that reference each other

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

    Olaf
  18. Replies
    31
    Views
    586

    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...
  19. 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...
  20. Replies
    31
    Views
    586

    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...
  21. Replies
    12
    Views
    1,349

    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
  22. 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...
  23. Replies
    31
    Views
    586

    Re: Assume no aliasing

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

    Olaf
  24. 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...
  25. 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...
  26. 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...
  27. 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:

    ...
  28. 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*...
  29. 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...
  30. 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...
  31. 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...
  32. 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...
  33. 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...
  34. Replies
    7
    Views
    398

    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...
  35. 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...
  36. Replies
    7
    Views
    398

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

    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:...
  39. 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
  40. Replies
    6
    Views
    503

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



Click Here to Expand Forum to Full Width