Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.46 seconds.

  1. Replies
    1
    Views
    88

    Re: Help with a query

    Tested in SQLite


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

    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...
  3. Replies
    5
    Views
    267

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

    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

    ...
  5. 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
  6. 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...
  7. 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
  8. Replies
    4
    Views
    218

    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)...
  9. Replies
    5
    Views
    233

    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...
  10. Replies
    5
    Views
    233

    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
  11. 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 -->...
  12. 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
  13. 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,...
  14. Replies
    2
    Views
    242

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

    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
  16. Replies
    2
    Views
    160

    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...
  17. Replies
    2
    Views
    160

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

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

    by Zvoni
    Replies
    7
    Views
    343

    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?
  20. Replies
    13
    Views
    602

    Re: calculate percentage

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

    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...
  22. Replies
    13
    Views
    602

    Re: calculate percentage

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

    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)...
  24. Replies
    13
    Views
    602

    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,...
  25. Replies
    10
    Views
    304

    Re: SQL statement problem

    Then you're having a typo in your fieldname
  26. Replies
    10
    Views
    304

    Re: SQL statement problem

    ?
    "AND TBL.NAME2<>'" & Chr(32) & "'"
  27. 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...
  28. Replies
    39
    Views
    950

    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...
  29. Replies
    3
    Views
    186

    Re: shellexecute and ffmpeg

    Usually, ShellExecute is for shelling a file to its Standard-Programm
    e.g. "ShellExecute MyForm.hWnd, "open", "MyDocument.docx",,,SW_SHOWNORMAL

    If you want to Execute your commandline-string,...
  30. Replies
    39
    Views
    950

    Re: Binary Search Not Finding Capitals

    The difference is 32 (I nearly wrote 42....)


    Dim s As String
    s = "A"
    Debug.Print Chr(Asc(s) Xor 32) '--> Returns "a"
    Debug.Print Chr(Asc(s) Or 32) '--> Returns "a"
    s =...
  31. Replies
    39
    Views
    950

    Re: Binary Search Not Finding Capitals

    How big is that Array?
    IMO a BinarySearch only makes sense if we're talking a few thousand entries.
    An alternative might be the Filter-Function for String-Arrays.
    The Filter-Function works like...
  32. Replies
    26
    Views
    889

    Re: Strange behaviour of vb6

    You gotta be kidding me........
    So, basically the OP put the first textbox in his Form, set its Index to 1, and copied the Textbox 11 times, missing that the first copy had Index 0 and the last copy...
  33. Replies
    26
    Views
    889

    Re: Strange behaviour of vb6

    Just out of curiosity (because i don't remember it anymore since i haven't fired up my vb6 in 10 years):
    If you place a control on a form, then you go to its Index-Property to declare it as an...
  34. Replies
    3
    Views
    349

    Re: Treeview control in Access form

    Sounds like a borked installation.

    Have you tried "regsrv32 mscomctl.ocx" (In System32 resp. SysWoW64)?
  35. Replies
    17
    Views
    677

    Re: Program to rename / copy mp3 files

    Open Form2 in Modal mode
  36. Replies
    26
    Views
    889

    Re: Strange behaviour of vb6

    Do a "Debug.Print LBound(Text1)" and "Debug.Print UBound(Text1)" if you don't believe us......
  37. Replies
    26
    Views
    889

    Re: Strange behaviour of vb6

    And if you're unsure about the Array-Bounderies, there is always
    For i=LBound(Text1) To UBound(Text1)
  38. Replies
    18
    Views
    823

    Re: Type MisMatch

    Array is declared as String
    "Is Nothing" checks if it's an Object
  39. Replies
    17
    Views
    677

    Re: Program to rename / copy mp3 files

    There is no "rename all files at once"
    either, you collect all filenames, rename them in memory, and then loop through the result firing off the "name" function
    or you run through your files and...
  40. Replies
    17
    Views
    677

    Re: Program to rename / copy mp3 files

    Use split-function on full path with \ as delimiter.
    filename is in highest member of the resultarray
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width