Search:

Type: Posts; User: techgnome

Page 1 of 13 1 2 3 4

Search: Search took 0.15 seconds.

  1. Replies
    42
    Views
    575

    Re: Stop whining - just get numb

    Of course we are... 'cause 'Merica!

    -tg
  2. Replies
    20
    Views
    388

    Re: Add --SELECT--

    Currently using the "-- Select --" not as a prompt, but because there are 3 choices in the dropdown, but 4 possible values - the three that are there and "NULL" ... by setting it to the select...
  3. Replies
    42
    Views
    575

    Re: Stop whining - just get numb

    and for the most part, they are. I bought a collector's item a while back, I still had to go through a FFL and fill out forms to pick it up.
    Problem 1 - there's still the illegal gun sales that...
  4. VS 2019 Re: Prevent "Conversion from type DBNull to type String" error

    Exactly ... I used to have the same issue ... then I came across an article breaking down the advantages of NULL ... and how it means "Unknown" ... I wish I still had a copy of it.

    -tg
  5. Replies
    42
    Views
    575

    Re: Stop whining - just get numb

    I keep hearing that, but I've yet to see anyone define what "stricter laws" that are needed. The problem is that by "stricter" people mean "close loopholes" which leads to the crap restrictions that...
  6. Re: [RESOLVED] Unhandled error inside code called by by an error handled procedure ?

    I do not ... but the statement still stands that invoking the click event programatically (as the .Value = True does ... which I forgot about) breaks the error handling chain ... rightfully so ......
  7. VS 2019 Re: Prevent "Conversion from type DBNull to type String" error

    Yeah, when you don't have control over the db then it sucks. I'm using Hibernate and JPAs for dataaccess so I don't have control over the generated SQL. If there is no difference between a null and...
  8. VS 2019 Re: Prevent "Conversion from type DBNull to type String" error

    If you're going to do that, then just make the field non-nullable and default to an empty string.

    Otherwise it's null for a reason, and nulls can be different from an empty string.

    But I agree...
  9. Replies
    11
    Views
    259

    Re: Public Variables in a Class Module

    Honestly I don't think there's much, other than having get/let/set would make refactoring a bit easier later (somehting needs to change to read-only, for instance; or if you need to do somehting when...
  10. Replies
    42
    Views
    575

    Re: Stop whining - just get numb

    Here in SC they recently enacted open permit cary ... Which means you can now legally open cary as long as you have a conceal cary permit. They stopped just short of constitutional cary (which means...
  11. Re: [RESOLVED] Unhandled error inside code called by by an error handled procedure ?

    IT works this way because Command2_Click is being called as a method ... not as a result of an event. If there was a way to programmatically click the button (in .net it would be...
  12. Replies
    124
    Views
    4,153

    Re: Drafts Very important stuff going on

    no, no, no ... that's how you know it's the original ... see once you rotate it, it becomes a derivative work... and could be yet another NFT, but since it's derived from the original, not worth as...
  13. Re: Unhandled error inside code called by by an error handled procedure ?

    It still isn't quite the strangest thing I've seen. Another time, another product, code wouldn't work until someone added:


    Dim x as Integer
    x = 1


    After those two instances, not much...
  14. Replies
    4
    Views
    172

    Re: Ignoring blank cells

    Cleanup on aisle 12!
    Can you please re-post that code but with
    tags around it? That's preserve the indenting of the code making it easier to read. It'll look like a river of code than a cliff of...
  15. Replies
    14
    Views
    364

    Re: microsoft, do you have brain

    More likely it was this: "data form" and "ms access database" ...

    That said, if I remember right "3426" is a generic SQL Error ... there's a way to get to the extended exception to get details on...
  16. Re: Unhandled error inside code called by by an error handled procedure ?

    That's why I said "sometimes" ... I've gotten into situations where it drastically changed how something worked (or not) and so have stoped relying on them as a litmus test and use debug prints now. ...
  17. Re: Unhandled error inside code called by by an error handled procedure ?

    MessageBoxes can and will alter the flow sometimes. Better to use Debug Print statements to get a true idea of how things are flowing.


    -tg
  18. Re: Unhandled error inside code called by by an error handled procedure ?

    Only when I had Break on All Errors turned on... or when I thought something was handled, and it wasn't.

    -tg
  19. Replies
    6
    Views
    261

    Re: Anyone knows how to automate defi?

    Really? Still surprised? After all this time? :/

    -tg
  20. Replies
    6
    Views
    261

    Re: Anyone knows how to automate defi?

    Of course it's not an odd request... nor is it too much ... I just happen to know about defi with out looking it up ... and in the interest of just moving things along I replied ...
    Now I know...
  21. Replies
    6
    Views
    261

    Re: Anyone knows how to automate defi?

    defi - decentralized financing ... a crypto-based decentralized financing scheme
    PancakeSwap - presumably a Crypto of some sort.

    As for an API ... how you looked at the DeFi documentation?

    -tg
  22. Replies
    11
    Views
    340

    Re: newer VS versions and subscriptions

    Guess we'll see ... I didn't have to login for anytihng to get the CE ... but for 2019 I had to log into my MS Account just to download it.

    BUt we'll see I guess, I've only had it installed for a...
  23. Replies
    11
    Views
    340

    Re: newer VS versions and subscriptions

    Having recently installed the latest two versions... 19 & 22 .... I've only had to login to download VS2019 ... That's it. That's just for the download. Once installed, there was no logging in.

    ...
  24. Re: Installation problem again - unexpected error quitting

    If it never prompts you for the key, then it's a cracked copy ... whether you use it or not is up to you. We're not in the position to tell you if it's safe or not.

    And my wife wonders why I have...
  25. Thread: TwinBasic

    by techgnome
    Replies
    992
    Views
    379,103

    Re: TwinBasic

    We use Ci/CD here, but only to our development branch/environs ... releasing to test and users is still on a daily/weekly schedule....

    -tg
  26. Thread: TwinBasic

    by techgnome
    Replies
    992
    Views
    379,103

    Re: TwinBasic

    Two updates in 5 hours ... you're a beast Wayne ...

    Have you thought about going to a single release per day? I can't keep up...

    -tg
  27. Replies
    9
    Views
    261

    Re: NullException on delete in WPF textbox

    Indeed... I never said anything about the code... I said to look at the "table structure" ... in the database ... it sounds like there are constraints on the fields to prevent them from being...
  28. Replies
    9
    Views
    261

    Re: NullException on delete in WPF textbox

    Look at the table structure. Can your fields even hold a NULL value - Are the Nullable? Or are they marked "Not-Null"? That maybe the source of the problem. You're potentially trying to stuff a NULL...
  29. Re: Customer Name which can contain a string and integer

    Wasn't part of the sample data there... but what about "ABC12345" or "ADBC12345a"? IT could be argued that there are 4 numbers in a row there ... Just something to keep in mind.

    -=tg
  30. Replies
    4
    Views
    251

    Re: String Split Remove SOME Empty Entries

    How often will you have a CR or LF that's not a CRLF?

    -tg
  31. Replies
    4
    Views
    251

    Re: String Split Remove SOME Empty Entries

    So, if I'm reading right... sometimes you want to remove the empty lines ... other times not ... Would an optional flag PreserveEmpty work? Default to false. False would include the...
  32. Replies
    4
    Views
    235

    Re: Retrieving values from an array

    You've returned the value into a string...


    Dim TransSDD As String
    ...
    TransSDD = Datarowview("Store")


    DateProcessed isn't an index, presumably it is a variable (it's what you used to...
  33. Replies
    11
    Views
    445

    Re: Weird error

    I bet it's the DoEvents that's actually tripping things up.
    Putting in loops & sleeps and doevents isn't solving the problem, nor is it going to help find the problem. All it's doing is altering...
  34. Replies
    10
    Views
    439

    Re: Working with MSXML Post

    See if this is any help - it's Excel, but the syntax should still be the same. There's a POST example a little way down.
    https://codingislove.com/http-requests-excel-vba/

    -tg
  35. Replies
    10
    Views
    439

    Re: Working with MSXML Post

    Try using MSXML2 and the XMLTTP object...



    ' Set myMSXML = New MSXML.XMLHTTPRequest

    set myMSXML As New MSXML2.XMLHTTP
  36. Replies
    10
    Views
    439

    Re: Working with MSXML Post

    I'll admit it's been sometime since I've done VB6 ... but shouldn't this:


    Set myMSXML = New MSXML.XMLHTTPRequest

    be this:


    Set myMSXML = New MSXML.XMLHTTPRequest()
  37. Thread: TwinBasic

    by techgnome
    Replies
    992
    Views
    379,103

    Re: TwinBasic

    Yeah, in this case, Wayne takes input from people, but ultimately he gets to decide if something goes in or not, and if so, how. But, it is good to get some input from others based on how they might...
  38. Thread: TwinBasic

    by techgnome
    Replies
    992
    Views
    379,103

    Re: TwinBasic

    Does that include comments? Or only executable lines (which makes sense)?

    -tg
  39. Re: Double click .SQL file open in extant instance in SSMS

    If I recall correctly, there's an option burried deep in the SSMS somewhere ... a checkbox ... it's been too long since I've gone looking for it to remember off hand where it's at. I'll see about...
  40. Replies
    52
    Views
    1,410

    Re: VB.Variant vs C#.Object

    yeah, admitedly I almost never use int or long, but Int/Integer or Long ... And I can't think I've ever gone with a string, it's always String.
    I wouldn't be surprised if it's maybe leftover...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width