Search:

Type: Posts; User: techgnome

Page 1 of 13 1 2 3 4

Search: Search took 14.63 seconds; generated 16 minute(s) ago.

  1. VS 2022 Re: [RESOLVED] VB.net: "IndexOutOfRangeException" Error Querying SQLite DB

    That's not aliasing the column... it's aliasing the table... which I don't think is what you want there... it works because you don't actually use the alias to reference the column.
    Actually it...
  2. Re: VS 2022 can't put database into datasource

    Local DBs are more file based than server based - if you were to install SQL Express and create a database in there, you'd have a different experience. But because what you're doing is essentially...
  3. Replies
    23
    Views
    536

    Re: [RESOLVED] Listview loop

    It's not even a Wait or DoEvents ... its handling the Dryer_CycleComplete() event.

    -tg
  4. Re: Parsing a String to Obtain a Discontinuous Print Range

    Don't check for invalid syntax... look for a valid one... if it isn't valid, then display the message.

    -tg
  5. VS 2022 Re: VB.net: "IndexOutOfRangeException" Error Querying SQLite DB

    1) It's not an ailias, it's the name of a variable.
    2) You prefixed it with "fn" which to most of us means "function" so it wasn't clear that it was a DataReader Object. Side not, call objects what...
  6. Replies
    659
    Views
    143,193

    Re: Hamilton 5x World Champion ?

    Yeah it's 1am Sunday here east coast US... oh... no... midnight... glad I checked on that...

    -tg
  7. Replies
    659
    Views
    143,193

    Re: Hamilton 5x World Champion ?

    So it looks like hte grid on Sunday will be only 19 deep as Albon wrecked his ride and they're giving Sargeant's ride to him. Sucks to be Logan, but them's the breaks I guess. I haven't seen the...
  8. Re: Passing different types of variable into a function

    I suspect Smux was doing this:


    Public Function DoSomething(inData() as variant ,outData() as variant)

    Which, yeah won't work. But using a variant (as opposed to an array of variants) should...
  9. Re: VS 2022 can't put database into datasource

    Yeah, it's been a hot year or two since I've used it, but yeah, since you have it as a local db, it locks the db file so it can do what it needs to do. You can either quit the Object Explorer, and/or...
  10. Re: How to Add Platform property in .vbproj file?

    It's the other way around ... https://www.vbforums.com/showthread.php?903051-VB6-COMPILED-DLL-giving-CLASS_E_CLASSNOTAVAILABLE-issue ... I'm trying to figure out why the OP is rebuilding it if...
  11. Replies
    3
    Views
    357

    Re: Replace All Colors Except One

    First please re-format your code using
    or tags....
    Second you've posted in the codebank, which is for sharing code, not asking for help ... I'll ask a mod to move it.

    -tg
  12. Replies
    45
    Views
    5,271

    Re: Problem with conversion of values

    This is where things get kind of muddled I think. The answer is "it depends" ... IF you want to build a classic WinForms that will only run on Windows, then you can use FW 4.8 and either VB.NET or...
  13. Replies
    6
    Views
    1,295

    Re: how optimizate the programming?

    To start, by reading about existing algos from books/articles which are language agnostic. From there, depending on what it is you're trying to do, you tinker by implementing one of those algos and...
  14. Re: React Native Login connect with sql server ?

    Try removing the eels from your hovercraft... once you do that, rebuild.

    -tg

    PS and if you need help with the eels, there's a link in my sig block.
  15. Re: Adding a huge number of records to a MariaDB

    That's not the kind of multiple tables I meant ... I mean tables where the data is normalized and there's PKeys and FKey relationships ... it doesn't sound like this aspect is being used. It's just a...
  16. Replies
    659
    Views
    143,193

    Re: Hamilton 5x World Champion ?

    Here's how I see it playing out - with all the action that will be happening in the upcoming silly season, the first half of this season will see drivers playing it safe, making sure to not take...
  17. Re: Adding a huge number of records to a MariaDB

    Have you been told about our lord & savior NoSQL? I'm wondering, if you're going to store the data as blobs, and you're just data dumping and aren't parsing the data into mulltiple tables, if perhaps...
  18. Re: yrs old compiled exe runs on my win 11 laptop, new compile errors only on laptop

    MySQL is irrelvant - the app isn't using it... look at the error message: ODBC SQL Server Driver][SQL Server] ... that's SQL Server, not MySQL...
    So first sort out which DBMS you are really using....
  19. Re: How do I use the byte arrays returned from Read method of the ADODB.Stream object

    Might help to post the error message you got. Otherwise we're just stumbling around in the dark.

    -tg
  20. Re: cursorlocation

    It's not a setting on there... it would be a setting in the code when you open the connection.

    -tg
  21. Re: google drive dll references from AppData\Local\Temp

    Right, it works when you set it to true because it copies the dll to the folder where the exe is. If you set it to false, it doesn't copy it. If it doesn't copy it, how's it supposed to use it? And...
  22. Replies
    5
    Views
    352

    Re: Save all record listview to ADO DB

    ISO #YYYY-MM-DD# Should also work... but yeah, it needs to be unambiguous, and by default it'll revert to US format.


    -tg
  23. Re: [RESOLVED] Darn old null dates in MS Access via VB6

    It's closer to "unknown" value rather than a default.

    Even with strings, there's a difference between " " (a space) "" (no space) and NULL ...

    -tg
  24. Replies
    5
    Views
    488

    Re: Change location of DLL

    Try this: http://dev.flauschig.ch/wordpress/?p=379

    -tg
  25. Replies
    5
    Views
    488

    Re: Change location of DLL

    Don't do that... the debug folder will get regenerated each time you build... What you should have done is create a folder IN THE PROJECT, put your files there, set the folder to copy local. I think...
  26. VS 2022 Re: Populate DataGridView via function from SQLite in VB.Net (VS2022)

    This is your problem... it's not doing what you thiink it may be doing...


    While fnSQLReader.Read()
    valuesList.Add(fnSQLReader).ToString()
    For...
  27. Replies
    14
    Views
    856

    Re: System Re-write

    I believe it's because you can import a namespace... not an assembly.

    -tg

    edit - more accurately: you reference the asssembly, but import the namesapce. Which makes sense because an assembly...
  28. Replies
    14
    Views
    856

    Re: System Re-write

    It means that if you have an assembly (MyAssem1.dll) and it has a namespace (say MyAssembly) and a class in it (ClassA) and another Assembly (Massem2.dll) and it has a namespace (MyAssemgbly) and a...
  29. Replies
    659
    Views
    143,193

    Re: Hamilton 5x World Champion ?

    I'm curious to see how the Hamilton-Ferrari announcement shakes things up. Will Merc still give him the full treatment knowing he'll be leaving in 12 months? What will the other drivers do knowing...
  30. Re: vb2010: why i get the 'NullReferenceException'?

    Hear me out ... if VB isn't working out, you could try godot, which uses C# for its programming (also has built-in gd-script, and also suports other languages through plugin system. The game engine...
  31. Replies
    4
    Views
    461

    Re: Bluetooth Bait and Switch

    Might be an extreme idea, but consider an Electron app ... there's a BT library that you can use... came across it in my tutorials. I have no need for BT so I didn't look into it very far, just...
  32. VS 2005 Re: Folder Control similar to outlook express

    What you're looking for is what's known as an "Accordion Control" .. actually, that specific one might be an "Outlook Bar" ... either way, something to look for...

    -tg
  33. Re: VB6 ADO recordset using SQL - fails when 'WHERE' clause added - SQL fixed still e

    I wonder if it's a connection thing ...
    How I'd probably approach is to create the recordset as a disconnected recordset.. I think you'll need to play with the settings on your .Open line ... then...
  34. VS 2019 Re: Populating a Combobox display/value of states from text file

    In this case, likely not... SortedDictionary sorts on the key ... SortedList on the other hand will sort by default on the first item... The other difference is that you can also hand the SortedList...
  35. Re: VB6 ADO recordset using SQL - fails when 'WHERE' clause added - SQL fixed still e

    No, it happens when there is something in the SQL query that it can't find as an object so it treats it like a parameter (of sorts) and looks to see if there have been any values given to it ... when...
  36. Re: Decompressing a split ACE archive along with progress bar

    This happens because UI updates are given lowest priority in the heierarch because it can be somewhat time consume, so it's sacrificed for performance reasons.
    That said, I think you can use...
  37. VS 2019 Re: Populating a Combobox display/value of states from text file

    That's my point ... which one represents Red? Which one represents black?


    -tg
  38. Replies
    20
    Views
    914

    Re: Compiled exe launched with task manager

    Odds are it's the "End" command... when End is encounteredd, it just stops. There's no cleanup and no exit code is emitted... that's why task manager is still running... it's looking for an exit code...
  39. VS 2019 Re: Populating a Combobox display/value of states from text file

    Use hte System.SortedClass ... it'll sort entries based on the key.

    Thing is though... you're going to end up with a bunch of "None" values in the list ... which one is Red? Which one is Black?...
  40. Re: VB6 ADO recordset using SQL - fails when 'WHERE' clause added

    the unspoken part of zivoni's reply is that you've used a variable name in your SQL. You can't do that. SQL/ADO/your database doesn't know what "lngCurrentLabSpecimenID" is ... VB knows what it is,...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width