Search:
Type: Posts; User: Elroy
Search:
Search took 0.10 seconds.
-
-
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.
-
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...
-
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:
-
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.
-
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...
-
Good advice, thanks. I'll remember this when the email dialog starts back up this week (which I'm sure it will).
-
That might help a tiny bit, but, AFAIK, all that's doing is testing whether or not ObjPtr is zero.
-
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...
-
-
Subclassing. I've never custom made menus, but subclassing still has to be the answer.
-
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"...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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"...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
It's all good. :) I was just sharing my experience and understandings.
-
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...
-
That roll-up link for it above works perfectly!
-
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.
-
Ahhh, Dan Brust's blog about how to fix a borked installation is gone.
But here it is on the Wayback Machine.
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
|
Click Here to Expand Forum to Full Width
|