Search:
Type: Posts; User: OldClock
Search:
Search took 0.03 seconds.
-
I was surprised to find that r_col.Add worked fine when r_col was passed ByVal. And here I've been coding in VB6 for some seven years.
Private m_oCol As Collection ' 1. Declare the object...
-
-
Hey
I'm wondering about the use of passing a collection ByRef, could anyone give a practical example?
As I understand it, in the following example it makes no difference whether the r_col...
-
Thank you, IPHlpApi seems to work well.
Still curious whether RC5/VBCCR17 provide any simple method of getting a list of this machine's IP addresses, or MAC addresses for that matter.
-
Hey
I'm looking for a simple way of getting the machine's IP address without using winsock or WMI. I am using vbRichClient5 (and as I'm forced to support WinXP, I'm using RC5 not RC6) and VBCCR17....
-
Hey
I have Windows XP set to 144DPI, but when running my program in the VB6 IDE I need that program to use 96DPI. How do I do that?
-
I found error number 45123 lurking in m_cn.Errors(0).NativeError where m_cn is an ADODB.Connection
-
Hey
I wrote a MariaDB stored procedure which in certain cases throws an error. The error message is "foo" and the error number is 45123.
The stored procedure:
BEGIN
DECLARE c_abort...
-
-
-
Try:
List1.Selected(List1.ListIndex) = False
-
-
There was a problem that the SQLite DB ends up storing all fields as TEXT when they're all NUMERIC. Instead of haggling with this downstream, I wanted to fix it at the source. This uses a schema with...
-
This started off as a bug report about GetMinMaxFromData until I realized what was happening regarding the data type, so I agree - admins feel free to move posts #20-#22 to e.g....
-
Hey Schmidt, I have spent several hours troubleshooting an issue, learning things in the process, but haven't found a clean solution yet.
1. I do a one-time conversion of many CSV files to an...
-
Hey
Schmidt I was hoping you could take a look.
I have a bunch of CSV files. Each file has a different number of "columns". The first row of each file names the columns - these column names...
-
> It sounds to me like he is asking for a way to edit the code while it is actually running
Well no. Elory is correct. I would like to just have the IDE pause the running program automatically...
-
Is it possible to hack the VB6 IDE so that while I'm running my program I can alt+tab back to the IDE and just start editing code without having to PAUSE and RESUME, or at least to make it auto-pause...
-
> I wonder why are you still using XP ?
Two-fold: first, I code in a virtual machine from Linux, and WinXP is much faster in a VM than Win10. Second, until recently a lot of the African users of...
-
Thank you Schmidt, that works perfectly.
-
I've been studying the code for days but there are a few things I'm still trying to solve and would appreciate help. Well I think I can solve the other things on my own, but this one thing I'm stuck...
-
Hey
I'm using WinXP SP3 and in v1.0 I had to edit ComCodeDisplay.vbp and change
Object={831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.2#0; MSCOMCTL.OCX
to...
-
Fantastic, thank you Schmidt. The demo worked correctly following your instructions in XP using RC5.0.80.
-
Hi Schmidt
As I am stuck with RC5 due to required Windows XP compatibility, do you have any code examples showing how to draw a chart *with axes* using RC5? Alternatively, an example using some JS...
-
I get a crash on this line when running outside of the IDE, while it works fine in the IDE, any idea?
Set dLbl = dFrm.Controls.Add("VBCCR17.LabelW", "dLbl")
-
I tested my own code. 5000 INSERTs using sequential calls to MariaDB running on localhost took 11465ms, that's 436 INSERT queries per second.
Test on localhost to eliminate external factors.
...
-
Err yeah, I meant "command prompt".
Thank you, Shell() worked well.
-
Hey
I'm trying to pipe output from mysqldump to mysql using a pipe. It works just fine in a dos prompt, but fails when I use it in ShellExecute.
The simplified command is:
r =...
-
-
Schmidt, how do I set the parameters in a parameterized query without using "WITH"? For clarity, let's make it have one parameter a bool, one currency, one datetime.
With...
-
And one more, how can one create a MemDB table from an AdoCnn or AdoRs but without any data? This works, but I wonder whether there's a more straight-forward way:
...
-
Schmidt, is it possible to use a parameterized query here? Something like this:
Set cRs = MemDB.GetRs("SELECT * FROM country WHERE id = ?")
cRs.something.SetText 1, countryId
-
-
Hi Schmidt
I confirm that the BIGINT issue is fixed in 5.0.80. Thank you very much!
For reference for anyone reading this, here is a complete example showing how to create a DB and table,...
-
And now I created a blank "DummyForm" and use this code:
Public Sub fitTextToRptLabel( _
ByRef lbl As RptLabel, _
ByVal txt As String, _
ByVal maxFontSize As Integer, _
ByVal...
-
Hey Schmidt
How serendipitous that you answered :)
Ah but that would be overkill, I only need one or two tables.
-
Hey
My program uses MariaDB through ADODB. I would like to copy a specific table (data, but if there was also a possibility to recreate the schema automatically instead of doing it by hand that...
-
Schmidt, I am comparing using cMemDB vs cConnection in RC5. Is there a way to insert data using parameterized queries using RC5.cConnection?
Like in this example which uses cMemDB instead of...
-
The goal was to get text to fit inside a RptLabel (Microsoft Data Report Designer 6.0). I found that I could not read the final size of a RptLabel which had RptLabel.CanGrow = True - the width/height...
-
Thank you for both responses.
|
Click Here to Expand Forum to Full Width
|