Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.85 seconds; generated 28 minute(s) ago.

  1. Re: DisplayResolution 2560 x 1440 gives run-time 6 overflow error program made with

    Besides having to sit at least 4 feet away? :D
  2. Re: How is the behaviour of VB6 compiler while comparing two string?

    True, but i wouldn't be surprised if under the hood it's the same function every time, overloaded with flags and what not. see Flag IGNOREWIDTH in wqweto's link, which basically can be used for...
  3. Re: How is the behaviour of VB6 compiler while comparing two string?

    Considering it's Microsoft we're talking about? *shrug*
    Out of my left sleeve: Take a binary representation of both strings, and subtract one from the other. If Result = 0 Then Equal Else NotEqual...
  4. Replies
    5
    Views
    186

    Re: MySQL Syntax Error Setting up SPROC

    Huh?
    You lost me there.....
    btw: I just noticed the name of your table.
    "user" is already a table in the database "mysql" (System-DB).
    Have you tried qualifying the tablename/SP?
    CREATE TABLE...
  5. Re: Loading a IniFile into a Dictionary

    Duplicate Keys where? Within a Section?
    That doesn't make sense.

    OTOH, a key can be repeated in a different section.

    Sections in an INI-File: Must be unique
    Keys within a Section: Must be...
  6. Re: How is the behaviour of VB6 compiler while comparing two string?

    ...which actually implies the same way RTLCompareMemory works: compare each "character" (honoring the flags), until there is a "difference"
    Otherwise it couldn't return Results like "is less" "is...
  7. Re: How to convert date&time information from date/time server into my local time?

    https://docs.microsoft.com/en-us/windows/win32/api/timezoneapi/nf-timezoneapi-systemtimetotzspecificlocaltime
    Depending on if that server is on UTC, or in its own TimeZone differing from UTC, you...
  8. Re: How is the behaviour of VB6 compiler while comparing two string?

    No idea if the compiler optimizes a String-Compare to a RTLCompareMemory, but i wouldn't be surprised,
    if a "If String1=String2 Then" compares the whole memory-blocks the Stringpointers point to....
  9. Replies
    8
    Views
    421

    Re: MySQL (with VB6) questions

    Have to disagree.
    Scroll down about one third. MySQl allows granting columnwise
    https://www.mysqltutorial.org/mysql-grant.aspx/



    GRANT
    SELECT (employeeNumber,lastName, firstName,email), ...
  10. Replies
    5
    Views
    186

    Re: MySQL Syntax Error Setting up SPROC

    Have you tried increasing the VARCHAR-size in the Parameter?

    https://stackoverflow.com/questions/13960760/mysql-stored-procedure-that-accepts-string-with-multiple-parameters
  11. Replies
    4
    Views
    229

    Re: Open an undefined data structure.

    At a guess: Records (VB6-speak: UDT's) accessed/written in random mode.
    Have you tried reverse engineering the Record-Structure?
    First, i would look, if there is a repeating pattern recognizable...
  12. Re: PRINT directlly a word document from dir

    ....and at its Window-Styles (HIDDEN, SILENT or whatever it's called)
  13. Replies
    14
    Views
    448

    Re: Date Type Mismatch

    That blasted "Active"-Something again.
    Is your "Active"-Sheet even the "correct" one?
    Does the error happen, when you qualify the sheet directly (via number/Name)?
  14. Re: How to select using multiple column match?

    Why don't you build a computed column from your 2 columns and compare that one?
    If you have fixed-length Text-Columns, use TRIM to cut off leading/trailing whitespace
    Aircode

    SELECT/DELETE *...
  15. Replies
    1,636
    Views
    76,869

    Re: Corona virus, China major city lockdowns, etc.

    A friend of mine made an "interesting" suggestion (note the quotation-marks):
    "Actually, we could defeat that blasted virus quite easily: The whole world just has to stop for 4 weeks, all at the...
  16. Re: Is PeekNamedPipe broken in current version of Windows?

    https://docs.microsoft.com/en-us/windows/win32/api/namedpipeapi/nf-namedpipeapi-peeknamedpipe
  17. Re: Is it possible to connect SQLServer via internet without opening port like teamvi

    Ehhhh.....wrong!
    I know for a fact, that TeamViewer has a central Server, where all clients connect to /register themselves with. That's the server which assigns you your TeamViewerID.
    So,...
  18. Re: vb6: how use an user type parameter on a class function\sub?

    I admit: It's been some time having tried something like this,
    but, couldn't he define a "child"-class "POINTL" with just two public Properties (x and y As Long), in this mode "Public - Not...
  19. Re: vb6: how use an user type parameter on a class function\sub?

    Had that thought, too, but since it's Graphic-API's i wouldn't be surprised when there are other API's waiting down the code, which actually are expecting a POINT-Structure as an argument
  20. Re: vb6: how use an user type parameter on a class function\sub?

    hrhrhrhrhr.....
    Written in Office/VBA (that's why the PtrSafe and LongPtr is there)



    Private Declare PtrSafe Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (Destination As Any, Source As...
  21. Thread: Dates...

    by Zvoni
    Replies
    5
    Views
    334

    Re: Dates...

    Urggghhh.....forgot about the implicit Type-Cast

    Nevermind, that you should never save a Date/Time-value in a String-Variable.
    Just use Format (which returns a string) to assign/show/display...
  22. Replies
    3
    Views
    242

    Re: Can I view contents of a recordset?

    Or if you know the internals of your DB-Backend you can just query the System-Tables......
  23. Replies
    7
    Views
    368

    Re: Truncate the Array

    Or Dim the new Array to its new Size, and then CopyMemory the VarPtr of the old Array to the new Array with the correct/new length.
    Don't forget to cheat the ref-count.

    EDIT: I'm with baka on...
  24. Thread: Dates...

    by Zvoni
    Replies
    5
    Views
    334

    Re: Dates...

    Why not just use the predefined Formats?
    Debug.print Format(Now, "Short Date")
    Or the FormatDateTime-Function?
    Debug.Print FormatDateTime(Cstr(EstDate),vbShortDate)
  25. Replies
    4
    Views
    222

    Re: Correct use CreateDirectory API

    It has nothing to do with SecurityAttributes, but with Access-Rights the User, who's running the Program, has.

    It's the age old problem with write-access to "c:\Program Files" and similiar folders...
  26. Replies
    18
    Views
    716

    Re: Extended ascii characters

    Eh? How do you figure it's supposed to be 241?
    On my machine (Germany) the "" is: ALT+0177
    https://www.ascii-code.com/
  27. Replies
    24
    Views
    698

    Re: Different Boggle Question

    You know, looking at the link wqweto provided.......

    .... i don't think there is enough alcohol on the planet for me to suddenly understand a single word of that one day.......
    :D
  28. Replies
    24
    Views
    698

    Re: Different Boggle Question

    Sam, your initial Problem reminds me of Conways "Game of Life":
    It checks the (max) 8 possible squares around the "selected" square for a "state" (dead/alive)
    Maybe you can find an algorithm there:...
  29. Replies
    13
    Views
    570

    Re: Remove Duplicate Entries From UDT Array

    As a "quick" ( ! ) solution:
    Your "RT"-Field seems to be the "key" of the Array, and you want it to be unique, albeit with the Highest Width of a Glyph.
    As an algorithm (Aircode)
    Define/Dim a...
  30. Re: [VB6/VBA] A clipboard management class (currently have issues in x64)

    Have you checked, if "lpClipMemory + Len(tDropFiles)" in your copymemory-call actually translates to a Memory-Address?
    Add to Watch-Window:
    lpClipMemory
    Len(tDropFiles)
    lpClipMemory +...
  31. Replies
    16
    Views
    670

    Re: Timestamp on data change

    Haven't looked at the Workbook.
    1) If you want to use a VBA-Function directly in a cell on a sheet, this function must be "Public" in a standard-module.
    2) That said in 1): How are you passing...
  32. Re: Finding a subfolder with the highest number that matches a pattern

    Agree with Arnout.
    Collect the Foldernames with Dir (or its API-Sisters) matching that particular pattern,
    comparing Foldernames to your Pattern you can use the "Like"-Operator
    in a hidden ( ! )...
  33. Re: [VB6/VBA] A clipboard management class (currently have issues in x64)

    Between your working 32-Bit and not working 64-Bit-Version: Have you checked if there is a difference between Len(tDropFiles) vs. LenB(tDropFiles)?
  34. Re: [VB6/VBA] A clipboard management class (currently have issues in x64)

    You do know, that the VBA7-constant checks the Office-Version, not the Bitness of the Office-Version?

    I've run into a similiar Problem, when the company i work for switched from Office2016-32Bit...
  35. Excel 2019: ActiveX-Listbox works on my computer, but not on another Computer

    Hi Folks,

    something weird:

    I've written a small tool for my boss in excel (for him to query our database).
    For that, on the primary worksheet there are some ActiveX-Controls (ActiveX, not...
  36. Replies
    9
    Views
    532

    Re: Textbox with calculator?

    And now i'm going for the Overkill:
    Why not shell calc.exe, use the PID that shell returns to find/get the hWnd of calc.exe, and then SetParent to a Picture-Box?

    Right, just thinking out of my...
  37. Replies
    39
    Views
    1,638

    Re: Load image into STATIC control Win32

    You mean besides the point that this is VBA/Office apparently?
  38. Replies
    22
    Views
    933

    Re: VBRichClient - SQLite - Slow Loading Data

    ...."...and i see fire...."....errrr....."SELECT * FROM....."

    if all those queries are supposed to be displayed in one and the same Grid, i'd start taking them apart, and see if can create one...
  39. Replies
    22
    Views
    933

    Re: VBRichClient - SQLite - Slow Loading Data

    Agree with Arnout: It's probably more your query than sqlite or RC5
    the usual culprit is a "SELECT * FROM Table".....

    Btw: What's the expected RecordCount?
    I don't know if RC5 is already...
  40. Replies
    23
    Views
    918

    Re: Vb6: Winsock data arrival truncated problem

    Is it a multiline-textbox (incl. expanded on the form to be bigger and show more lines than the "standard" one line?
    Maybe there is a vbCrLF/chr(0) hidden in your data arriving......
Results 1 to 40 of 498
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width