Search:

Type: Posts; User: techgnome

Page 1 of 13 1 2 3 4

Search: Search took 10.94 seconds.

  1. Re: Sql Fails when trying to view tablessin 2019 version

    You shouldn't need a license for Management Studio... the license would only be needed if you were running the server portion. You should be able to install just the development tools, which would...
  2. Re: Sql Fails when trying to view tablessin 2019 version

    Yeah, that's really odd.... SMS should be version agnostic.... "should" being the operative word there. Unless something changed significantly in the protocol going into SQL Server 2019.

    -tg
  3. Re: Sql Fails when trying to view tablessin 2019 version

    That's likely the problem... usually you can use a higher version to look at a lower one, but you can't use a lower one to look/attach a higher database.
    Actually, that raises a question as I'm not...
  4. Replies
    5
    Views
    91

    Re: Syntaxe sql - multi table

    That is direct SQL... so as mentioned, it's not possible. You'll need to execute individual statements for each table you want to insert into.

    -tg
  5. Replies
    7
    Views
    139

    Re: ADODB Recordset not populating

    If the one query works in SQL Server w/o the fully qualified name (FQN) ... then why are you using it in the VB code?
    Where did it all come from?


    -tg
  6. Replies
    5
    Views
    91

    Re: Syntaxe sql - multi table

    Yes... you insert data into one table... then the next table, then the next.... one table at a time.
    The INSERT syntax doesn't allow for inserting into multiple tables at once... There are ways...
  7. VS 2019 Re: I have a very simple error that i just don't know how to fix with drop-downs

    you need to .Clear your .Items before you .AddRange.

    Let's say you have a shopping list. You add milk, bread, and eggs to it. You then go to the store and get milk, bread, and eggs. You got...
  8. Replies
    5
    Views
    139

    VS 2019 Re: Select Records Between Two Dates

    This is why:


    iIf you know enough to know that you write the SQL like this:


    Select * From Jobs Where [InDate] Between ('2020-11-1') And ('2020-12-01')
    [code]
    I could see it being...
  9. Replies
    4
    Views
    133

    Re: I need help, please.

    1) You should use a title that actually explains briefly what the problem is. Title threads like "I need help" aren't usefull. Of course you need help, or you wouldn't be here.
    2) The forum does...
  10. Re: VB6 - Problems being Changed from Grid to Picturebox

    Yeah, that doesn't really do what the OP asked for. It does what he needs to do, which is upgrade to flex8, but it doesn't make it magically use vsFelx6 w/o it being installed, which is the root of...
  11. Re: SQL - manipulate group by result into one row

    Aaaaah..... I see what you mean... that's some messed up data. I didn't look at it close enough to notice that 25663 had NFRT, RTF on one row, and RTF, RFT on another... Ick... then, yes a straight...
  12. VS Code Re: What is VS Code for? Can I use it to do VB style coding?

    In short - VS Code has plugins for different languages that enable intellisense, linters that make your code consistent (ie, it can enforce tabs over spaces for indenting, or 4 spaces over 2 spaces...
  13. Replies
    282
    Views
    22,845

    Re: Hamilton 5x World Champion ?

    Not to mention the car itself would become contaminated, and that's something difficult to keep in isolation away from driver and crew.

    -tg
  14. Replies
    1,646
    Views
    78,898

    Re: Corona virus, China major city lockdowns, etc.

    Then there was also the guy that was also forced to roll a boulder uphill, only to have it roll back down as he neared the top... Sounds like he should probably be the patron god for developers.

    ...
  15. Replies
    282
    Views
    22,845

    Re: Hamilton 5x World Champion ?

    Well now.... this might make things interesting at the front of the line this weekend......
  16. VS Code Re: What is VS Code for? Can I use it to do VB style coding?

    Short answers: Yes. No. I do.
    Longer answer:
    It's not a true, full-fledged IDE the way Studio is. It's an editor built on Electron with plugins that allow you to do things in various languages. I...
  17. Replies
    27
    Views
    605

    Re: Using Visual Basic to update excel file

    Personally I go with the more generic term of DataStore or a DataSource, which would include Excel, XML, JSON, Databases, text files, CSV, etc.
    Meanwhile, can we get the thread back on track? It...
  18. Replies
    282
    Views
    22,845

    Re: Hamilton 5x World Champion ?

    Whelp there it is.... One of the seats for next season went to Nikita Mazepin...
    https://www.haasf1team.com/news/nikita-mazepin-race-haas-f1-team

    That takes care of the money $eat... hopefully...
  19. Replies
    2
    Views
    132

    Re: Forum Post AutoSaved Drafts Location

    It is in your cookies/session I believe... and it only "saves" the last one you were on... when you come back to the thread where the hiccup was... there should be a "restore last saved text" or...
  20. Replies
    24
    Views
    754

    Re: posting trouble

    And again just now when replying to this thread.

    -tg
  21. Replies
    24
    Views
    754

    Re: posting trouble

    today - 11:04 EST - Gateway timeout error
    Link: https://www.vbforums.com/newreply.php?do=postreply&t=889539
    Got the 503 error while doing a quick reply at the above thread.
    The post still went...
  22. VS 2017 Re: Interpret Raw RTF Markup Text To RichTextBox?

    The link to the attachment comes out invalid for some reason. If you're doing a screen shot, don't do the whole screen, just capture the part that's relevant. rThe forum does stuff to large images....
  23. Replies
    282
    Views
    22,845

    Re: Hamilton 5x World Champion ?

    Until yesterday, I never knew that the car at the back of the pack at the start was the medical car and that it followed behind for the first lap. I just thought that it was a collector car acting as...
  24. Re: SQL - manipulate group by result into one row

    TRy something like this (shooting from the hip with no database to try it against)


    select CaseId, CASE WHEN DVRFT = 'RFT' and NVRFT = 'RFT' THEN 'RFT' ELSE 'NRFT' END as FinalRFT
    from...
  25. Replies
    282
    Views
    22,845

    Re: Hamilton 5x World Champion ?

    I tuned in just minutes after it happened... I had flash backs to Earnhardt and Wheldon, especially after seeing the charred remains of the tub. It was good to see that he was able to get out on his...
  26. Re: MYSQL data adapter update data table via datagridview from another form

    First welcome to the forums. Secondly, in the future, when posting code, it is highly recommended you use
    or tags around any code that is posted. (if you add a language to the highllight in place...
  27. VS 2019 Re: Open File Explorer showing selected file or Search results?

    Easy... the file is in use at the time you tried to access it... between the time you accessed it, and you go looking for it, the owning process is done with it and cleaned up after itself and...
  28. Replies
    10
    Views
    293

    Re: Google updates in 2020

    You need to add flim flam to you floggle hopper. And make sure it's flim flam, and not film flan... or flan film... other wise it may get sticky and gum up your wrox.

    -tg
  29. Re: App update system - better approach

    What file is being deleted that is an issue? The app? the updater? Data? It's not clear what the problem is. What the file is that's being deleted, or why it's being deleted. OR why it's a problem.
    ...
  30. Thread: Frame

    by techgnome
    Replies
    11
    Views
    411

    Re: Frame

    To fully answer that question - it's because loading the form doesn't show the form. You can't set focus to something that isn't shown. In the load event, that's just the first step or several during...
  31. Replies
    8
    Views
    1,334

    Re: [RESOLVED] Joomla How easy is it to use

    If after 6 years, nightwalker hasn't decided that Joomla is for him or not, then he's got some issues...
    Please be cognizant of the age of the corpulant status before grave digging.


    -tg
  32. Re: VS 2019 - System.IO.IOException - Started out of no where

    This is going to sound strange... but leave it in... try commenting it out and see if still works or not... but debug statements in running code shouldn't be a problem...


    Here's a real-life...
  33. Re: App update system - better approach

    I'm not sure what the problem is. what does the updater do?
    Should be using the bootstrap method... uses two apps... one to launch the other. The bootstrap app checks to see if there's an update,...
  34. Replies
    8
    Views
    2,356

    Re: is React JS is Better or Angular JS

    Reminds me of the time when a co-worker was trying to get to experts-exchange.com ... forgot the "-" in the middle... got blocked... then an email from IT asking why he was trying to access "expert...
  35. Replies
    1,646
    Views
    78,898

    Re: Corona virus, China major city lockdowns, etc.

    Lemmie guess... the Gov & LtGov are elected separately? Yeah, we used to have that here too in SC... they changed that recently, so the next time the Gov comes up for election (in two more years I...
  36. Replies
    5
    Views
    217

    Re: MySQL Syntax Error Setting up SPROC

    Yeah, I'm not seeing it either... the only thing I can think of is maybe the version of MySQL doesn't support it? Seems like a stretch though... then again this is 2020, stranger things have...
  37. Re: [RESOLVED] SQL - translate date to sequence as integer - timeline

    Yeah, ROW_NUMBER, PARTION BY the DIVID ordered by the Create Date should give you what you want. Since Ascending is the default order, it's not necessary to specify it. Also I wouldn't use "#" in the...
  38. Replies
    8
    Views
    473

    Re: MySQL (with VB6) questions

    :thumb::afrog: sweet...

    -tg
  39. Replies
    9
    Views
    399

    VS 2019 Re: Json Deserialize to List of Class

    Do, becaue the current example doesn't indicate that it can be a collection... Even if there's only one, if it's intended to be part of a list/collection, it should be surrounded by square brackets....
  40. Replies
    8
    Views
    473

    Re: MySQL (with VB6) questions

    As for access level, it's either db or table... I don't think it can go into the cols/fields.
    For writeability... that's different... usually it's people want to make things read-only, which an...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width