Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.29 seconds.

  1. Re: mssql why use OUTPUT and not select?

    Then change the stored procedure on the server. Assign a default (of NULL) to the OUTPUT-Param
  2. Re: mssql why use OUTPUT and not select?

    Then don't. Pass a NULL for the Output-Param
  3. Re: mssql why use OUTPUT and not select?

    How do you figure that?
    AFAIK, an OUTPUT-Param from a SP can be ignored by either passing a NULL or setting a default-value in the header of the SP...
  4. Re: VB6 vs .NET differences ... IDE, libraries, functionality, whatever

    "This contest is scheduled for one fall"
    DING DING DING
  5. Re: mssql why use OUTPUT and not select?

    With OUTPUT-Params you can return more than one value back to the caller
  6. 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
  7. 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...
  8. 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...
  9. Replies
    15
    Views
    465

    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...
  10. Replies
    15
    Views
    465

    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
  11. Replies
    15
    Views
    465

    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...
  12. Replies
    26
    Views
    812

    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
  13. Replies
    15
    Views
    465

    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)?
  14. Replies
    60
    Views
    3,407

    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"
  15. Replies
    15
    Views
    465

    Re: Help with a query

    couldn't resist...

    :D:D:bigyello::bigyello:
  16. Replies
    15
    Views
    465

    Re: Help with a query

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

    EDIT: Forget it.
    I missed the NOT Exists
  17. Replies
    2
    Views
    217

    Re: check CON.BeginTrans

    And by reading the documentation you would find this:...
  18. Replies
    15
    Views
    465

    Re: Help with a query

    Tested in SQLite


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

    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...
  20. Replies
    5
    Views
    348

    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,...
  21. Replies
    5
    Views
    348

    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

    ...
  22. 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
  23. 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...
  24. 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
  25. Replies
    4
    Views
    291

    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)...
  26. Replies
    5
    Views
    264

    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...
  27. Replies
    5
    Views
    264

    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
  28. 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 -->...
  29. 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
  30. 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,...
  31. Replies
    2
    Views
    301

    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...
  32. Replies
    32
    Views
    944

    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
  33. Replies
    2
    Views
    201

    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...
  34. Replies
    2
    Views
    201

    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...
  35. Replies
    32
    Views
    944

    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
  36. Thread: Excel timer

    by Zvoni
    Replies
    7
    Views
    400

    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?
  37. Replies
    13
    Views
    670

    Re: calculate percentage

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

    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...
  39. Replies
    13
    Views
    670

    Re: calculate percentage

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

    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)...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width