Search:

Type: Posts; User: Zvoni

Page 1 of 13 1 2 3 4

Search: Search took 0.16 seconds.

  1. Replies
    4
    Views
    68

    Re: 2 Dimensional Array

    seriously????
  2. Re: [RESOLVED] help with mssql query to return top five selling products by date

    Your Problem is that you're not aggregating the fields and you're using unique-per-row fields in your Output (e.g. InvoiceNo)
  3. Replies
    2
    Views
    53

    Re: Dynamic Array Size

    Only without preserving content.
    If you want to keep the content of the array (Keyword Preserve) only last dimension is dynamic
  4. Replies
    4
    Views
    68

    Re: 2 Dimensional Array

    https://visualbasic.happycodings.com/applications-vba/code30.html
  5. Replies
    8
    Views
    227

    Re: max size of binary files to split

    Why not use an ADO-Stream-Object (Put DAO where it belongs: The garbage-heap)?
    And use LONGBINARY instead of Memo --> http://allenbrowne.com/ser-49.html
  6. Re: Marking an excel file with a key from system

    Why not use the Keyword-Property of the Workbook?
    Go to File-Explorer, choose a xlsx-file, right-click on it, go to Properties, go to Details
    There you'll find different Properties (Author, Title,...
  7. Re: [Word] suggestings for optimizing my macro that uses Application.CompareDocuments

    Have you thought about using a Diff-Tool?
    https://www.git-tower.com/blog/diff-tools-windows/
  8. Re: Calling function of Exe project in referenced aticvex project in vb6

    One approach not mentioned up until now is DDE

    And that one definitely works with an ActiveX-exe
  9. Replies
    28
    Views
    1,023

    Re: [RESOLVED] Need help from Olaf

    Olaf,
    yeah found that out researching this.
    just looked weird to me.
    but there shouldn’t be any difference including the field you group by in the select
  10. Replies
    28
    Views
    1,023

    Re: [RESOLVED] Need help from Olaf

    Yes, i missed a closing paranthesis

    Remove the "MyDate" from the Inner Subselect and add a GROUP BY-Clause.
    See Olaf's Answer
  11. Re: Calling function of Exe project in referenced aticvex project in vb6

    With the caveat, that you have to use an object-module to declare your subscriber "WithEvents" (maybe instead of a bas-module one of those "global" autoinstantiated classes which in a way behave like...
  12. Replies
    28
    Views
    1,023

    Re: [RESOLVED] Need help from Olaf

    *facepalm*

    I'm embarrassed :D

    BTW: How can you GROUP BY by a Non-Output-Column?

    OOPS, Olaf left out two Columns in the inner SQL: PID and MyDate
    And leaving MyDate out of it when there is...
  13. Replies
    28
    Views
    1,023

    Re: [RESOLVED] Need help from Olaf

    wqweto,

    all true. I wrote that he appears to be wanting to use parameters, though in a way which basically results in concatenation.
    In that case he can leave out the Replace-Juggling and concat...
  14. Replies
    28
    Views
    1,023

    Re: [RESOLVED] Need help from Olaf

    Just noticed that i stepped into the single-quote trap


    'Somewhere in a Bas-Module
    Public Function SQ(ByVal AString As String, Optional ByVal RemoveEmbedded As Boolean = True) As String
    If...
  15. Replies
    28
    Views
    1,023

    Re: [RESOLVED] Need help from Olaf

    OK, must have missed that it's SQLite.
    Yeah, in that case it's basically your only option to compare string-wise
  16. Replies
    28
    Views
    1,023

    Re: [RESOLVED] Need help from Olaf

    because your SQL-String is faulty

    You start the String with 2 Replace-Function-Calls, meaning the last 2 characters of that line have to be 2 closing paranthesis'
    But the last thing in that line...
  17. Replies
    33
    Views
    1,037

    Re: copying from List Box to Text box

    Copy To Clipboard: https://www.vbforums.com/showthread.php?738057-copy-the-content-of-the-textbox-to-the-clipboard
  18. Thread: TwinBasic

    by Zvoni
    Replies
    861
    Views
    280,201

    Re: TwinBasic

    FPC = Free Pascal Compiler
  19. Replies
    40
    Views
    1,413

    Re: MsgBox font properties

    FWIW, a "Static"-Control (probably in C++) is what we usually call a "Label"-Control in vb6
  20. Re: Calling function of Exe project in referenced aticvex project in vb6

    *Sigh*
    and if you look at the StackOverflow-Link i posted in #4 you would have seen, that it's the same User-Name, the same text as in opening Post,
    AND THAT HE RECEIVED ANSWERS 6 Days ago

    So...
  21. Re: Calling function of Exe project in referenced aticvex project in vb6

    Niya,
    take a look at the StackOverflow-Link in Post #4 ....
    .... illuminating... *g*
  22. Re: Calling function of Exe project in referenced aticvex project in vb6

    Ah, i see where i got confused
    You actually want to call a function in the EXE "B" from your DLL "A"
    Easiest way: in your DLL "A" raise an Event which you catch in your EXE "B"
    Aircode


    'In...
  23. Thread: TwinBasic

    by Zvoni
    Replies
    861
    Views
    280,201

    Re: TwinBasic

    I know i'm contradicting myself (since i said i'm out of this discussion), but PD responded directly to my post, and i respect PD for his skills and opinion.

    PD, everything true you said, but in...
  24. Re: Calling function of Exe project in referenced aticvex project in vb6

    IIRC, you can only call Class-Methods from "outside", but i might be wrong. been a long time for me
    You can define a Class as "Global" (or some such thing), and from outside it would look like a...
  25. Thread: TwinBasic

    by Zvoni
    Replies
    861
    Views
    280,201

    Re: TwinBasic

    Ah, Ed.
    has nothing to do with you.
    I respect opinions of others (even if i don't agree with them), and i'm definitely not offended, if someone disagrees with me, as long as he/she can provide...
  26. Replies
    16
    Views
    571

    Re: Extract Text from PDF

    Olaf,
    still testing, though i'll probably switch to pdftotext (instead of pdftoHTML), since i want to grab plain text.
    I'm just running tests with it (incl. the different output-layouts), firing it...
  27. Thread: TwinBasic

    by Zvoni
    Replies
    861
    Views
    280,201

    Re: TwinBasic

    Your point?
    If someone with such "own" syntax asks for support, he can get it in the "official basic" way.

    Would be the same as: "Why is my Function not working?" showing only the call to it, but...
  28. Replies
    16
    Views
    571

    Re: Extract Text from PDF

    Reporting back.
    Not exactly what i'm looking for. Yes, i can get stuff like MetaData, but not the actual content.
    At least it's a starting point.

    Thx anyway
  29. Thread: TwinBasic

    by Zvoni
    Replies
    861
    Views
    280,201

    Re: TwinBasic

    Baka, no need for an IDE setting or whatever.
    Since Wayne has already implemented those C-ish operators it's a fait accompli.
    No use to cry over spilt milk.

    TwinBasic offers NEW (intrinsic)...
  30. Thread: TwinBasic

    by Zvoni
    Replies
    861
    Views
    280,201

    Re: TwinBasic

    The Problem people have with "a = a + 1" in Basic, is that Basic has overloaded the "="-operator:
    Assignment AND equality/comparison
    Look at other languages
    a) Pascal: "=" equal - ":=" assign
    b)...
  31. Replies
    40
    Views
    1,413

    Re: MsgBox font properties

    Maybe here? https://www.vbforums.com/showthread.php?215392-MSGBOX-SETTING-FONT-SIZE-and-STYLE
  32. Thread: TwinBasic

    by Zvoni
    Replies
    861
    Views
    280,201

    Re: TwinBasic

    I get the impression i was not precise enough:
    i‘m not opposed to NEW operators (like ShiftLeft and sisters)
    I‘m opposed to operators that are just syntactic sugar, when there already is a...
  33. Thread: TwinBasic

    by Zvoni
    Replies
    861
    Views
    280,201

    Re: TwinBasic

    Exactly.
    I know it from the FPC/Lazarus-Forums.
    On average, every 3 months comes a (pretty much) new forum-user, asking to add the "feature" of curly braces to declare a code-block (instead of...
  34. Thread: TwinBasic

    by Zvoni
    Replies
    861
    Views
    280,201

    Re: TwinBasic

    Agreed. That one always confused the hell out of me



    a = 1
    b = a++ 'b is now 1, while a is 2
    b = ++a 'b and a are now 3
  35. Replies
    43
    Views
    1,012

    Re: (vb6)-Display most Common number from textbox

    Well, Arnout was the first one succumbing to the "temptation" :D
    From there it was a free for all :bigyello:
  36. Thread: TwinBasic

    by Zvoni
    Replies
    861
    Views
    280,201

    Re: TwinBasic

    That's a non-argument if i ever saw one.

    I know people who cannot read a single piece of sheet music (you know those weird glyphs on those 5 lines depicting "music"?), but they create music to die...
  37. Thread: TwinBasic

    by Zvoni
    Replies
    861
    Views
    280,201

    Re: TwinBasic

    Ed,

    it's the reason why i mentioned writing your own operators.

    with own operators available, people can write C in Basic to their hearts content.

    But to be honest, in a chinese restaurant i...
  38. Replies
    43
    Views
    1,012

    Re: (vb6)-Display most Common number from textbox

    wqweto,

    clobbered together in 10 minutes :bigyello:
    and i'm not that familiar with the Scripting Runtime and its objects, in this case the Dictionary

    But you're right: That would be the next...
  39. Replies
    16
    Views
    571

    Re: Extract Text from PDF

    Thx Ed.
    Will take a look and report back
  40. Replies
    16
    Views
    571

    Re: Extract Text from PDF

    baka,
    i've found the documentation for the PDF-Format, but i think i will learn speaking Mandarin fluently before i understand the PDF-Format.
    Holy Smoke, but PDF is IMO a convoluted mess.
    i...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width