Search:

Type: Posts; User: techgnome

Page 1 of 13 1 2 3 4

Search: Search took 0.22 seconds.

  1. Re: IS there a way to change values while full select - insert into temp table?

    What's with the select * ????

    there's also this:


    select *,
    Case when C.transC_strType ='11' THEN '1' ELSE C.transC_strType END as newValue
    into #temp_table_update
    from someTable;
  2. Re: IS there a way to change values while full select - insert into temp table?

    Why select all the fields anyways? If all you're updateing is one field, at most all you need from the oritginal table is the field in question and hte ID.

    Here's how I'd probably do it:


    --...
  3. Re: IS there a way to change values while full select - insert into temp table?

    If this is SQL Server, you can also right-click on the table in SSMS Select SCRIPT AS then Select ... And you get a complete select with all the cols in it. You can also select Insert and you'll get...
  4. Replies
    2
    Views
    114

    Re: Directory Fails Renaming

    Add "_old" to the end of it first, then rename it again with the proper casing.

    -tg
  5. Replies
    1,070
    Views
    44,857

    Re: Current Russia Ukraine tensions

    It's really no different from the electricity your TV uses when it's "off" ... there's still circuity that's running. I uses less than it would if it's one, but it's probably negligible. Same with...
  6. Replies
    5
    Views
    178

    Re: Getting a list of random numbers.

    Why is there even a loop in the first place?


    For i = 0 To 1
    Dim rng As New Random
    Select Case i
    Case = 0
    place =...
  7. Replies
    1,070
    Views
    44,857

    Re: Current Russia Ukraine tensions

    More than 5 miles, right? They say that most accidents happen within 5 miles of your house... good thing I don't live near you ... sounds like your house is some kind of accident magnet.

    -tg
  8. Replies
    1,070
    Views
    44,857

    Re: Current Russia Ukraine tensions

    What do y'all do with your old wind turbine blades? That's something that's a problem now on this side, as many of the turbines that were put up 20+ years ago in the late 90's and early 2000's reach...
  9. Replies
    1
    Views
    151

    Re: Post Notifications

    1) This should have been in the Forum Feedback section, not the test area where almost no one will see it, let alone pay attention to it.
    2) It's a known issue with the forum's software ......
  10. Re: Moving complete rows between DataGridViews

    That's ... because you're not using the raw vbTab to split... you're splitting on "vbTab" the string...
    Try removing the quotes:
    split(transsdd, vbTab)


    -tg
  11. Re: No longer being notified when someone responds

    "Alright, who let the intern push right to production?"

    -tg
  12. Replies
    7
    Views
    296

    Re: How do I quickly find a form?

    It's an older form of naming that most of us don't do any more. Probably some kind of carry over from Hungarian Notation that was in fashion at the time. I don't think anyone recommends it any more,...
  13. Re: VB.NET Web Forms - Using the application object to store a custom class

    Personally I wouldn't do that. I can't remember if the Application object is thread safe, something tells me that it isn't. I could be wrong about that. Even if it is, I don't think you really gain...
  14. Replies
    18
    Views
    558

    Re: data arrival help select case

    Look up split


    -tg
  15. Replies
    9
    Views
    197

    Re: Help with SQL JOIN and DataGridView

    Try debug.print(sql) just before you execute it. then put it into the query tool and see if it'll run ... and if not, it might have a better clue as to what's going on that the code around it is...
  16. Replies
    1,070
    Views
    44,857

    Re: Current Russia Ukraine tensions

    Fox News & MSNBC: hold our beers...

    -tg
  17. Re: Best method to store application settings in VB .net

    The config file is a plain text file in XML format ... easily editable with notepad or something.

    -tg
  18. Re: Best method to store application settings in VB .net

    Also look up Custom Configurations in .NET ... there's a way to store config files that are separate and independent of application or user config files. I remeember doing it once... but it was a...
  19. Re: Best method to store application settings in VB .net

    Application settings in .NET have two scopes: Application and User.
    Settings that are Application in scope will apply to all users of the application. They are tied to that application, not any...
  20. Replies
    15
    Views
    378

    Re: adtg ado database

    the original post mentioned Visual Studio Code - VSCode ... so I thought he had found something that said it could be done but was resisting to do so. Sounds like it was a case of miscommunication. ...
  21. Replies
    15
    Views
    378

    Re: adtg ado database

    VSCode is free... don't confuse it with Visual Studio... they are not the same thing. Download and install VSCode, find and install an appropriate extension, and you should be good to go from there....
  22. VS 2019 Re: TabControl add controls from text file

    Change this:


    If LineParts.Count < 2 Then
    Continue For 'No = in the line, so skip it
    Else
    Dim Key As String = LineParts(0)


    To this:
  23. Replies
    15
    Views
    550

    Re: Partial function in VB6?

    That looks like generics to me... not partial... which is a completely different thing. Also I don't think you can have partial functions/methods - in any language - partial classes, sure. Methods,...
  24. Replies
    1,070
    Views
    44,857

    Re: Current Russia Ukraine tensions

    I think someone has been hitting the ouzo a bit tonight... tbf with all this talk, I wouldn't blame him.

    -tg
  25. Replies
    3,307
    Views
    391,135

    Re: What song are you listening to right now?

    https://www.youtube.com/watch?v=7xxgRUyzgs0
  26. Re: Why there is Parentheses at the end of the List in C#

    No...
    Think of it like this:
    List<int> numberList. says "I need a box that can hold ints" ... it's a signal of something that you need. But it doesn't create it yet.
    new List<int>(); says "Ok,...
  27. Replies
    6
    Views
    358

    Re: vb.net Issue with dbnull

    The problem is that you're checking the cell... which is an object and seeing if it is null or not. What you should be checking is if the VALUE is null.



    -tg
  28. Re: problem reading registers open for random

    Please post the relevant code - in this case, the read, write, and the strucure - don't post the entire project unless requested.
    When posting code use the
    or tags around it.

    -tg
  29. Replies
    4
    Views
    327

    VS 2017 Re: Problem porting JS function to VB.NET

    That's. different question that deserves its own thread... but ... if I had to guess, there's a difference between encoding for the URL, and escaping it ... I'd run it through the encode and the...
  30. Replies
    1,070
    Views
    44,857

    Re: Current Russia Ukraine tensions

    It wouldn't surprise me if he has a scorched earth mentality: If I can't have it, then no one can...


    -tg
  31. Replies
    5
    Views
    309

    VS 2019 Re: Issue with SSLStream Responses

    Yeah, that's what I thought. You're just reading what's there, but it may not be the whole message. You're getting the size (let's say 32) and then reading that 32 bytes... but the entire message...
  32. Replies
    2
    Views
    253

    Re: open new outlook message with a table

    Bottom line - Outlook supports multiple message formats ... plain text, RTF, HTML ... and a message can contain all three (depending on the client, the message will be rendered in this order: HTML ->...
  33. Replies
    2
    Views
    253

    Re: open new outlook message with a table

    Should be ... by setting the RTFMessage (at least that's what it used to be called) ... altho now I think it supports html but I'm not sure how to set that. But, yeah, I believe there are ways to...
  34. Replies
    509
    Views
    89,550

    Re: Hamilton 5x World Champion ?

    I wish I knew ... the last two years they kept saying "just wait, we're pouring our development into the new cars for 22, be patient" ... annnnnnd... here we are ... not much has changed.

    -tg
  35. Replies
    5
    Views
    309

    VS 2019 Re: Issue with SSLStream Responses

    What does the code for getResponse look like?
    Seems to me that you're not getting the complete response from your first request before moving on to the next step.

    -tg
  36. Replies
    15
    Views
    374

    Re: Int Function and Rounding

    So a result of 1.9996 would be 1? and 1.9998 would be 2?
    Seems quite the arbitrary rounding point.

    -tg
  37. Replies
    509
    Views
    89,550

    Re: Hamilton 5x World Champion ?

    That's why lately I've taken to just recording the race, watch it later, and skip 75% of the race... unless I see a yellow come out... then I'll back it up and start watching it to see what's going...
  38. Replies
    5
    Views
    240

    Re: Resource File

    Might want to change search engines ... Brave returned several (Al though I'd probably ignore the first one).

    https://search.brave.com/search?q=how+to+create+resource+file+in+vb6&source=desktop
    ...
  39. Re: windows 10 vpn connection yes / no how to auto accept it

    If it isn't hardware, it's software, whether it's script or a compiled language... doesn't matter.
    And no, they don't need an image resizer, people need to be aware of the things they are uploading...
  40. Re: windows 10 vpn connection yes / no how to auto accept it

    It's the ONE time the forum software doesn't shrink down an image.
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width