Search:
Type: Posts; User: techgnome
Search:
Search took 4.27 seconds; generated 54 minute(s) ago.
-
Either a CTE that gets the sum independent of the other table, or a sub query that does the same sounds like the way to solve it ... maybe? Also, it sounds like he wants a Data Warehouse which would...
-
Your use of REsumeLayout is incorrect as well ... 1) you never suspended layout, so it's going to draw regardless 2) You pass in False as a parameter, which is the same as calling .SuspendLayout()...
-
There should be...
https://learn.microsoft.com/en-us/sql/relational-databases/databases/attach-a-database?view=sql-server-ver16#attach-a-database-1
-tg
-
Personally I think you should be dead for a number of years (at least 5) before getting something named after you. It's to make sure that it isn't being done in the heat of the moment and that what...
-
It's actually (kind of) noted on ShowDialog
Looks like there's more info about it in the Close method.
-tg
-
Return "VTOFD[" +Toolnumber + "]=VTOFD[" +Toolnumber + "]+PCOR"
You're missing the + after the Toolnumbers... breaking the concatenation.
-tg
-
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...
-
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...
-
It's not even a Wait or DoEvents ... its handling the Dryer_CycleComplete() event.
-tg
-
Don't check for invalid syntax... look for a valid one... if it isn't valid, then display the message.
-tg
-
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...
-
Yeah it's 1am Sunday here east coast US... oh... no... midnight... glad I checked on that...
-tg
-
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...
-
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...
-
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...
-
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...
-
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
-
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...
-
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...
-
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.
-
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...
-
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...
-
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...
-
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....
-
Might help to post the error message you got. Otherwise we're just stumbling around in the dark.
-tg
-
It's not a setting on there... it would be a setting in the code when you open the connection.
-tg
-
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...
-
ISO #YYYY-MM-DD# Should also work... but yeah, it needs to be unambiguous, and by default it'll revert to US format.
-tg
-
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
-
Try this: http://dev.flauschig.ch/wordpress/?p=379
-tg
-
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...
-
This is your problem... it's not doing what you thiink it may be doing...
While fnSQLReader.Read()
valuesList.Add(fnSQLReader).ToString()
For...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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
-
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...
-
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...
|
Click Here to Expand Forum to Full Width
|