Comments by RedDk (Top 200 by date)

Get {professional help:
https://learn.microsoft.com/en-us/dotnet/csharp/misc/cs1022

Ahah! "A and B matrices" ... that's calling a spade a spade!

Honestly, no one's going to be able to help you with anything until they have a word they can highlight in their "Help Viewer" to find code for you to use.

Bad stuff, like timeout errors/warnings and insufficient memory messages, have plagued my code for years and it seems as if one of the first corrections that rehabilitated my TSQL coding was dropping the use of CURSOR. For any and/or all procedures. Search through yours and see if you use it

So, stripping index then retabulating to commit the data sounds right.

Always the answer: "Whatever works" (no matter for how short a time ...) ;)

THe last time this poster was active on this site was in 2016. This is a question from 2012. Adding the fact that it's an old post is only the fender of the steamroller: it has no code to substantiate any validity of meaning to cpians, and is so vague as to be basic documentary recrudescence.

Today it's 2022. And that is why I'm downvoting this Answer.

That's your right. And did you know that definitions and declarations and data structures came from the land of assembly language? Fun facts.

Just looking at the code (so far) ... what might help is running through your declarations to see if any of them even begin to resemble some type of 'position' ie "point". I'm guessing, being new at C# myself, seeing CS0103 is bit of a shock because it looks like I'm going to have make explicit my public (or private for that matter (says a nube)) decs.

Like I said, coming from C++/C where MS compiler upgrades often break old code without any tweaks to the user interface, like intellisense functionality updates as well, perhaps NOW you add an int.

Or something.

[Edit]
Better luck looking here: https://answers.unity.com/index.html
CP is good for discussing why something's not working in your code when you can provide descriptive accounts of why what you have might not be what's right despite the "working" aspects of it.
{/Edit]

{Edit02]
Freggzample: https://answers.unity.com/search.html?f=&type=question&redirect=search%2Fsearch&sort=relevance&q=GetRandomSpawnPoint%28%29 ... all of thes posts address what one'd intimate was wrong with NOT declaring an int, a list, an array, etc ...

Just search there on a function name. This is what I tell my dentist I do when I'm having my teeth examined. And he says back to me "Ok, so being employed is a good thing"
[/EDIT02]

Short answer, and what I see as the end of the discussion ... SQLite is not a Microsoft product.

What are we talking here? Environment.SpecialFolder Enum of System.Runtime.dll? If this is what we're talking here, in order to proceed we'll need some more information. Along the lines of ".NET 3.8" or ".NET what?".

For what it's worth, using the Visual Studio Installer for the version of this software with which you are currently fiddling and ticking Help Viewer then hitting Modify (to download and install) makes it easy to then run the app, tick all the boxes for all the content, once upgraded, then search using keywords and ultimately find the answers to the questions you ask.

use array

What interfaces to SQL and C++ are you using?

I suggest you use VS Object Browser to identify valid/referenced procedures and methods and functions then select a corresponding structure in your code (because it wouldn't make much sense to look for something that doesn't exist as such in the documentation) and give it the old F1 to bring up the HELP.

The documents are riddled with sample/example ... and there's no way to get it wrong copying the same style or at least starting with what is right AND WORKS.

Using the "Add a Solution" ... button ... is not the same thing as a "Have a Question or Comment" button. What you've done here is seed the wind. Because, unless all these posters have bookmarked this original post of yours, nobody but polyphemus will respond.

Perhpas it's because:
"It's 98 degrees ... in the shade". (reggae thump reggae thump)

For starters and since there's really a lack of detail about how you arrived at this barricade going down the road in VS, click on the "Help" button on the main menu and under the Index tab in the search box type "LNK2001". You should see a list of prefixes "LNK", followed by four digits, the length of which is greater than your arm and hand with extended finger combined.

Well, you could start by replacing variable names. Just to see whether the SAME error comes back. Checking for error, a kind of fail-safe (do until it breaks), might determine whether there's spoof. Or something.

Yes,
Exactly. Frhed.
Get it there.

Is this that Calculus 101 problem that optimizes the volume of a container having dimensions width x height x length and given a flat piece of real estate (for the sake of IEEE engineers out there, in all fields, everywhere, including aliens from outer space who construct things out of unobtainium, which is not recognizable as feasible to earthlings) ... I leave the MATERIAL ______________ (blank)?

Then no. I have no idea how to run through the Riemann (pronounced as in Syngman Rhee) Sum, delta, epsilon approximation, limit producing solution.

But I could look up how to do that.

You refer to VBA, by tagging this post as such, as if VBA were VB ... perhaps the lesson to be learned is that VBA and VB are as distinguishable as an apple and an orange.

What the poster means by "It's not working" is "How much is it going to cost me to buy software that will do this for me?". And by <bold>nothing<bold> you mean "Why haven't you filled in your true location information bebeath your "Image Unavailable" greybob?". My 5+ (wait where did the +5 wacko-response-to-spam button go? It was here a minute ago.

In addition to what OG says there's also TWO regsvr32 apps (one in System32 and one in WOW64) and you've got to pick the one which ... succeeds at registering the driver.

I managed to get Access 2020 installed on Windows 10 by doing the very thing you're having trouble with ... the wrong driver is named in your old code. Mine WAS "Provider=Microsoft.Jet.OLEDB.4.0;" and I had to change it to "Provider=Microsoft.ACE.OLEDB.16.0"

Formatting issues with this post have I. It's customary to capitalize leading characters in sentences. Let me start with that as a reason that noone is going to be able to judge whether the other appended code is grounded anywhere in reality as-is.

I've had good experience with the brand "Brother". And my most recent purchase of a higher-end Epson (for photographic printing) has been grand. This one's inkjet; but WOW! What a print quality!. My Brother monochrome laserprint has standard ease-of-use features (why doesn't BROTHER emblazon the model number/type on the front panel of thing to make recommending a particular to another potential purchaser easier?) but there's no scanner. And that's really the point. I'd say buy your printer based on the scanner spec you desire. I'm still holding onto a scanner that scans at 9600 dpi (reflective) because it's as adventuresome an input device as can be found. It's so old it no longer can print anything. But hey.

Yo Bro, this looks suspiciously like a programming question. Maybe it's better if you post it here: https://www.codeproject.com/Lounge.aspx

In reference to my comment beneath here:
https://visualstudio.microsoft.com/launch/ ... in case anyone wants to mark their calendar.

I see no whitespace ...

Use VS. As I understand it, there's even a free version (possibly named "express"?). That header containing the atlbase.h requirement is telling the compiler to look for function bodies in the atlbase.lib. THAT library, which is "part" of Visual Studio is typically used in conjunction with MFC. And finally, it is highly unlikely that any MFC/ATL code you ran across and downloaded off the www will compile and link without some flavor of Visual Studio installed on your development box.

If you wait until the end of November 2021 to purchase Visual Studio you will also be required to install it on a 64-bit computer. It will be a dedicated 64-bit installation and then be able to address more than 4GB of memory.

Open Access and attempt an "Import" of this database you're having troubles opening. Simply tab to "External Data", pick "New Data Source" then choose "From Database" ... "Access" ... and browse to the trouble location. If you get an error then post extactly what the error's text says here.

What should you choose? The latest installment of whatever by whomever. Presumeably your implementation skills are based upon however. Easiest to go with whichever now. Which is whenever. Pretend you've enlisted in the Army ... and using standard issue equiptment is the option available to you.

Here at CP there are a few available articles that might be worth looking at:
https://www.codeproject.com/search.aspx?q=DWG&x=11&y=4&sbo=kw&usfc=false

DXF and DWG files are indeed proprietary formats but they are well documented and more than enough information about their structures is readily available on the internet.

Run "Programs and Features" from "Control Panel" and scroll down, after everything loads (takes some time for the list to populate), to all-things Microsoft. If "Microsoft SQL Server" is the pre-fix to any of the numerous SQL likely-installeds, find any/all that you wish to uninstall and right-click to see what operations are available. Typeical ones are "Uninstall", "Change", "Repair", and I recall there are others as well. If you've got an option to "Repair" do that one first. Next try "Change" if it's there; just to see what you're up against ... if something is indeed installed.

I'm looking at your other recent post and I get the feeling that you've been looking at the list of GREEN checkmarks and RED exs that are displayed at the end of the NEW INSTANCE installation wizard. If your system is not meeting a particular requirement to upgrade/update a previous installation (versions are varied but this wizard refers to the version that actually got installed at some point) you'll be unable to proceed. As my memory serves me, clicking on any of the HELP links during that run to install should redirect you to MS docs about the particular section of the requirements that it's complaining about. Read carefuly. Everything.

And finally, if these two things fail just UNINSTALL all "Microsoft SQL Server" installations and start all over.

In THAT case, add Debug.Print statements to the code block. Find the immediate window (under main menu "View" (it's possibly "Call Hierarchy" in VS)) where print statements are made. There are many steps to take when debugging; look up "Debugging applications in C#". Everywhere. As did savoir faire.

Sorry about that; I mispoke.
Best to look here:
https://www.codeproject.com/search.aspx?q=XSL&x=0&y=0&sbo=kw

intz R us, like right? First off ... correct your grammar. For instance "i" at the beginning of a sentence, should be "I". Then we'll see about some help.

The images are named according to their uniqueness. Or, better yet, images are named according to their uniqueness.

See the forms here:
https://docs.microsoft.com/en-us/dotnet/visual-basic/language-reference/error-messages/name-name-is-not-declared
The SQL is ok ... but, as stated below, without data there's insufficient motivation for me to tackle anything in the "Try" block. And there's that too. A Try block from what?

What?

tbl1Data uniquevalue
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
R07.9,R42 R42
E07.9,Z83.3,Z82.49 E07.9
R10.32
S00.81XA,S59.802A,S13.9XXA S00.81XA

Haven't a clue as to what you want here.

Well, I'd start by normalizing your data. That is ask yourself what does it represent. Then formally make it pretty. For example you've started off with two cells of content. I'd have started off by making all the content "normal" (same spacing for each "item") because I know how useful a "token" is when dealing with "parsing" of that data. I see here Name: ... and that goes along with Insurance: and Location: and Type: ... follow?

So, start out with a one CELL:

"Name: Young_Yamen, BD: 09/21/1960, Sex: M, Insurance: CHIP(U4024563201), Location: Far Rockaway, Type: Radiology - Results Follow-up"

Dear Doctor Dakelbab,

Obviously, you're going to h a v e to find some C# coding examples (of ALL KINDS) and follow the example of coding in each in order to do any developing ... using WPF ... using whatever.

Weel, then to optimize I'd start by running a query and posting some output showing ME the output for this [Column Details].

Just to confirm, try commenting out "and isc.COLUMN_NAME like '%email%'" (line 15) to see that you can return something. Hopefully you'll see a big table full of information about the instance you're running it on.

If there's no such COLUMN_NAME where the word "email" is surreptitiously contained, leaving that line in will return no records.

Sure. You can hit the "Improve Question" widget and the Question as it is currently typed will appear in editable form in the edit box (again). By enclosing in [Edit] brackets [/Edit] such things as a connection string, for instance, you can make what looks like added value to your original. Exiting the edit will refresh the Question.

What is the connection string you are using right now? If you think this information is sensitive use standard substitutions for the bits most likely so. Without seeing the thing which is causing that error, there's no way for anyone here at cp to judge what's wrong.

Thanks

Just to be clear then, SELECT CONCAT([CompOrNXP],' ', [FeatureName]) As [bugBigger], [DisplayOrder] is still MySQL (something that this altered question used to be before the poster created the above snafu by reigniting the controversy over editing Qs in QA) ... ?

Invalid object name exception says that those "name" objects don't exist. Check all your code for the keyword "CREATE TABLE". I do this by searching my code base for that phrase. In SSMSE, double-clicking on a line in the find return will actually open that script. Then you can narrow your search using those "name" objects or, as would be the case were the actual location was now open, you can visually see each table name.

Not there? Well then, you're out of luck.

Same question posted seven times since December 15, 2020 ... (just saying) :)

Not enough information. Sorry. Also, try using PRINT statements for your variables (variables are those things that are prefixed with a "@" character). Any values at various stages, when run, will be printed in the "MESSAGES" window at the base of the Managment Studio.

For more technical debugging, see the BOL. Or look up functions and methods of TSQL adding some context, like "loop" and "MSSQL", in a search engine online.

Works fine for me as is.
You mention: "this work fine but I need ... like this that give me result of all product of the tables".
Like what? The typing in the second textbox is IDENTICAL to the typing in the first textbox...

... I'll take that ;) ... the gist of posting ... an apparent boost in my own programming abilities, of course.

This is what is called a code dump. There are so many unknown identifiers in this 433+ lines of TSQL that this couldn't possibly be all of it. For anyone to help you with this error it would make sense to say how much more code there is. But, "Invalid length parameter passed to the LEFT or SUBSTRING function" tells me that an allocation is too small in size. There are two (2x) LEFT statements and there are fifty-seven (57x) SUBSTRING statements ... start there.

[EDIT]
Example of what I mean by the incompleteness => [dbo].[Student] is created but never referenced. Anywhere here.
[END EDIT]

Sage advice from RMC. To debug open Access, tab to "Database Tools", choose "Visual Basic" to open code editor, then pick a module and highlight a variable. On the main menu, under debug, click "Add Watch" and see the "Watches" window with the chosen "Expression" now in the list it's value (most likely) [left arrow] Out of context [right-arrow].

The debugger is run by two keys on your keyboard, F8 to "Step into" the highlighted code's block, F5 to "Run" to the end of the procedure (assuming you've set no "Breakpoints"). Using F5 with breakpoints set will cause the debug run to "go" until it comes to a breakpoint at which time hitting F5 again will allow the debug run to continue to the next statement. By observing the "Value" of the highlighted Watch variable in the Watches window you should be able to see how everything proceeds.

Once familiar with this process you will begin to use Ctrl and Ctrl+Shift patterns with F8 to navigate around. It's as simple as that.

I see a lot of typos here. Which makes answering deadly.
USE [PARAMU1973]
GO
CREATE TABLE [dbo].[MySplittedTbl2](
[bill_no] NVARCHAR(42),
[order_no] NVARCHAR(43),
[billing_qty] NVARCHAR(44)
)

CREATE TABLE [dbo].[MyTbl2](
[bill_no] NVARCHAR(42),
[order_no] NVARCHAR(43),
[billing_qty] NVARCHAR(44)
)

Why does this "MyCodes" query appear so queer?

SELECT * FROM [PARAMU1973].[dbo].[MyTbl2]

Seems like it should work if you ask me.

I'm no expert using OneNote, it was only recently that I even got the desktop app to respond with anything other than a double error message by hitting the RESET button under Windows 10 "app" control, but I'd say selecting that "print" using VBA in Excel, particularly through a loop WITH OneNote as your target, is going to be extremely unlikely to be easy ("Print to OneNote"). It's clear enough in Excel that you can do this manually but finding the Add-In name or the Office tlb or other library, accessible or not through Object Browser of VB Editor in Excel is an experience which is not for the faint-hearted. Does xlDialogPrint list OneNote? If it does be prepared to GET a dialog poping up FOR EACH AND EVERY item you wish to send to the individual locations. My experience is that that pop-up can't be made invisible or silent or in any other way suppresed even in a loop from VBA.

[EDIT]
From: https://www.excelforum.com/excel-programming-vba-macros/468018-controlling-the-cancel-button-in-xldialogprint.html

res = application.Dialogs(xlDialogPrint).show
if res = False then
' dialog cancelled
exit sub
End if

Looks plausible?
[/EDIT]

Whatever way works, presumeably ...

... arghh ... there goes the farm!

SQL ... mySQL ... two different things. As in Old MacDonald's farm, many animals and no clear way to know one from another; until they make a noise.

Quote: "reinstall my server"
That's drastic ... but then again, what do you mean by "server"? I don't want to suggest anything to the suggestable.

I use SSMSE. That's an abbreviation for SQL Server Management Studio Express and it allows me to do just about anything a user who wants to become familiar with programming/developing in TSQL would want to do. If you're interested in learning TSQL I'd also suggest downloading the Book-On-Line (BOL) for the version of SSMSE you've installed. All available in MS site ... somewhere.

Try (under Additional Connection Parameters tab of "Connect to Server" dialog) typing:

TrustServerCertificate=True

The word in forums other than CP is that doing this is not a good idea. So see if it works then perhaps rollback your success to see if you can get login to fail again (back to current state). And think about it.

I've been trying to work through this problem and have come to the disconnect which is the table definition "#finaltable". I could continue to work through it using my substitute for the origin table (the data which you provide is contained now in it) but without any structure ... I'm going to call it quits.

So, some CREATE TABLE code would be useful ...

You say two of the three queries are successful ... if you show some/(all) of the return for those two, that would be helpful. HSQL, as I've seen it used, requires some java installation and since there is no connection string in either of the two "good" queries I'm wondering how you managed to get anything at all without a reference.

Well that can be expected. Eventually you'll get to a point where everything compiles and you've got an executable or a library. Then you can learn how to use the debugger when you find out that running it doesn't produce the results you expected :)

Also I'd recommend using other resoiurces as well. Like SO => https://stackoverflow.com/questions/50668814/vs2017-e0135-namespace-std-has-no-member-filesystem ... specifically the error above.

[edit]
... and don't repost you code.
[/edit]

It's possible that "getline" (as is "std::getline") is not being recognized as getline is not defined in the namespace std. But if you go hunting through the include <string> (most likely> or <iostream> (less likely) ... you'll find that the proper way to access it is string::getline (likely) ... possibly std::string::getline. Notice that you've no reference to <string>. Now is it all coming back to you?

Do some sample/example downloadable projects (from MSDN or other) for WPF-XAML-C# and after making a working application, apply the same paradigms that worked there to the problem that arises through you're own coding.

Consult the help document for your root installation. That's the "Book On Line" which has to be obtained from MS. Lookup "XML". Read about all things TSQL in that "BOL".

You know, once you code something to do something and it works as you want it to work, you can save that code, make copies of it, store the copies ... then after you build up a store of code that works ... even search through it usg keywords that are found in that BOL, you're all set. You don't have to code again. So you're efforts become you're own answers.

Once you write some code and it works, you never have to do anything with it. Not even "know" what it was you did in the first place: just look the keyword up in your storage and determine whether something you wrote is suitable to use in your new procedure/method/function/etc.

Fantastic or what?

Before the flood there was ...
https://dzone.com/articles/top-10-programming-languages-in-2017
Those ... (multiple choice/pick one) ...
Yes, five years ago. But as an old friend of mine used to say "what's true today is true tomorrow".

Generate a number (randomly) then use that number as a row index under a SELECT condition.

Doesn't work this way.

Essentially, you'll be transfering your database to a dedicated server through a hosting service that either owns that server or is renting space on it, presumably also taking care of security matters. This might be done through renting out MSSQL SERVER space at various incremental rent prices.

The webpage that YOU maintain, under these paid services is going to provide the necessary leveraging applications so that a user at your site can login/logout, surf, buy, comment, do whatever it is you deem necessary. Look up webhosting. Under the types any returns you'll first off see the packages offered at what costs. The specifications for each type will contain things like, ASP.NET capable, MSSQL Server capable, Number of EMail accounts, etc, etc.

I just read OG's answer and what he says sounds like it's about right but I'd paraphrase a little by adding that in my experience MOST SQL Server "disconnects" (I use the term both amusingly and in a psychological sense) are related to file/folder sharing and system security settings, usually for the local drives, but not limited to that part of the machine, and antivirus programs that ALLOW remote access or disallow as the case might be.

Here's what I do to sleuth disconnects due to these things. First and foremost, don't try to do anything monumental like backup an instance that's as huge as an entire drive. Why? Because it takes TIME! Start by looking at subsets of SQL Server data. Create a tiny database! Run the same thing that you did when you came to the current impasse on THAT.

One main idea behind developing a program through coding is putting YOUR CODE through it's paces (as if a novice could walk to begin with, right?). The idea that you're going to jump into doing anything using someone elses code is ludicrous.

Start small and MAKE IT FAIL. Get it?

Good.

Short answer:
For SSMS(E) to recognize anything, and I'm assuming you're refering to databases in the Browser panel, the INSTANCE has to be running and that can be accomplished by going into Services and Applications under Computer Management/Services ... and checking whether the STATUS of INSTANCE(NAME) is "Running".

But I suspect you've no idea what you're doing with the backend of an app you've created using C# in VS or you've downloaded a C# example of database programming from which you intend to learn how to connect to a database through C# but only have a downloaded .MDF file.

You've got loads of FOREIGN KEYS (to which the error "1072" refers) ... Check whether there's a column by the name of each of the foreign keys because THAT'S what is causing the flap.

see here:
https://www.w3schools.com/sql/sql_foreignkey.asp
for how to add the right code to your .sql script.
Or better yet consult the BOL for your version of SQLServer.

Use the "Improve question" widget in the post-space prefixed with a tag like "[edit]" put any modifications to the original post under it then "[/edit]" if you want to address something someone who replies to your question has made obvious to you, or better yet use "Reply" where they say it to begin the dialog to clear up the issue.

Absolutely!

What RmC says. What do you think you're going to do? Everytime you want to read one .pdf, you scroll to some point in the entire downloaded .pdf database and read there?

Formatting issues with your paste of (oracle?) code into the control above are interfering with my understanding of the problem you encounter ("[Error] execution (39: 6): ORA-06550: Line 39, column 6: PLS-00306: wrong number or types of arguments in call to 'CREATE_OFFER_T'")

There's a "Discussions" section called "XML/XSL" which is found on CP here: https://www.codeproject.com/Forums/3421/XML-XSL. When you ask questions in QA it's a good idea to see what questions get answers (although it's getting increasingly hard to find anything that resembles a good question given the QA FAQ (https://www.codeproject.com/Articles/64628/Code-Project-Quick-Answers-FAQ) doesn't make a bit of difference when devs are not adhering to it as much as q-posters.) and provide problems that look like other problems.

For example you've got no error so you've got no error code. Long story short: try DIscussions in XML. It's easier to continue the debate over something you see as fundamental or something perhaps flawed. There you can ask why.

[edit][/edit]

Open the pdf in Acrobat Pro and save the "table" content as XML. That format can be imported directly into an Excel spreadsheet using the Excel app itself (multiple versions have allowed this since Excel first came out and I can't imagine the latest incarnation wouldn't allow it as well). There's a bit of a disconnect when it comes to pure (sp) XML and MS flavor of XML so be forewarned that retabulating the tables can be hit or miss. Also try Stackoverflow on the words Excel and XML ... and PDF too, right?

DOS.H ... on no known computer after year 2000 will any 16-bit program run. "Run" in the general sense of the word.

And here's another idea. A trick you can add to debugging strategy bag. Using the Find-In-Files do a search for the troubled term. In this case, you'd be running through the project looking for "gameObject". Obviously, or perhaps not so obviously, the CASE option would have to be ticked.

End up using whatever the author of the project used.

I always try ALL OF THEM (varbinary, nvarchar, varchar, blob, etc) then when I find NOTHING works, rethink th eoriginal problem. As stated beneath here in Solution 1, you're trying to tilt the untiltable if what you think is yeah-wide (bytes) turns out to be yeah-wide-x-2/etc. Like trying to guess what the x and y of a specific image file in it's RAW state by testing every dimensional possibility.

This is a generic compiler error (CS0246) in C# and an app such as Visual Studio will report the very error you posted. In VS there is a way to reference the .NET assembly. Perhaps the project file that you opened in order to begin your development was referencing a previous assembly. So check in the reference browser to see that Netframework 4.0 or better is assembly to which the reference points. Typically, (it's been a while ...) a reference set to the assembly that doesn't contain a required method/function/etc will have a yellow YIELD sign next to it in the treeview.

Quote: "throws an error".

It might be helpful to tell cpians what kind of error this is (crashes the machine, blue-screens the machine, shows up in computer Management under Event Viewer, etc) or, if a textbox with an actual error message appears on screen, the exact text of this "error". I see TCP host is mentioned but to be honest I've never seen TCP host errors in the flesh only through ditched processes stepping out of rolled-over "SQL Server Configuration" regurgitations where zombies like "Named Pipes" and "Shared Memoory" come at you as if they would eat your enabling brains.

Also antivirus programs (typically third-party but of late native) make it a habit of flexing port address coding muscle by making it possible to prescribe to hard-wired digits. Like 'yer 1433.

I'm just guessing here because what usually happens when saving HTML to the desktop or another folder (perhaps the website was "published" through VS, I don't know) the path is not absolute. Try including the complete path name along with the file. Experimenting in VS, particularly when jumping between DESIGN and SOURCE is the only way to go. Plus you've got an advantage when doing the manual arrangement of content through DESIGN. Just read the SOURCE that got "wizarded".

https://www.codeproject.com/Articles/64628/Code-Project-Quick-Answers-FAQ

Your best bet is to contact Comscire (https://comscire.com/discontinued-products/). I understand you're looking to specifically migrate to another computer the legacy device which ran under a different configuration, on a different OS. I've fought that battle and lost so I can understand the frustration (outlay of proposterous amounts of money to ungrade only to find "knowing something about 64-bit memory space" wasn't near enough knowledge to "get it to run". Great expectations.

(never mind ... this editor @ cp is massively messed u)p

A little data and a little table structure will go far in reducing the amount of conjecture required to help here.

If your firewall is being managed by third-party software, such as an antivirus program, you can usually go to that apps preferences and find a system settings where it's possible to overule DHCP or other LAN prototcol and input a hard address. Do this on both computers on the network so each sees the other. Then there shouldn't be any security warnings or footplants on any necks as you go forward.

And I think I've managed to hardwire the LAN computer across the room using Windows Defender in the same way. It's in the System Settings under security ... somewhere.

Weeel,

Here's whats shaking. This is the third repost of the problem. But I'm giving you credit for doing something. Even though creating code for CREATE TABLE isn't in the realm of JSON. So much as it's in the realm C#.

Anyway, to keep a thread alive here @ QA, REPLY to a comment. Or use the SEARCH by typing in a few of the words that each comment contains ... perhaps the ones you deem most salient

Sure. There must be something you'll be able to do using a current version of VS and a few downloads from elswhere. Check these out:

https://www.codeproject.com/Articles/1187512/Image-recognition-with-Csharp-and-Emgu-libraries
https://www.codeproject.com/Articles/196168/Contour-Analysis-for-Image-Recognition-in-C
https://www.codeproject.com/Articles/19323/Image-Recognition-with-Neural-Networks

Having read the CHT entry found in wikipedia, it appears that the "guessing" and the "voting", because the object under scrutiny has no known 2D component (ie: circularity) could be/always will be in 3D ... an estimate has to be made. So iteratively and by blurring the coordinate axis' along with the prospective circle perhaps the two distances can be closed down ... until a better certainty is established. In a nutshell: blurring/grayscaling takes a lot of noise out of the bigger picture. A typical circle becomes less ovoid, right?

See "Gaussian Blur" for details.

Null or NA or blank in the return from a SELECT is tricky without a post-process of some kind. Which is usually done in a higher code layer than the TSQL. I'd say redesign your table so that SELECT contains a JOIN ... which is masking the fact that instead of one table from which the structure is being queried, there are two tables or more.

This is basic TSQL. Might have a look at AdventureWorks samples too.

GeoTIFF?

Hhmm,

I'm curious ... you say cycle and I'm wondering what would happen, given the ability to mix up the power scheme having another source tentacled as such to the same motherboard, and as I say in my latest comment above, on a card that has edge power "somehow", what that bonafide card power would say about a real cycle disparity. Would there be a synchronization? Would no synch even be a problem (like a modem out of synch with a computer that's not on the same wall outlet)?

This sounds like a good idea.

Well that actual solution to "kill" the device might be, then, to install a hardware switch ... THIS is the solution to many mods that come to MY mind when thinking of adding holes to the steel case to do something to the innards ... but the device would have to have a connection to the motherboard's power that was accessible through the power unit alone. Obviously if it's on a PCIe/PCI/AGP/other card then there might be derivative power leached off an edge connection (which you don't know about). Disabling BIOS objects (sp) doesn't necessarily power-off them.

This is just a shot in the dark but isn't USBDeview capable of turning off the power of any "powered" device it enumerates during a scan? S'great little app when sleuthing USB connectivity and determining hardware configurations ... google it. It's like savoir faire, man.

... arghhh! ... man, there's nothing more aggrevating than a poster editing his post without alerting the community participants to his edit. Now my code doesn't pass intellisense ...

[EDIT]
And lomac's headsup had nothing to do with the problem ... and I quit
[END EDIT]

Excel Error 1004 is the outermost generic error ... it comes back as a message alert to just about anything and everything Excel FAIL. So you'll have to debug to get at particulars.

Basically, this is quite easy. But then there's the fact that Access comes in many versions ... which makes getting anything librarilly 64-bit to communicate with something else 32-bit driven a great big no-go.

Anyway, getting SQL Server database that is running under 64-bit can be done through Excel AND Access (32-bit) as long as you target the MSSMLBZ instance. Use the simple SQL tools available on the ribbon and make sure the 32-bit MSSMLBZ (or equivalent I'd imagine) is running and connected (you'll be able to see that in the Excel or Access database explorer).

How many worksheets does this CSV contain? Can you save this .csv? And when you get a prompt when you save this .csv telling you that some functionality might be incompatible if you try, do you save it as .xlsm instead?

I see "rs.Open" and think tag is missing from the collection, VBA, or Excel, or Access perhaps. But anyway ... on the SQL Server end of this SELECT DISTINCT etc query, perhaps using SQL Server Management Studio Express would expedite any understanding of TABLE and DATE.

"Can't get it right". What? No data in a table. No method to get the data from a table. This is not a good post as is.

Use the "Improve question" widget to add to what's already stated.

Why do you con.Close() then con.Open() after you check if con.State is (==) ConnectionState.open? Wouldn't it be safe if ConnectionState.Closed was the condition then just con.Open() the result of the "try"?

... and that code looks like? Noone is going to offer up a solution to this problem without a poster showing some code. If you got an error message use a debugger to find where it occured. I type the exact error message along with quotation marks into a search engine and always get back returns. This "error message" you have here is a trap built into the code. If you're not getting errors, what are you getting?

More reply:

I see in the data posted no output data matching any of the [DocId] so I have to assume [LoadDocumentId] is not the same thing?

Ok,

I reconstructed a scenario using the data by CREATE TABLE and since I'm using SQLServer 2008, I had to investigate the problem of the SELECT within the SELECT using a UTF which I got from here:

https://stackoverflow.com/questions/10914576/t-sql-split-string

BUT, since STRING_SPLIT was invented and included in SQL Server 2016 any talk about it's magical properties is lost on me. I suggest running through this stackoverflow thread and gleening what you can about slicing up that 2, 4, and 6 substring [EmailThreadChildHashcode] using one of the response post solutions ... as I have begun to do ... but I just haven't got the time right now to get that actual SUB SELECT running (hint) ...

After a very quick look at what you've done I can say that the "output" (four columns) is never going to be anything more than a two column container ... so this last

inscription is fantasy.

See your "INSERT INTO @spli" statement where you've specifically quantized the number of return columns as two, [DocId] and [Dataa] ...

And look up CROSS APPLY STRING_SPLIT in the BOL ... something about that quotidian placeholder using the apostrpphe doesn't look right. Perhaps its the CP editor. I don't know.

You BEGIN a TRANSACTION which you never END ... this is very basic and easy to spot. Use the help BOL which is accessible under the {?} of the version of SSMSE you are using.

Ok, not sure if this idea will help or hinder, but since you might now have a table ... change it into a "linked" table. Right click EXPORT of that linked table will allow you to contextually package an xsd/xml/other (even html I guess). If you do that, you'll be able to see your data in .html. Can you do this?

Actually what all these guys down here are saying is true and there's good suggestions as to how to start but looking at this code ... it almost looks as simple as QBASIC (since it's numbered). You might try just pasting it into an empty C# project module then fill in the function declarations. Been there done that.

I know, not C++ ...

You talk about xml but don't show what that xml looks like. This "XML" is typed XML in the database? What SQL tools are at your disposal? Access is cool because queries can be run and, as you suggest new tables from those results can be saved from the queries ... but as far as XML goes there's the main connection to that format through IMPORT and EXPORT facilities built into it. There's a whole HELP topic in the Access {?} "Exporting" queue which covers SQL and table linking. But if you really want the lowdown on XML and Microsoft Office products you'll have to have Excel (spreadsheet/workbook) installed. Check HELP there as well. In Excel the topic samples are most specific and there's the added perk that all four topics, XML, SQL, Access, and Excel get lumped into a nice IMPORT/EXPORT/TABLE tutorial which blasts MSXML (that insideous monster) in favor of obtaining real W3C XML.

I'm looking with interest at the stack of posts you've piled up here at CP in the last few lapses of time and can see that you are truly hooked on this idea of programming. This happened to me long ago. Nineteen-ninty-five to be exact.

What I did was go to => https://code.msdn.microsoft.com/ ... you can clear the wheat from the chaff in the treeview panel to the left by simple tick. Using more discreet terms results in a final narrower return.

Often the samples are ExACTLY what a dev/progr is after. If not exactly, at least in the language he/she wishes to address. Methods and all.

Here's my two cents worth of TSQL advice. First of all TSQL is just another language used by developers to address hardware through software and SQLServer is one flavor of SQL in the "ching t'ien" of flavors. Noone knows what you have in mind for your software, the task, the underlying math you're using, what the meaning of "translation" is to you so anything they say about what you've qualified as an underlying problem FORMAT, specifically what's stored as NVARCHAR (perhaps knowing there's DATETIME ...) and how CONVERT isn't working for you ... really doesn't matter.

Your DB can store date as anything you like. Plain and simple. As far as all these pundits sounding off beneath here with do do ... use the BOL and start by running sample code found by typing in search parameters related to the thing the message text makes most outstanding. That's typically some verb.

What tools are at your disposal? I see no "Microsoft" in any of the above "xml" so credit to you for posting actual XML and not some flavor of xml produced by a third party software. I'm thinking that I could help you if you had Excel and Access installed.

To get to the stage where it would make sense to start thinking about using SQL to move things along.

"Which combination of .. etc"? Obviously, any one which works. "Best" ... not a word that has any meaning in programming sense especially when not being used as a keyword in the code.

Use the search engine here at CP and type in terms you've got an inkling of an idea are "related" to the code you wish to use, compile that code (or use the returned ARTICLE sample which you can compile with whatever tool you're using as-is ... to develop an idea of what it is cpians come to this site to do (imhe)) ... this title "How ... {etc}" is valid. It's done.

Cutting to the chase, see here:
https://www.codeproject.com/Tips/500811/Simple-Way-To-Use-Pivot-In-SQL-Query
AND here:
https://www.codeproject.com/Tips/1011591/Dynamic-Pivot-Query-in-SQL-Server

Ok,

Perhaps I'd be paraphrasing OG in Solution 1 by stating that without knowing which version of SQL Server you're targetting, saying something like "There is a better as well as built-in geospatial data storage facility in SQL Server 2008 which exposes decimal longitude/latitude operations without troubling manual haversine computation. Which you're heading for using the above input NVARCHAR/VARCHAR string representations"

You're not really on the fence though. So, don't NOT do what OG says in his SELECT paste just because he says not to do it.

Be advised that the link provided is the CP link to it's article. A severe amount of wading through the COMMENT section is required to demuck the compile version disparity boots ... so cutting to the chase (perhaps) see here: https://sourceforge.net/projects/cximage/ for the download.

Perhaps "CInt" has not been declared (Dim) as type integer?

Dim CInt As Integer (add it to contador(i) As Integer) to make a list.

[EDIT}
You know, when you edit a post to conform to something a qa answerer says, you make it difficult for anyone with postential HELP to follow you; unless you use something like what I'm using here in this comment -> an "[EDIT]" message addition mark. You could also use the REPLY widget to respond directly to .. whoever. Just a heads-up for future readability.
[END EDIT]

Try developers.google.com ... for sample code ... as the above appears to be specific or altered generality.

That link to the nubb of a code block where there's useage samples which runs it is purely C primordia. This (idea) above looks to be a dedicated Windows overlay leveraging such OGL functionality. Maybe this CP article will get you started making that transition ... from the merest to the robust.

https://www.codeproject.com/Articles/15419/GLFW-A-Simple-OpenGL-Framework-Library

It's not as bad as it looks (Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 is the top level catch of the "Cannot execute the query" rider which follows).

So, you have to see if all these objects exist on the target database. Try using "SELECT * FROM sys.database" or any number of similar sys.[extensions] SDF or better yet lookup keywords in the BOL.

Since you've managed to do the ODBC thing outside of all this TSQL, where you're getting the FAIL, I'd assume that getting to the data store is possible through some other means so try there too. Something like MS Access will allow you to do tests on running instances of SQL Server usg a variety of drivers, ODBC included.

Hey, CP QA search is working correctly now!

https://www.codeproject.com/search.aspx?q=%22M.+Ricardo%22&doctypeid=4%3b5

Ok. I just told you how to copy a stored procedure from one database to another. Your question is answered. Sorry, can't help you with this new stuff.

Ok. So what I think you're saying is that the user doesn't have permission to ALTER a stored procedure? My question then is => "why does the user need to ALTER a stored procedure?" If you're saying that a user can't run a stoproc I'd say there's no point in copying all the stoprocs to the target database.

[EDIT]
Maybe I read that wrong. Try ... SELECT * FROM sys.procedures ... and see if the procedure name you require shows up in the list of results. As it stands that INTO clause seems suspect.
[END EDIT]

I think the best idea, or what I usually do when I copy a stoproc from one database to another database, is right-click the target procedure and choose "modify". The procedure will then open in the editor and I can change the word "ALTER" to "CREATE" ... then save it as .sql script. Run it on the target database (the one without it).

Typically there are few other things which might have to be added to the target database as well, possibly a SCHEMA, and any reference which was on the origin database.

Here's how I'd go about doing exactly what it is you wish to do -> convert a VBA "program" into an executable running with methods exposed and accessible through VBNET but it's going to take some work on your part. Open the Excel app and on the Developer tab select the Visual Basic editor (Alt+F11) and launch the interface. Find your VBA code block (as above, we'll assume the editor is where you found that block) and with the code under focus and once visible in the workspace, select Object Browser (F2) to make sure that window is open also. You'll see in the Object Browser a bunch of things not the least of which is the libraries under use in the project, the classes, member classes, etcetera ... and you can choose any of the project libraries in the drop down and see the methods and classes change beneath. This is the key place to begin finding the functionality that crosses over to VBNET.

Putting your cursor on any keyword in your code block and hitting F1, say GetFileList, will either result in an Excel Help item or "Keyword not found" but in whichever case, links at the top of help page, say to "Excel XXXX developer Reference" might provide more insight. I'd suggest finding a code block entry which does have a keyword entry ... and start there. You have to set some breakpoints and step through you VBA to see what works. And ususally something like an error message will mean that a library is missing so you'll have use the Object Browser to find a similar keyword and figure out what that library might be then include by adding it to References (right context click - popup to see the list of potential online libs available).

In short, after you've figured out that your Excel code works as expected by stepping through it you'll have the first bit if insight into the functionality which will (inevitably) be available in VS vbnet. 'Almost guarantee the code's in VS VBNET, in some framework incarnation or system core library ... and THEN SOME.

There's no other way, my friend.

Why Kibana exactly, since you bring it up?

How about using VisualStudio in Design Mode and just dragging and dropping whatever you're trying to triage where you think it needs to be intially in place?

The code gets generated. Seriously easy.

Surely this code block is incomplete.

Both of those returns are correct. The best reference to use in any case is the Book-on-line help that ships with SSMSE. You don't even have to look anything up. Put your cursor on the KEYWORD "SUBSTRING" hit F1 and you've got half a dozen examples showing what is proper. Down under the F1 object then there's a host of related terms and methods and functions. This is the best course of action. Frankly, this question is silly.

Show your batch file code ... so far.

Use the BOL. It is a very pleasing tome.

See here:
https://jamh-web.appspot.com/computer_vision.html

If it's any consolation I've been working with TSQL, SSMSE, and BCP for years and I've never been able to decrypt the BOL sample code which higlights .fmt use as a format file. I conclude that it's not possible to do the this and the other things whirling around in the realm of WITH.

There's an infinte loop in here somewhere ... just so you know. I'd have stepped through the code to find out where exactly, but I'm late for a very important date.

I like how you think my friend. A quick 60 byte 1 x 1 pixel .bmp with 16581375 variations of RGB triad (comb/permute ... scheesch I remember doing this with QBASIC in a "codon" display at console twenty years ago ... just for the halibut) .. a very admirable task in C. S'gonna take more than a few 4GB drives to store (as OG said down there in the locker) ... but still admirable.

Does clicking on "htaccess" tag (next to "See more:" just above this post) and viewing some of the relevant QA posts here in CP help any?

.Shower us with some code

No way that way. But think about it. How time consuming would it be to CREATE DATABASE twoMybase from the .mdf, use the system enumerator (sysinfo/similar) to get all the information you're after, dump it into another table then DELETE the DATABASE?

">SSMSE-Setup-ENU.exe /?" should bring up a list of deterministic parameters available ... but to my mind there is no password switch which will make what you want to do easier.

But then there's this:
https://docs.microsoft.com/en-us/sql/ssms/ssms-utility?view=sql-server-2017
Which leads one to believe that you might be able to do a post-install retrofit of such a thing.

And, then there's this, which looks even more promising:
https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-2017
Good luck!

quote: "I joined them" ...

So these numbers are totals per each (column) "address"?

And customers are the same thing as guests? I don't understand.

The word "tally" is probably a professors insert. Check your course notes. (It doesn't even appear in the SSMSE BOL and returns only a light sprinkling of returns in other online code queries).

Did you know: that you can CREATE SCHEMA [zizznoofuss] and dispense with the use of [dbo] altogether?

INSERT INTO dbo.x VALUES('Explicit value','Explicit value') would insert two records ... or as you say INSERT INTO EMP VALUES('xylem',1),('phloem',2),('cantbeatum',3),('joinem',4) ... yes?

Using "#" to prefix a table name makes that table temporary and available only to the current user (local). It gets deleted when the session ends (disconnect). By the same token using "##" makes the temporary table a global table that can be used and also gets deleted but only when all other users are not using it.

So it's a time thing. But don't expect to know when the session terminates. Which is why doing temporary work under [dbo] schema control seems like the best thing to do at all times, imho.

Interesting question but what do you mean when you say:

-- SET @Parameter = ','+@Parameter +','

Does this really work?

I get Msg 537 "Invalid length parameter passed to the LEFT or SUBSTRING function"

[EDIT]
OK, check that. I get it ... just a comment
[END EDIT]

... working on it.

In earnest, improving your question ... is something we need to do in this case. So, here we go. Forget that idea ... I have a question for you. Why don't you show your TSQL query along with some CREATE TABLE code so we can throw some data in there in order to spelunk the error code you're seeing when you run the faulty code. Oh, wait ... FOrget that idea. Just give us your code, we'll slap some data into the table and ... what is the error code? Exactly.

Might leave a note at the foot of this webpage. The author might have a greater understanding of this C# mannerism and might even be able to define what he means by "image" better than John Q. Public here in the QA.

Also, my experiences with IPv6 tell me that it's easy to disable this kind of functionality at a low level system window adherence. But your anti-virus might be having it's way with that fundamental allowance so check there too.

I'm a bit confused ...
https://www.codeproject.com/search.aspx?q=CNC+lathe&sbo=kw&usfc=false
Your reference is to ... ?
https://www.codeproject.com/Questions/772996/VB-net-Modify-Structure-SizeConst

Read this:
Terminate and stay resident program - Wikipedia[^]
I would suggest that such technology as a batch script which runs as a monitor of file use is going to do all the things this wikipedia page warns that TSR would do.

See that "Related Questions" list down there on the lower right of your webbrowser screen? Thinking about doing such a thing isn't listed. My take on this list is that if I can't understand what all these suggestions are doing here, MY question is not a good one.

Try googling "inexpensive file monitor software".

What is "IBT1" and what is it's relationship to "T0"?

Please refrain from removing content of questions when editing posts. This question is completely different now, since the "update". And that's not ok with regards to posted Solutions ... users come upon pages through various means ... seeing answers in sets of returns from a search that have no connection to original posts ... can seem senseless without context (nubes arriving this way have no idea where to look for revision information).

So, next time use [EDIT] ... [END EDIT] ... and make it easier on the Solution posting community.

"Last row" because there's no index, right? Anyway, what RD says is partially ok but what I think you're going to have to do is use CONCATENATE on the return from multiple columns => to put into "single cloumn" as you say.

Is it possible to post some example data? Seeing "input" form is great but seeing "output" form is even better. That way there's no imagination involved.

Huh, that's funny because it worked the other day ...
https://www.codeproject.com/Questions/1252460/Store-procedure-parameter-is-not-working)

Lets assume for a minute that you don't mean "cs script error" install but an error made in an attempt to install the packet manager (VSIX) in VS. You do understand that the VSIX is a .zip file, yes?

Someone posted a link somewhere to here:
https://www.mathworks.com/matlabcentral/fileexchange/?term=authorid%3A31862

Try posting any questions you have about the download or comments about use at the end of the cp article page from which you've downloaded the code. Most authors will reply and sometimes, even if no straight dope comes from them, commenters provide the tweeks neccessary to get something to work from the default post if there's a version disconnect etc.

Try logging in here ...

https://login.jitterbit.com

Then ask your question of someone who might know what you're talking about.

0x80004005 -> If you look here:
https://www.google.com/search?q=System.Data.OleDb.OleDbException+(0x80004005)+site:social.msdn.microsoft.com&num=100&sa=X&ved=0ahUKEwjn5vXAzpzcAhWBrZQKHbuDDX4QrQIIMygEMAA&biw=975&bih=886

... you'll see that this error is less descriptive of an actual breakdown in the code you're pushing through OleDb and more of a generic failure (on the part of OleDb dev's as MS, right?) ... and at best should be flagged as the lip of some cascading nonsense. I'm not going to scroll through the types of errors myself. I'll let you do it. Good luck.

Just a hunch ... have you ever tried using the BCP and outputting SELECT results as .csv then BULK LOAD the (whole) thing back into the table? Sounds possible, yes?

See here ... https://support.microsoft.com/en-us/help/201740/cannot-create-object-error-when-browsing-asp-pages

You want to print same name with address (which, considering the database indexed cutomer id contains those two items in distinct columns (say) "name" and "address") but you are using the asterisk (*) to return ALL column items (however many that might be) in your query?

How about this instead:

SELECT [name], [address] FROM Customer WHERE CustID = 101

You might want to clarify that this two-lined internet browser representation of a one-lined string (there is no linefeed or carriage return) is the object about which the posted disconnect is going to occur ...

First of all, noone can "import MS Excel to" anything. One can Export MS Excel to something. Or one can import MS Excel from something. If you tried to import MS Excel to MS Excel I suppose you would "open" MS Excel. I do have both of these apps, so I know.

VBA ... and ... SQL

Please edit your post and include appropriate tags. VBA, by the way ... oh, forget it. I'm out.

Not sure why anyone would be hacking into a freely available code base to a 3D graphics platform (Microsoft DirectX is distributed as an SDK for numerous species of ... MS sub-platforms) but I'll assume you're using Visual Studio when doing this IID and CLSID trick ... go to Properties Page, and under Linker/Command Line type in the characters: /VERBOSE

This'll tell the linker to blow up the message content in the OUTPUT window the next time you try to compile. You ARE linking this so anyway ... the library to which the unresolved external is TRYING to link will be named now. Once you have the name ... say DXSHOW.lib or some such thing, you can go back and add it to the External Libraries list ...

Something like that. Been a while since I did DxSDK sample compiles tbh ...

There are 33 open tags in this ... "xml". I would suggest finding a primer of using "XPath", do some of the sample examples found in/at MSDN (of microsoft developers network) then attempt to get jiggy with some monolithic dev app to VALIDATE this ... "xml".

What is the exact error message you get when you run this TSQL code you've shown.

For future reference include some sort of [EDIT] ... [END OF EDIT] brackets when you alter the original post. In order for "us" to understand where "we're" coming from when "we" comment.

Forensically?

Highly unlikely. Ask your guy. He's the one who didn't say anything to you when you described the reason for bringing the computer into the shop. Where the drive got (scrubbed?) reformatted.

I want to know what the exact error message from SQL Server was. Every line of it. Substitution of sensitive terms excepted.

Automate ... in conjunction with what? Using an MSDOS batch to install SQLServer (package) because you want to "ship" (bad choice of words perhaps) your app with the package and install it on a user's machine because your app requires database functionality found in that package?

I don't want to suggest any scenario which might catch you up so I can only guess at the reason why "automate" is being tossed around here.

Tell your app user to download SQLServer Express with Advanced blah blah (the version you've used to develop the app) and install it before trying to use your app.

"App" is a poor choice of a word also.

It should "pop" up when you step into the code; you might be touching a bit of the VS interface with the mouse so the app window receives no focus. Therefore, try minimizing VS to see if the app is indeed maximized "behind".

Just a thought.

You'll need to download the DirectX SDK as well. "As well" is the same thing, en englais, as "too".

Try including the database file. I can read this article and I can see that it's about a deployment. The pseudofact remains though, that I can manage packages through my VS installation and that management typically will install assemblies to the GAC but ... that's probably the reason your package doesn't work. There's no SQLite assembly installed.

How did you reference System.Data.SQLite, if you don't mind me asking?

And about that, manual referencing in the VS (to my mind what using NPM to do the dirty work, or NOT, as the case turns out to be when the VSIX is completely non compos mentis) ... it occurred to me after successful assembly inclusion that another problem might arise and that might be that the remote machine might not even have the VS runtime file (for VC++ ... even noted on the SQLite site) so be sure to include that in any installer thingmajig.

I'm not sure this'll help you, but I've spent a few hours struggling with Nuget Package Manager on VS2010, trying to compile/link from source the SQLite netFx (1.0.108.0) with it ... and I finally succeeded at getting a referenceable System.Data.SQLite through the VS gui. Now, as for "SQLite.Interop" ... that particular .dll isn't canonically available through my "full-source" endeavor but I'd say perhaps starting from source you'll get a more local box-friendly assembly than one typically downloaded from SQLite dev site.

The caveat to my struggle was that I never managed to properly script the INSTALL which will run with a "confirm" error as-is, so my referencing was done through .NET "add" dialog. And I understand, from you're previous post, that THAT actually doesn't appear to be the issue with you because you can actually get by without an intellisense balk because you've even managed to get this "interop" to a "using" state. Which I never could, using the SQLite download of the installer pre-compiled as a binary (with a patent script switch (PS2) present apparently).

"undefined reference" ... is weird to me but I don't use Dev C++ ... you'll note though that this project DOES require TriMesh so perhaps if you go to the link you've pasted and read the README file to get the trimesh link so you can download that code, and then try again ... I mean there's apparentridge.cc and it NEEDS trimesh.h. Another for-instance ... the other set of includes you'll be needing for the graphics handling, the outdate GLUT/OGL headers (presumeably the libraries as well there).

In TriMesh ... there's actually an MS project for that, posted by some good guy who does nice things in his freetime. Perhpas switch your compiler/linker to some flavor of VS free-version.

Questions like this really interest me. I like seeing code that appears to address some abstraction that is not a bare-bone leveraging of TSQL (particularly TSQL because it does things like BASIC does) tricks ... this stuff'll fly ...

BUT ... CAST and CONVERT is 'yer demon. Understand them and you'll understand why I'm not going to wade through this code without a table of data using my debugger.

All that said, I think you have a misunderstanding of the CAST and CONVERT methods.

If you really want to use that concatenation string you can and it's very easy. But as far as learning TSQL and getting versed in the string operators which will take precedence in this case, the best thing to do is get SQL Server Express with Advanced (stuff), install that ... and also download the BOL (Book-on-Line) for whatever the version is that you choose.

Doing SQL things like using a connection string to sheboogle the database is fine from C# ... don't get me wrong. But the TSQL documentation in the BOL can't be beat. (Also while I'm thinking of it, download the AdventureWorks sample data affair ... there's lot's of this example sprinkled throughout the BOL and there's nothing they don't do there that can't be done by any novice picking up the skill determinately.)

As RyanDev said (and I reiterate) ... What?

Perhaps the "things" being JOIN'd are of disparate types, yes?

(gambling is a vice)

Ohhh ... "security" ...

https://www.codeproject.com/search.aspx?q=SQL+AND+Security&sbo=kw&usfc=false

Forget about "security" my friend. Security is in the eye of the beholder, to quote a rhino ...

Many CPians here, mainly one's who delve in QA answers like to use the haggard old saw of "sql injection" as a crutch on which to lean ... as they stroll down memory lane ... or sit with the Queen, as it were. And I've no doubt that many of them come from a long line of viceroys/landed gentry ... but anyone asking a question here, like you ... has nothing to gain from getting nervous about IT.

Consult the Book-On-Line for details.

Here's what I do when I'm in doubt about all things scalar-vector-graphic. Take the miscreant .svg, open it in whatever editor you're using to edit the graphic content and reduce it's complexity by deleting ... fluff.

OR ... create a new scalar vector graphic and paste WELL KNOWN misbehaving (xml) objects into it and save it as your ... new issue.

OR ... create a scalar vector graphic that behaves as expected using the javascript you've got.

Etc ...

Sure (good idea, and one that's on my work hit-list ...).

You could use RIGHT, LEFT, MIDDLE, etc ... any STRING comparitor ... after converting the SELECT return to proper type. You ARE talking "compare" for analysis or "find-in-str" type of processing, yes?

Use CONVERT or CAST. See BOL for details.

Example:

var number = 55.4301;

to reduce the precision ... use:

number.toPrecision(2)

which will give you:

55.43

Don't think you'll get a lot of takers here in CPQA if you don't show a specific code block where something works or where you suspect there's some faulty coding going on; those types of queries are best.

But starting from nowhere, you could look here:

https://github.com/Microsoft/DirectX-Graphics-Samples

Try peppering your Subs with Debug.Print. That always worked for me. From within the Visual Basic Editor you'll be able to see the assigned variables printing the value in an iteration (Intermediate Window).

I'm surprised that no error messages at runtime have not begun to plague you.

This one is huge:
http://www.worldbestlearningcenter.com/index_files/vba-examples-microsoft-access.htm
(this one in particular: http://www.worldbestlearningcenter.com/index_files/Access-if-else-statement-sql-vba.htm)
Haven't looked at any of them but the list seems to be comprehensive. Walking through things like this is the best way to learn how to use the features most effectively.