Search:

Type: Posts; User: OldClock

Page 1 of 6 1 2 3 4

Search: Search took 0.15 seconds.

  1. Replies
    9
    Views
    1,159

    Re: Collection parameter ByRef vs ByVal

    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...
  2. Replies
    9
    Views
    1,159

    Re: Collection parameter ByRef vs ByVal

    Thank you Elroy
  3. Replies
    9
    Views
    1,159

    Collection parameter ByRef vs ByVal

    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...
  4. Replies
    4
    Views
    708

    Re: Get local IP address using RC5

    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.
  5. Replies
    4
    Views
    708

    Get local IP address using RC5

    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....
  6. Replies
    4
    Views
    784

    How to force DPI to 96

    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?
  7. Re: How to catch SQL error number using ADODB?

    I found error number 45123 lurking in m_cn.Errors(0).NativeError where m_cn is an ADODB.Connection
  8. How to catch SQL error number using ADODB?

    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...
  9. Replies
    3,725
    Views
    1,854,568

    Re: CommonControls (Replacement of the MS common controls)

    [deleted, obsolete]
  10. Replies
    3,725
    Views
    1,854,568

    Re: CommonControls (Replacement of the MS common controls)

    [deleted, obsolete]
  11. Re: ListBox.ListIndex = -1 doesn't clear current item highlight if app uses visual st

    Try:


    List1.Selected(List1.ListIndex) = False
  12. Re: [RC5] Convert CSV files to SQLite file-based DB

    Thank you Schmidt.
  13. Re: [RC5] Convert CSV files to SQLite file-based DB

    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...
  14. Re: VB6 2D-ChartPlotting (using the RC6.cChart HelperClass)

    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....
  15. Re: VB6 2D-ChartPlotting (using the RC6.cChart HelperClass)

    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...
  16. [RC5] Convert CSV files to SQLite file-based DB

    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...
  17. Re: Allow editing code while running, or auto-pause

    > 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...
  18. Allow editing code while running, or auto-pause

    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...
  19. Re: [VB6] AddIn - Comment/Code Display + Highlight + Extra Hotkeys (Updated 28/08/21

    > 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...
  20. Re: VB6 2D-ChartPlotting (using the RC6.cChart HelperClass)

    Thank you Schmidt, that works perfectly.
  21. Re: VB6 2D-ChartPlotting (using the RC6.cChart HelperClass)

    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...
  22. Re: [VB6] AddIn - Comment/Code Display + Highlight + Extra Hotkeys (Updated 10/06/21

    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...
  23. Re: VB6 2D-ChartPlotting (using the RC6.cChart HelperClass)

    Fantastic, thank you Schmidt. The demo worked correctly following your instructions in XP using RC5.0.80.
  24. Re: VB6 2D-ChartPlotting (using the RC6.cChart HelperClass)

    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...
  25. Replies
    18
    Views
    3,879

    Re: Create a label programmatically

    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")
  26. Replies
    9
    Views
    1,789

    Re: MySQL & ADO queries speed

    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.
    ...
  27. Re: How to execute shell command which uses a pipe

    Err yeah, I meant "command prompt".

    Thank you, Shell() worked well.
  28. How to execute shell command which uses a pipe

    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 =...
  29. Re: RC5 Simplest way to copy table from ADODB to SQLite

    Thank you Arnoutdv
  30. Re: RC5 Simplest way to copy table from ADODB to SQLite

    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...
  31. Re: RC5 Simplest way to copy table from ADODB to SQLite

    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:


    ...
  32. Re: RC5 Simplest way to copy table from ADODB to SQLite

    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
  33. Re: RC5 Simplest way to copy table from ADODB to SQLite

    Fantastic, thank you!
  34. Re: RC5 Simplest way to copy table from ADODB to SQLite

    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,...
  35. Replies
    18
    Views
    3,879

    Re: Create a label programmatically

    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...
  36. Re: RC5 Simplest way to copy table from ADODB to SQLite

    Hey Schmidt

    How serendipitous that you answered :)



    Ah but that would be overkill, I only need one or two tables.
  37. RC5 Simplest way to copy table from ADODB to SQLite

    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...
  38. Replies
    9
    Views
    1,906

    Re: RC5 how to load DB from file into cMemDB

    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...
  39. Replies
    18
    Views
    3,879

    Re: Create a label programmatically

    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...
  40. Replies
    9
    Views
    1,906

    Re: RC5 how to load DB from file into cMemDB

    Thank you for both responses.
Results 1 to 40 of 236
Page 1 of 6 1 2 3 4



Click Here to Expand Forum to Full Width