Search:

Type: Posts; User: Elroy

Page 1 of 13 1 2 3 4

Search: Search took 0.33 seconds.

  1. Replies
    2
    Views
    164

    Re: Font size units in the EXE

    ...deleted...
  2. Replies
    2
    Views
    164

    [RESOLVED] Font size units in the EXE

    I've decided to do all of this another way. I've already got it up and running, and filed this code away in an "Archived-Not-Useful" folder.
  3. Re: [RESOLVED] Trying to make an app portable using SxS but ending up with an entry i

    I think you're getting some conflict between the registered version of the OCX, and the manifest when it's being used.

    Truth be told, when these OCX files are registered (if they are), they should...
  4. Re: Trying to make an app portable using SxS but ending up with an entry in the Regis

    Ok, before I get too carried away doing tests, vbrad, the sub-folder I used is always named "Dependencies".

    So, try changing the following line from your manifest file from:



    to:
  5. Re: Trying to make an app portable using SxS but ending up with an entry in the Regis

    Ahhh, I do place my OCX (and ActiveX DLL) files within a sub-folder. I guess maybe I once knew they'd auto-register but have forgotten it.

    I'm at my desk now, and will take a look at the OP.
  6. Re: Trying to make an app portable using SxS but ending up with an entry in the Regis

    Yeah, I'll take a look at it later today. But, for my primary LARGE app, it runs totally "portable" (no install, no registration of any OCXs nor DLLs), and very few of the machines it runs on have...
  7. Replies
    12
    Views
    449

    Re: Error to do with Connectivity

    Good advice, thanks. I'll remember this when the email dialog starts back up this week (which I'm sure it will).
  8. Replies
    33
    Views
    1,023

    Re: Fast String Math Function - VB6

    That might help a tiny bit, but, AFAIK, all that's doing is testing whether or not ObjPtr is zero.
  9. Replies
    12
    Views
    449

    Re: Error to do with Connectivity

    I've already shot an email off suggesting that maybe they move to a non-VM server. I'll see what becomes of that before I start getting into the weeds with this one. I'm sure nothing will happen...
  10. Replies
    33
    Views
    1,023

    Re: Fast String Math Function - VB6

    Post your test code???
  11. Replies
    6
    Views
    244

    Re: VB6+Win32 - Menus

    Subclassing. I've never custom made menus, but subclassing still has to be the answer.
  12. Replies
    59
    Views
    1,517

    Re: Adding a huge number of records to a MariaDB

    Yes, that's the bottom line. However, if the import speedup is anywhere near that dramatic, you could probably just leave all your data as 7Zipped, and then import it for analysis on an "as needed"...
  13. Replies
    12
    Views
    449

    Re: Error to do with Connectivity

    The idea of using static IPs is also a good one. I know that used to be the policy, but that was several years ago. I'll check on that one, and make that recommendation.

    I also just got this...
  14. Replies
    33
    Views
    1,023

    Re: Fast String Math Function - VB6

    Gosh, if performance comparisons are done, we shouldn't be instantiating our objects on each evaluation (for either VBScript or Jet).

    Actually, wqweto, I just stared at your code some more and...
  15. Replies
    59
    Views
    1,517

    Re: Adding a huge number of records to a MariaDB

    WOW, if that's all correct, that's impressive. One thing that caught my eye was:



    And supposedly, on importing CSV files, they reduced the time from 20 minutes (with SQLlite) to 0.6 seconds...
  16. Replies
    33
    Views
    1,023

    Re: Fast String Math Function - VB6

    Orange, again, that's only going to work while running in the VB6 IDE. When using the scripting engine, are you just loading it once, and then using it for your expressions? If you're loading it...
  17. Replies
    33
    Views
    1,023

    Re: Fast String Math Function - VB6

    If you're in the IDE, there's an "execute" API. I believe it's EbExecuteLine, but you'd have to search to get the details. Basically, that's executing the line just as it'd execute in the Immediate...
  18. Replies
    12
    Views
    449

    Re: Error to do with Connectivity

    You know? Something else I just thought of. These physical locations (where the LANs are) all have many servers. I'd estimate a minimum of 6 per location (possibly quite a few more). But I don't...
  19. Replies
    12
    Views
    449

    Re: Error to do with Connectivity

    From what they tell me, it's happening on all the PCs using my software (and that's true in both locations where it's happening).



    The event log is an excellent idea. I'll shoot an email off...
  20. Replies
    12
    Views
    449

    Error to do with Connectivity

    This probably doesn't have to do with VB6 directly, but it is a VB6 program having the problem.

    I've got two separate clients (out of many) having this problem. One has been having it for years...
  21. Re: [resolved] How To Make The Form Transparent In 6.0

    Option Explicit
    '
    Private Declare Function GetWindowLong Lib "user32" Alias "GetWindowLongA" (ByVal hwnd As Long, ByVal nIndex As Long) As Long
    Private Declare Function SetWindowLong Lib "user32"...
  22. Re: How To Make The Form Transparent In 6.0

    Change it in the two places in that MakeFormTransparent call. You could use a VERY unique color, maybe &hf4d5c6 to make sure nothing else was that color. You could also smarten up that Sub to pass...
  23. Re: How To Make The Form Transparent In 6.0

    A more complex way (but with much more control) involves "regions". Here are some API calls to get you started in case you consider that option:



    Private Declare Function SetWindowRgn Lib...
  24. Re: How To Make The Form Transparent In 6.0

    There are a few ways to do this, but a fairly straightforward one is something like:



    Option Explicit
    '
    Private Declare Function GetWindowLong Lib "user32" Alias "GetWindowLongA" (ByVal hwnd...
  25. Replies
    59
    Views
    1,517

    Re: Adding a huge number of records to a MariaDB

    SmUX2k, if you're interested, you could "peel out" my "validation" code if you wanted to use that, as it's fairly independent from the "unzip" and/or "push into MariaDB" code. I didn't do a great...
  26. Replies
    2
    Views
    323

    Re: IDE VB6 + SP6 + MS16-004 and nothing more?

    Yeah, I just use the KB3096896 VB6 SP6 rollup.

    So, I just get the VB6 IDE installed (including its MSDN package), and then KB3096896 and I'm basically done. I also install some shims ... but, if...
  27. Replies
    59
    Views
    1,517

    Re: Adding a huge number of records to a MariaDB

    I've done a bit more tweaking on the way I'm doing multi-threading. (Project attached.)

    But I also downloaded that BBBY2010 file (in post #50 above) (and re-zipped it as a standard ZIP file, as...
  28. Replies
    10
    Views
    484

    Re: BeforeColEdit Problem

    That's correct, but just to say a bit more.

    There actually is an ASCII value for "Delete". It's 127 (or &h7F). However, for "almost" as long as I can remember, that's not how the "Del" key on...
  29. Re: TRYING TO RUN EXCEL OUTPUT USING Latest MS Office 365 (Versioin 16)

    It's all good. :) I was just sharing my experience and understandings.
  30. Re: TRYING TO RUN EXCEL OUTPUT USING Latest MS Office 365 (Versioin 16)

    There's no problem automating 64-bit applications from VB6. My users do it everyday, all day long. It's similar to issuing a SQL command to a 64-bit SQL Server. It's just a different process...
  31. Replies
    25
    Views
    1,168

    Re: Installing VB6 on Windows 11

    That roll-up link for it above works perfectly!
  32. Replies
    25
    Views
    1,168

    Re: Installing VB6 on Windows 11

    Are you running it with administrative privileges?

    Also, did you manage to get the VB6 IDE actually installed? The SP6 is only to be installed AFTER you get the VB6 IDE installed.
  33. Replies
    25
    Views
    1,168

    Re: Installing VB6 on Windows 11

    Ahhh, Dan Brust's blog about how to fix a borked installation is gone.

    But here it is on the Wayback Machine.
  34. Replies
    25
    Views
    1,168

    Re: Installing VB6 on Windows 11

    I don't use Enterprise, and don't have any problems. I'm not sure any of my VB6 versions are Enterprise.

    You just have to follow my instructions, and things work fine. But, I've heard horror...
  35. Replies
    59
    Views
    1,517

    Re: Adding a huge number of records to a MariaDB

    MariaDB actually expects dates to be in precisely the format they're in inside those TXT files. That's what leads me to believe they were created with the inverse of "LOAD DATA INFILE". They go...
  36. Replies
    59
    Views
    1,517

    Re: Adding a huge number of records to a MariaDB

    Also, this data is extremely relational. Even the records in the ASCII file are nearly all the same size (with floating point decimals the only differences), and absolutely always have the same...
  37. Replies
    59
    Views
    1,517

    Re: Adding a huge number of records to a MariaDB

    I checked.

    The ASCII unzipped data is 12,497,178,624 bytes for that BBBY.zip file. That's roughly 12GB. Interestingly, that's not much different in the imported MariaDB size. They're much...
  38. Replies
    59
    Views
    1,517

    Re: Adding a huge number of records to a MariaDB

    Another option that might be worth exploring is creating a separate table for each ticker symbol. I'll let you mess with that though, if you look more into the MariaDB route.

    I'm gonna play with...
  39. Replies
    59
    Views
    1,517

    Re: Adding a huge number of records to a MariaDB

    Also, if I get multi-threading going for the "LOAD DATA INFILE..." statements, I believe I've figured out a way to do some fairly non-obtrusive polling to estimate a percent-complete for importing...
  40. Replies
    59
    Views
    1,517

    Re: Adding a huge number of records to a MariaDB

    Ahhh, my bad, you're right ... 12 years of data.

    For grins, I just 7zipped (7Z) that MariaDB IBD file. It 7zipped down to 876MB, so just under what the original ZIP file was. And took about 4...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width