Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.15 seconds.

  1. Replies
    3
    Views
    110

    Re: Passing UDT to a form...

    Basically the same discussion:
    https://www.vbforums.com/showthread.php?889125-vb6-how-use-an-user-type-parameter-on-a-class-function-sub
  2. Replies
    36
    Views
    552

    Re: .txt files

    Huh? Didn't know that one.
    Now, the interesting question would be: Does this work with a "SELECT....INTO....." Statement?

    Aircode-Algorithm
    Source-File: source.txt
    Target-File: target.txt
    Do...
  3. Replies
    16
    Views
    390

    Re: Need help with a querry

    DM, here is the original Thread: https://www.vbforums.com/showthread.php?891128-Very-complicated-but-perhaps-possible!
    If you look at my aircode in Post 16, you'll see there is a line with...
  4. Replies
    2
    Views
    80

    Re: Function not running from excel

    Is it a Public Function in a Standard Code-Module?
  5. Replies
    40
    Views
    1,055

    Re: Very complicated but perhaps possible!

    Well, there we go.
    its now on him
  6. Replies
    40
    Views
    1,055

    Re: Very complicated but perhaps possible!

    Would it explain why he fails in DB-Browser?
  7. Replies
    40
    Views
    1,055

    Re: Very complicated but perhaps possible!

    Hes using RC5
    See post #11
  8. Re: Running VB6 and VB6 apps on Raspberry Pi, or any Linux

    Holy smoke! Yes, i remember High-school, too.
    End of the eighties "Computer Science" was an elective for the last 2 years
    Yeah, laugh it up: "Computer Science" with, IIRC, three XT-Machines with 5...
  9. Replies
    40
    Views
    1,055

    Re: Very complicated but perhaps possible!

    Try it as a single line


    SELECT DISTINCT T1.aut, T2.remain FROM trans As T1 LEFT JOIN (SELECT Aut, ID, remain, Acquit, ROW_NUMBER() OVER(PARTITION BY item_id ORDER BY Aut DESC) AS RN FROM Trans)...
  10. Re: Running VB6 and VB6 apps on Raspberry Pi, or any Linux

    There is already one: https://www.vbforums.com/forumdisplay.php?74-Other-Programming-Languages
  11. Replies
    40
    Views
    1,055

    Re: Very complicated but perhaps possible!

    So it works?
  12. Re: Running VB6 and VB6 apps on Raspberry Pi, or any Linux

    I advise against such a migration-tool.
    FPC/Lazarus has such a slew of options you can use to improve your vb-code.
    Yes, start with a simple project, and port it, but "rewrite it" in a way.
    Yes,...
  13. Re: Running VB6 and VB6 apps on Raspberry Pi, or any Linux

    Porting not that much, since i'm not (and never was) a professional dev.
    Mainly stuff i use at work, which were Excel-VBA-things that i moved/ported to Lazarus.

    @easier/harder: Funny enough:...
  14. Replies
    40
    Views
    1,055

    Re: Very complicated but perhaps possible!

    Eh?
    True.
    It's time for some offtime..... overworked, underjumped, the whole slew......
  15. Replies
    40
    Views
    1,055

    Re: Very complicated but perhaps possible!

    *groan**facepalm*
    Missed that one
    I actually used Arnout's CREATE TABLE/INSERT INTO Statements to create my sample data
  16. Re: [RESOLVED] Constraint within primary key - sql server database

    bruahahahahahahahah
    rotfl
  17. Replies
    40
    Views
    1,055

    Re: Very complicated but perhaps possible!

    Strange.
    I did that Query in DB-Browser for SQLite (sqlitebrowser.org), and it worked.
    Maybe you have a typo or missing blank/comma somewhere
    Could you try to run that query in a DB-Tool like mine?
  18. Replies
    40
    Views
    1,055

    Re: Very complicated but perhaps possible!

    Done in SQLite

    SELECT DISTINCT
    T1.aut,
    T2.remain
    FROM
    trans As T1
    LEFT JOIN
    (SELECT Aut,ID, remain, Acquit,ROW_NUMBER() OVER(PARTITION BY item_id ORDER BY Aut DESC) AS RN
    FROM Trans)...
  19. Re: Running VB6 and VB6 apps on Raspberry Pi, or any Linux

    As i understand it, the Standard-TButtons don't like coloring in Lazarus under Windows
    Look at reply #2
    https://forum.lazarus.freepascal.org/index.php/topic,53897.0.html

    btw: I don't think we...
  20. Re: Running VB6 and VB6 apps on Raspberry Pi, or any Linux

    I'd advise you to register yourself at the official Lazarus-Forum.
    I'm registered there myself. The people there are pretty laid back regarding newcomers to Lazarus
    I did the transition away from...
  21. Re: Constraint within primary key - sql server database

    Agree with Gary, but the UseCase for unique combinations in Detail-Tables is a given.

    e.g.:
    Master-Table holds information about a employee
    Detail-Table holds information about phones issued to...
  22. Re: Constraint within primary key - sql server database

    Sorry, don't understand the requirement
  23. Replies
    10
    Views
    285

    Re: Mysql Nested sub query

    Huh?
    Any chance to upgrade to at least 5.7 or 8?
    Otherwise:
    Create a View from the INNER SELECT_Statement (since it doesn't have parameters/dynamic filters)
    the you can address that view as any...
  24. Replies
    10
    Views
    285

    Re: Mysql Nested sub query

    Works in SQLite. No Idea if you have to change anything for MySQL

    SELECT DISTINCT
    T1.asset_id,
    T2.meter_reading,
    T2.reading_date
    FROM
    source_table T1
    INNER JOIN
    (SELECT
  25. Re: Get custom shortcut overlay / read HKEY_LOCAL_MACHINE failing

    What i could find out: There seems to be the fact, that "Shell Icons" is missing sometimes in the Registry.

    Have you thought about
    1) Query Registry for that Key
    2) If Error (Key not present)...
  26. Replies
    10
    Views
    285

    Re: Mysql Nested sub query

    ZIP it first, click on "go advanced" then on manage attachments
  27. Replies
    10
    Views
    285

    Re: Mysql Nested sub query

    On first glance this looks like a case for ROW-NUMBER() OVER(PARTITION BY asset_id ORDER BY reading_date DESC) As RN
    with a Filter in the WHERE-clause RN<=2

    Do have sample-data as a csv?
  28. Re: Sqlite error: Safety level may not be changed inside a transaction

    Maybe you have a pending Commit somewhere earlier?

    btw: I have no idea how Olaf implemented the Synchronous-Property, but in "pure" SQLite, Synchronous is a PRAGMA-Call (which is basically the...
  29. Re: Need help to create this control (some sort of 'node' cell)

    For vb6? Not that i know of.
    I know that it's available in other Languages (in my Case Lazarus/FreePascal), but for vb6.... *shrug*
  30. Re: DirectX8 AUDIO Modulation/Pitchbend

    A modulation or pitch bend is an Effect.
    And the "classic" way (a.k.a. at a mixing console) to deal with Effects is to never change the original signal, but additionally sending the original signal...
  31. Re: Need help to create this control (some sort of 'node' cell)

    So what he basically wants, is a ListView in report-style married with a TreeView.
    The (multicolumn) TreeView would be the "Parent", while the (multicolumn) ListView would be the "Detail"
  32. Re: shell execute close the current window on installl click

    You don't call ShellExecute in your Sub
  33. Re: Win-10 v19042 (Updated on Tues) and M$ Word 97 Issues

    What about the "standard" template (normal.dot)?
    Corrupted?
  34. Replies
    6
    Views
    419

    Re: [RESOLVED] Request 64 bits NorthWind.mdb

    AFAIK, The Database-Format itself (in your case the Database-File) has nothing to do with Bitness of Access, only with Version of Access

    https://www.fmsinc.com/MicrosoftAccess/history/features.htm
  35. Re: Help Making This Code A Bit More Intuitive

    IIRC, a Function-Argument in a Do-While-Loop is executed everytime, so in your case i'd go for a


    Do While FileExists(FileName)
    'DoSomething and check "next" FileName, count up your Counter...
  36. Replies
    3
    Views
    233

    Re: Extract from table all row between date

    Wrong Forum. This belongs at Database

    To your Question: Which DBMS?
  37. Replies
    16
    Views
    739

    Re: What's wrong with this oop program.

    At first look:
    There is a reason i dislike "Dim MyArray(101) As Integer"
    A "Dim MyArray(0 To 100) As Integer" is more clear in regards to your requirement.
    Then your test against it is just "If...
  38. Thread: Query db

    by Zvoni
    Replies
    2
    Views
    173

    Re: Query db

    Uhhh.... start learning SQL?


    SELECT
    cod,
    SUM(quantity) As qty
    FROM
    MyTable
    GROUP BY
    cod
  39. Replies
    35
    Views
    1,098

    Re: Prevent Form_Activate

    IIRC, the Activate-Event fires when a Form gets the Focus (back).
    So as the others said: you need a flag preventing the Code in the Event to run.

    I don't like global variables, so another...
  40. Replies
    10
    Views
    402

    Re: Trying to identify the *.BAS file

    I know why i love the "grep"-Tool on Linux....
    As jdc recommended: "grep" for something static and known (like a Caption of a Form)
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width