Search:

Type: Posts; User: techgnome

Page 1 of 13 1 2 3 4

Search: Search took 5.19 seconds.

  1. Replies
    3
    Views
    91

    Re: query help (JOIN?)

    At first I thought maybe a FULL OUTER JOIN is what you'd need... but then I realized you wouldn't have a job w/o an employee... that doesn't make sense. So, yeah, a RIGHT JOIN might work. I'd...
  2. Re: Microsoft makes its VS Code tool available directly in the browser

    Yeah, I'm trying to wrap my head around who the target audience for this would be. It's VSCode... not Visual Studio. VS Code already runs pretty much every where it needs to - Windows, Mac, & Linux....
  3. Replies
    5
    Views
    159

    Re: Create database programmatically

    Because this is why...







    You put one form into another...
  4. Replies
    10
    Views
    177

    Re: This just doesn't sound reasonable

    I had a friend pass away this past summer from heat stroke while on a hike... took her life in a matter of hours... and that was with medical attention. I've suffered from heat exhaustion once as a...
  5. VS 2017 Re: Retaining Application and/or User Settings with ClickOnce Upgrades

    The settings that are common and are not going to change should be application settings. Those are read-only by design. Anything else should be a user setting.
    That said, this is how config...
  6. Replies
    5
    Views
    260

    Re: Dictionary, more than one item

    Would Tuples work?

    -tg
  7. Replies
    8
    Views
    322

    Re: [SQL Server 2016] Looping Over Records

    Because it isn't always straightforward like that... sometimes it's pulling values out of one table and using them to call another stored proc as parameters... Or there's some other processing that...
  8. Replies
    8
    Views
    322

    Re: [SQL Server 2016] Looping Over Records

    Yes, there is a difference between the two. Aaaaannnnnd the way you're doing is far more preferable to using a cursor. Cursors are slow as there's a lot they need to keep track of, and it can cause...
  9. Re: Why is VB.Net/C#/XAML + VS2019 is better than VB6? Here's why.....

    Then don't.... use someone else's library ... that's what you're doing in .NET... you shifted the burden of proof (so to speak) from yourself - where if you were dealing with this, you'd take that,...
  10. Re: Connecting VB6 textbox to DAO data Control to SQL Server

    If that's the route you want to take, then why not use Link Tables in Access? Link your tables to SQL Server. If you name everything the same, then your front end should just use the new linked...
  11. Re: Why is VB.Net/C#/XAML + VS2019 is better than VB6? Here's why.....

    No language has that functionality built-in ... not even VB.NET or C# ... it's built in to the libraries for you, that's the difference. So creating a VB6 library that does the checking really isn't...
  12. Re: Syntax error in UPDATE statement

    You CAN.. but you have to add the parameter TWICE... in the RIGHT location... as it currently is, you're only added it once.

    -tg
  13. Re: Syntax error in UPDATE statement

    Long shot, but put "Password" in brackets in your query: "[Passwrod]=..."

    Password is generally a reserved word and has special meaning in databases. For what ever reasons databases will still let...
  14. Re: Why is VB.Net/C#/XAML + VS2019 is better than VB6? Here's why.....

    I'm so close to the metal, I can feel it. So cold, soft, smooth.... like a shark.

    -tg
  15. Re: [RESOLVED] trying to replace function something not working

    So... try an UPDATE statement then... SET the Address to the replaced values...

    It's not that hard.
    UPDATE someTable
    SET someField = someValue
    Where SomeCondition

    If you want to update all...
  16. Re: trying to replace function something not working

    Are you trying to SELECT from the table and display it ... or UPDATE the data in the table (so that later selects will have the correct data)?


    -tg
  17. Re: [RESOLVED] Corona virus, China major city lockdowns, etc.

    Operation Warp Speed was probably the only thing done right... But one thing right doesn't erase all the other things done wrong. It's classic abusive relationship behavior. "Oh baby I'm sorry for...
  18. Re: [RESOLVED] Corona virus, China major city lockdowns, etc.

    That is BS... He could have done better. He should have done better. But he's too narcissistic and his ego is too big to allow him to do anything like that. He doesn't like not being in control and...
  19. Re: [RESOLVED] Corona virus, China major city lockdowns, etc.

    Oh no... the fire analogy does fit... It's called arson...

    -tg
  20. Re: Posting a VB.NET code as part of supporting info for journal publishing

    I wouldn't put the files on GitHub as rar or zip files, but as their natural original text files they were intended to be. Then people can browse the code much more easily that way. Also if you have...
  21. Re: Posting a VB.NET code as part of supporting info for journal publishing

    Publish the code on GitHub?

    -tg
  22. Replies
    3,181
    Views
    218,004

    Re: What song are you listening to right now?

    Roundtable Rival - Lindsey Sterling

    https://www.youtube.com/watch?v=jvipPYFebWc

    tbh - I could listen to Lindsey Sterling all day... hrmmm... maybe I will...

    -tg
  23. Re: How to access a file after click once deploys it

    Did you add it as a file or as a resource? If you added it as a resource, that's why you don't see the build options in the properties window. If you add it as a file, not a resource, then you should...
  24. Re: Why is VB.Net/C#/XAML + VS2019 is better than VB6? Here's why.....

    I take it you've never met a COBOL programmer have you?

    -tg
  25. Re: Identical Split() call works fine in one program but not in another

    Split requires AT LEAST two parameters... the string to split, and what to split on.... you gave it the first, and nothing else. That's what the error message is telling you.... it's looking at all...
  26. Re: [RESOLVED] Corona virus, China major city lockdowns, etc.

    Ok, so this article floated across my desk - https://www.cnbc.com/2021/10/01/ceos-are-at-their-wits-ends-dont-know-how-to-get-employees-back-in.html
    It's about CEO's trying to get people back into...
  27. Replies
    16
    Views
    466

    Re: Why does this not work ?

    Try


    If txt Is Not Nothing AndAlso txt.Contains("Omit") Then ...

    The AndAlso will short circuit if the first condition fails. This has been an issue with VB for some time, the If statement...
  28. Replies
    8
    Views
    358

    Re: translation from c#

    Sounds like there maybe a namespace conflict going on here too... If Intellisense suggested adding the imports, it must be aware of something with that namespace, or similar. Otherwise how would it...
  29. Replies
    10
    Views
    327

    Re: Debtor System Design

    Completely agree... I'd go so far as to suggest a table (or set of tables) for Invoice ... and another set for the AR (Accounts Receivable) side of things. All aging and debits/credits are tracked in...
  30. Re: [RESOLVED] Corona virus, China major city lockdowns, etc.

    Except they also keep moving the goal posts...
    "The vaccines aren't approved, they're ExPeRiMeNtAl!"
    "Ok, the vaccines are now fully approved... even for kids as young as 12."
    "But we don't know...
  31. Re: Choosing a Server-less Database for a Desktop Application

    I would go with either the Access option with ACE (rather than Jet), or SQLite.

    -tg
  32. Re: [RESOLVED] Corona virus, China major city lockdowns, etc.

    weird... because it doesn't even link back to the post I did quoote (or was trying to) ... but rather to a post I previously quoted and replied to... and yet... can't say that it's the strangest...
  33. Re: Gitpod releases browser-based Visual Studio code

    If it was Visual Studio, maybe I'd care, because that would be cool. But it's VSCode... which already runs on Win, Mac, & Linux.... so I'm not sure what the gains here are. Maybe there's some aspect...
  34. Re: Gitpod releases browser-based Visual Studio code

    yeah... I'm having trouble with that... what does that give me that I don't already have?

    -tg
  35. Re: [RESOLVED] Corona virus, China major city lockdowns, etc.

    It's political whether they realize it or not. The problem is that there has been this ... I don't know what to call it... movement? ground swelling? not sure ... that started back in JAn/Feb of 2020...
  36. Replies
    10
    Views
    327

    Re: Debtor System Design

    Even if there isn't much dataflow... I'd still go with this option. Not only will it scale better, but you avoid some of the issues with triggers (which tend to be somewhat hidden and very...
  37. Re: [RESOLVED] Corona virus, China major city lockdowns, etc.

    It varies from state to state.... here in South Carolina, we only JUST passed the 50% fully vaccinated in the past week. But for a long time, we hovered around the 40% mark (in fact I think it was...
  38. Re: [RESOLVED] Corona virus, China major city lockdowns, etc.

    Well then, they should just stay at home and let the rest of us get on and live our lives.

    -tg
  39. Replies
    3,181
    Views
    218,004

    Re: What song are you listening to right now?

    2Pac ft. Dr. Dre - California Love

    https://www.youtube.com/watch?v=omfz62qu_Bc

    -tg
  40. Replies
    3,181
    Views
    218,004

    Re: What song are you listening to right now?

    Evanescence - My Immortal

    https://www.youtube.com/watch?v=5anLPw0Efmo

    Guns N' Roses - November Rain

    https://www.youtube.com/watch?v=8SbUC-UaAxE

    Red Hot Chili Peppers - Californication
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width