Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.43 seconds.

  1. Re: User action versus code causing event to raise

    See my edit
    you could even go with baka‘s master-function passing a flag as a local argument (an Enum maybe). In the master-function it would be a Select Case against the Enum
  2. Re: User action versus code causing event to raise

    Ah…. Ok, i think i got it now.
    But, AFAIK, not possible, since an event (in your case click on checkbox) is basically just a callback-function executed in the underlying c-code, and as with each...
  3. Re: User action versus code causing event to raise

    I don't understand your "whether the user or other code fired the event"
    In your example it's the user firing it (actually: it still "hidden" code firing it)

    Do you mean something like


    'Own...
  4. Replies
    15
    Views
    458

    Re: Help with a query

    In that case my SQL cleaned up to use one INNER JOIN


    SELECT
    T1.SONumber, T1.Control, T1.Status,
    T2.CountTripsTotal, //For demonstration only. Could be left out
    T2.CountTripsCP, //For...
  5. Replies
    15
    Views
    458

    Re: [RESOLVED] Help with a query

    Removed the DISTINCT above in post #11
    No idea how that one sneaked in.
    If you have GROUP BY, DISTINCT is not necessary and just adds noise and might mask a bug, as steve pointed out
  6. Replies
    15
    Views
    458

    Re: Help with a query

    Don't worry. :-)

    But i agree with steve's idea of creating a view on the Trips, if you need to run such a "check" regularly.
    Would go along the lines of (untested)


    CREATE VIEW 'vwTrips' AS...
  7. Replies
    26
    Views
    795

    Re: Playing music

    https://docs.microsoft.com/en-us/windows/win32/directshow/event-notification-codes
    https://docs.microsoft.com/en-us/windows/win32/directshow/ec-complete
    That said: No idea how to use it
  8. Replies
    15
    Views
    458

    Re: Help with a query

    I always wondered about that: Is it because a VIEW is pretty much a precompiled SELECT-Statement?
    Is there a difference in Performance (Proper Indices on relevant columns provided)?
  9. Replies
    60
    Views
    3,393

    Re: Reading Proficiency and Programming

    See my Signature.
    There is a quote i adapted to my Signature:
    "Code is like Humor: If you have to explain it, it's bad! - Cory House"
  10. Replies
    15
    Views
    458

    Re: Help with a query

    couldn't resist...

    :D:D:bigyello::bigyello:
  11. Replies
    15
    Views
    458

    Re: Help with a query

    szl,
    second SQL, last Line should read ... Trips.Status='CP'

    EDIT: Forget it.
    I missed the NOT Exists
  12. Replies
    2
    Views
    207

    Re: check CON.BeginTrans

    And by reading the documentation you would find this:...
  13. Replies
    15
    Views
    458

    Re: Help with a query

    Tested in SQLite


    SELECT
    T1.Description,
    T2.CountTripsTotal,
    T3.CountTripsCP
    FROM
    tblJobs AS T1
    LEFT JOIN
  14. Replies
    5
    Views
    340

    Re: CopyMemory to copy function address

    it's one of the things i really like about FreePascal: I can declare different variables (Not Pointers!) to point to the same memory-block


    program Project1;

    Var
    p:Integer;
    i:Integer...
  15. Replies
    5
    Views
    340

    Re: CopyMemory to copy function address

    If the Value of Pnt is e.g. "pnt = 123456", Dest receives the Value stored at Memory 123456

    Usually, in context of CopyMemory, you use ByVal always either with a Pointer-Function (VarPtr, StrPtr,...
  16. Replies
    5
    Views
    340

    Re: CopyMemory to copy function address

    No. With ByRef you pass the Address of the Variable pnt, which has a Value of a Procedure-Address.
    CopyMemory doesn't care that the Value of pnt is an address. It's a Long which is 4 Bytes long

    ...
  17. Re: [RESOLVED] Type Mismatch problem regarding an If Else statement

    Does anyone remember the "Rem"-Keyword?
    It still works in vb6.....


    Sub Main()
    Rem This is a comment

    End Sub
  18. Re: [RESOLVED] Type Mismatch problem regarding an If Else statement

    And exactly because of that i declare all my variables each in its own line, and i'm making no difference which language i use (C, VB, Pascal)

    Ask yourself a question: What's more important for...
  19. Re: [RESOLVED] Type Mismatch problem regarding an If Else statement

    ...and V and B are not Strings, but Variants
    and just reading that code-snippet i have no idea how V and B can be anything else than empty
  20. Replies
    4
    Views
    284

    MsOf365 Re: Delete blank columns with VB.NET

    Go backwards through the columns
    You're going forward from 1 to Count, but by deleting a column you change the count (Deleting column B means Column C shifts one to the left and becomes Column B)...
  21. Replies
    5
    Views
    262

    Re: Trickish Situation With Data Range Search

    Because it's a Database.
    And filtering your resultset on the Server-side via SQL will always beat a seek on a complete table.

    EDIT: IIRC, seek only works on a single Comparator. In OP's case he...
  22. Replies
    5
    Views
    262

    Re: Trickish Situation With Data Range Search

    SELECT * FROM tabjrecord WHERE 6300 BETWEEN Col3 AND Col4

    And i agree with Arnout: No Banana, but Apple instead
  23. Re: Remove dead COM entries in the registry.

    Well, your question was how to backup. Restore wasn't part of the question :D
    Another way: Copy/Backup the Files directly -->...
  24. Re: Remove dead COM entries in the registry.

    Huh?
    Open Reg-Editor, right-click on "Computer" (upper left corner in left window, It's the root of the TreeView) --> Export
  25. Re: Remove dead COM entries in the registry.

    On a "sensitive" machine, after a clean install, setup of apps/programs, and everything runs like it's supposed to do, i do a backup of the disk (!!) with CloneZilla.
    So i get my partition layout,...
  26. Replies
    2
    Views
    293

    Re: SQL Server fulltext - Search failures

    1) Since you're using double quotes (simple_term = exact match case insensitive), have you tried the LIKE-Operator instead? Maybe lower casing everything before comparing
    Just to test if the results...
  27. Replies
    32
    Views
    928

    Re: Reference a .NET DLL in VB5

    In the VB5-IDE go to references and look for your objects from that dll.
    they should appear there
  28. Replies
    2
    Views
    194

    Re: Looking for workflow-advice

    In regards to "available stock at Level30 and below"? Yes



    That was my first thought, too, but then i was confronted with the scenario "and if the ladies have a lazy week, and don't scan...
  29. Replies
    2
    Views
    194

    Looking for workflow-advice

    Hi Folks,

    situation:
    Warehouse with Stock called "H1"
    An item can be on multiple locations (separated by incoming-date, lot-no and some other criteria).
    The locations are separated by...
  30. Replies
    32
    Views
    928

    Re: Reference a .NET DLL in VB5

    And you followed all steps mentioned?
    https://web.archive.org/web/20120210204121/http://support.microsoft.com/kb/817248
  31. Thread: Excel timer

    by Zvoni
    Replies
    7
    Views
    391

    Re: Excel timer

    I'm trying (and failing) to wrap my mind around this


    Range("D29") = Range("D29") - TimeValue("00:00:00")

    TimeValue("00:00:00")???
    Huh?
  32. Replies
    13
    Views
    652

    Re: calculate percentage

    I Wrote "Tested in SQLite"
    Each DBMS has its own Dialect/Syntax
    I could not detect which DBMS you are using
  33. Replies
    13
    Views
    652

    Re: calculate percentage

    I edited my post: Use LEFT JOIN instead of INNER JOIN and look at the IFNULL's

    This gives the Percentage of each VType to the Total of all Barcodes
    If you want the Percentage Within a VType-Group...
  34. Replies
    13
    Views
    652

    Re: calculate percentage

    The only crash you can get, is when you don't have any Barcodes => The Table is Empty
  35. Replies
    13
    Views
    652

    Re: calculate percentage

    Your Percentage-Thing:
    Tested in SQLite


    SELECT
    T1.VType,
    IFNULL(T2.Reserved / (SELECT COUNT(Barcode) FROM tblOPVoucher)*100,0) As ReservedPerc,
    IFNULL(T3.NoReserved / (SELECT COUNT(Barcode)...
  36. Replies
    13
    Views
    652

    Re: calculate percentage

    1) Is this a Typo?
    "1111112,1,2" --> IsReserved has Value 2
    in your WHERE-Clause you compare IsReserved=1 --> meaning that one with Value 2 is ignored
    2) How do you figure in your first example,...
  37. Replies
    10
    Views
    324

    Re: SQL statement problem

    Then you're having a typo in your fieldname
  38. Replies
    10
    Views
    324

    Re: SQL statement problem

    ?
    "AND TBL.NAME2<>'" & Chr(32) & "'"
  39. Re: Is it possible to convert an .exe file to 64-bit?

    Follow-up question: IIRC, vb6.exe emitts c-code which is passed to c2.exe, which then creates the OBJ-Files and links everything together (correct me if i'm wrong)
    Is it possible to intercept THAT...
  40. Replies
    39
    Views
    1,054

    Re: Binary Search Not Finding Capitals

    If you do not read the file into memory beforehand, then yes, you need random mode.
    BUT: AFAIK, the File must be saved in Random mode beforehand, meaning you probably need to change everything to...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width