Click here to Skip to main content
15,216,788 members

Comments by PIEBALDconsult (Top 200 by date)

PIEBALDconsult 21hrs ago View
   
Most ideas are not worth stealing.
PIEBALDconsult 3 days ago View
   
"there must be some conflict in memory management" -- Doubtful.
Maybe show other parts of the application.
PIEBALDconsult 3 days ago View
   
I see a few bad things, but nothing which seems like a problem. Are you sure the files don't contain the same data?
PIEBALDconsult 3 days ago View
   
Do you have an extraneous COMMA? "type": 0,
PIEBALDconsult 5-Jul-20 1:20am View
   
I see a number of issues.
The use of .ToList() is a red-flag for me, but more importantly is that you appear to be getting the full list of data items, converting them all to objects, and _then_ filtering then -- ideally the filtering should be done within the database.
PIEBALDconsult 2-Jul-20 22:27pm View
   
Ummm, well, what compiler error do you get?
PIEBALDconsult 2-Jul-20 21:54pm View
   
1. Of course you can. In ADO.net, everything goes through ExecuteReader.
2. Yes.
3. Hey, long time, so no see.
PIEBALDconsult 22-Jun-20 11:04am View
   
Windows Scheduled Task and a DEL command.
PIEBALDconsult 21-Jun-20 15:40pm View
   
Be sure that the value of the parameter is not null.
And, no, you can't have a WHERE clause on that type of INSERT statement.
PIEBALDconsult 21-Jun-20 15:08pm View
   
Sparingly.
PIEBALDconsult 19-Jun-20 18:31pm View
   
You ask about reading, but the code is writing.
No one is going to go to that URL, please show a snippet of the data you are interested in.
PIEBALDconsult 16-Jun-20 10:08am View
   
We won't do your homework for you.
PIEBALDconsult 10-Jun-20 16:52pm View
   
We won't do your homework.
PIEBALDconsult 10-Jun-20 10:18am View
   
Yeah, do _not_ go recursive on that.
PIEBALDconsult 7-Jun-20 10:30am View
   
We have no idea what connection_open() does, and maybe you don't either.
Try cmd.Connection.open()
PIEBALDconsult 16-May-20 0:37am View
   
We won't do your homework for you.
PIEBALDconsult 13-May-20 19:00pm View
   
Having seen your edit... Have a re-think. You needn't focus on duplicates.
But I still don't understand the goal, all I know is that F("Hello","Helli") is _not_ 6.
PIEBALDconsult 12-May-20 20:24pm View
   
Best not to do peoples' homework for them.
And that can be improved.
PIEBALDconsult 12-May-20 18:24pm View
   
Unclear.
How many characters are duplicated?
Or how many total duplicate characters there are?
Please provide sample input and output.
PIEBALDconsult 10-May-20 12:33pm View
   
Use main ( int argc , char **argv ) instead.
PIEBALDconsult 14-Apr-20 21:41pm View
   
I'm unfamiliar with MySQL, but how about something like this, which might work with SQL Server:
WHERE CHARINDEX ( ',' + bot_id + ',' , ',' + p_Bot_Ids + ',' ) > 0
PIEBALDconsult 13-Apr-20 0:36am View
   
No, it is not. The primary reason for this site's existence is to share code and solutions you developed by writing articles (and tips).
And do not share code written by others and "discovered" by you.
PIEBALDconsult 9-Apr-20 13:36pm View
   
I think he wanted to provide the connection name as a parameter.
PIEBALDconsult 9-Apr-20 11:35am View
   
There are myriad ways. I have about a dozen, some are quite complex. It depends on what features you require.
PIEBALDconsult 7-Apr-20 1:02am View
   
Deleted
I would start by removing the subquery, it would probably better as a JOIN.
I would also remove the HAVING.
PIEBALDconsult 1-Apr-20 12:57pm View
   
Maybe because you're applying it to the stream you want to read from?
You probably only need to move a right-parenthesis.
PIEBALDconsult 22-Mar-20 22:13pm View
   
Find out which expression is causing the error. I suspect this one:
Formatting = Formatting.Indented
PIEBALDconsult 13-Mar-20 12:01pm View
   
Yet it may be what the OP intended, but was unclear in how he described it.
PIEBALDconsult 2-Mar-20 22:25pm View
   
Please do. Life will be easier.
PIEBALDconsult 2-Mar-20 22:08pm View
   
Please rest assures that it is doing exactly what you asked it to.
PIEBALDconsult 2-Mar-20 22:08pm View
   
EXISTS is a cry for help, don't use it, just use a JOIN (though I don't understand Oracle's JOIN syntax, bleah).
PIEBALDconsult 2-Mar-20 21:55pm View
   
Was the help you receive before not helpful?
https://www.codeproject.com/Questions/5260382/Sql-query-to-be-solved-the-salary-of-employee-deal
PIEBALDconsult 1-Mar-20 22:10pm View
   
Is this only for display? Or do you want to store the numbers? I don't recommend storing the numbers as it tends to lead only to pain down the road.
Of course, the use of MS Access leads only to pain anyway, so maybe you're a glutton for pain?
PIEBALDconsult 1-Mar-20 22:06pm View
   
Well, _any_ numbering of rows is an anti-pattern.
PIEBALDconsult 16-Feb-20 10:45am View
   
That's very strange, I've never seen it before.
But I've never used the Excel source, I always used (past tense) an OleDB source for Excel.
PIEBALDconsult 18-Jan-20 16:15pm View
   
We don't do people's homework.
PIEBALDconsult 4-Jan-20 21:49pm View
   
That's homework.
PIEBALDconsult 14-Dec-19 13:06pm View
   
Nope, but I'll mention that to my boss.
PIEBALDconsult 8-Dec-19 23:47pm View
   
see https://www.programiz.com/c-programming/examples/print-sentence
PIEBALDconsult 8-Dec-19 19:05pm View
   
# define add +

Done.
PIEBALDconsult 8-Dec-19 19:04pm View
   
Maybe in your blog, but there is probably a better place.
I publish short erotic fiction on Literotica, and there are other venues out there.
PIEBALDconsult 1-Jul-19 1:02am View
   
If the drawer is connected to the printer, then you will likely need to read the manual for the printer.
PIEBALDconsult 6-May-19 0:12am View
   
textbox1.text.toString() is redundant.
PIEBALDconsult 6-May-19 0:11am View
   
Hear hear!
PIEBALDconsult 29-Apr-19 19:19pm View
   
Probably XPath.
PIEBALDconsult 25-Mar-19 0:40am View
   
We won't do your homework for you.
PIEBALDconsult 21-Mar-19 15:07pm View
   
I doubt it... Probably can't get permission to install it.

Which means I get to roll my own.
PIEBALDconsult 21-Mar-19 13:10pm View
   
I suppose it would were I Web-savvy.
In the meantime, I do finally have the POST I'm working on working. But there's gotta be a better way!
PIEBALDconsult 7-Mar-19 23:29pm View
   
Roll your own.
PIEBALDconsult 6-Mar-19 20:21pm View
   
I think you're mixing C# and VB.
PIEBALDconsult 21-Jan-19 11:43am View
   
Is that what the _user_ wants?
PIEBALDconsult 13-Jan-19 23:04pm View
   
Any way you like.
PIEBALDconsult 22-Dec-18 12:54pm View
   
Are you asking about only the project files? Or also the code?
PIEBALDconsult 3-Sep-18 0:24am View
   
What have you already learned in class?
PIEBALDconsult 29-Jul-18 18:15pm View
   
The spec is rubbish; send it back.
PIEBALDconsult 24-Jun-18 9:58am View
   
You may be looking to create a Web Service.
PIEBALDconsult 6-Jun-18 22:06pm View
   
No thanks.
PIEBALDconsult 22-May-18 8:32am View
   
INSERT ... EXECUTE ... ?
PIEBALDconsult 19-May-18 15:56pm View
   
You don't need a subquery for that, but you'll need to JOIN to the team table twice.
PIEBALDconsult 18-May-18 8:30am View
   
I expect you want an INNER JOIN ON tra_id , but you didn't provide enough detail.
PIEBALDconsult 29-Apr-18 10:21am View
   
Good luck with that.
I'd use brute force.
PIEBALDconsult 19-Apr-18 9:13am View
   
And do they have nothing like 1-800-FLOWERS?
PIEBALDconsult 12-Apr-18 19:47pm View
   
You have to rewrite the whole file.
PIEBALDconsult 7-Apr-18 17:34pm View
   
That's a very common error and I'm sure a quick search will find you information about the cause.
You may need to download and install the ACE Engine, and/or you may be need to run the SSIS package in 32-bit.
PIEBALDconsult 7-Apr-18 13:03pm View
   
By name?
PIEBALDconsult 7-Apr-18 12:33pm View
   
I could do that in SQL Server, not sure about Access.
One thing to bear in mind about databases is that the records don't truly have an innate order -- you need to provide something to give them order.
PIEBALDconsult 6-Apr-18 9:01am View
   
Maybe here:
https://www.microsoft.com/en-us/download/details.aspx?id=7030
PIEBALDconsult 5-Apr-18 22:35pm View
   
Why would you not use the Ceiling?
PIEBALDconsult 4-Apr-18 11:48am View
   
Very likely impossible to do it this way, so I do expect to use another technique.
PIEBALDconsult 4-Apr-18 8:52am View
   
No, that concerns only SQL Server Agent Jobs, not processes in the server, which may be executing via SSMS, SSIS, SQLCMD, ADO.net, whatever.
PIEBALDconsult 4-Apr-18 0:30am View
   
I was hoping you'd have the answer.
Yes, and no. This is a very long-running procedure (hours); not a matter of milliseconds.
Not concerned about parallel executions of the Integration procedure, concerned about an ETL truncating a table which the Integration is trying to read.
We do have a log of all processes in the system, which should be a good enough indicator that Integration is running, and that is my recommendation, but we also want to be sure we investigate this possibility.
PIEBALDconsult 2-Apr-18 18:59pm View
   
I would use a Set.
PIEBALDconsult 1-Apr-18 16:23pm View
   
Master Mind is pretty easy to implement.
You could probably do TicTacToe using those things.
PIEBALDconsult 1-Apr-18 13:18pm View
   
Write it any way you want. But _you_ have to write it.
PIEBALDconsult 31-Mar-18 16:00pm View
   
Frequency? 1/2. Done.
PIEBALDconsult 31-Mar-18 15:55pm View
   
That means nothing.
PIEBALDconsult 31-Mar-18 15:49pm View
   
Looking at your code, I have no idea what it's supposed to do.
And the spec is rather vague.
Do you mean that you are meant to find the number of even integer between 0 and the given number? You can calculate that without looping.
PIEBALDconsult 31-Mar-18 10:27am View
   
Be sure to not leave the connections open when not in use. Open-use-close.
And/or provide a Web Service that the clients connect to.
PIEBALDconsult 31-Mar-18 0:09am View
   
Ah, but put a Web Service between the client and database, and then what?
PIEBALDconsult 29-Mar-18 21:38pm View
   
A repost you mean?
PIEBALDconsult 29-Mar-18 21:37pm View
   
And what happened?
PIEBALDconsult 29-Mar-18 21:30pm View
   
Ummmm... maybe remove the { at line 9?
PIEBALDconsult 26-Mar-18 0:10am View
   
So? What's the value?
PIEBALDconsult 25-Mar-18 10:25am View
   
Are you saying that the code you show isn't the code that produces the stated error?
PIEBALDconsult 24-Mar-18 10:35am View
   
If DHCP is involved, the IP address will likely change, so what good is it?
PIEBALDconsult 23-Mar-18 23:12pm View
   
I don't see what the issue is. Why would any conversion be required? When I plug that statement into VS I get:
سطور عبر الأيام 1
PIEBALDconsult 21-Mar-18 22:56pm View
   
Look at the line number.
PIEBALDconsult 20-Mar-18 21:55pm View
   
I don't know Python, but I'm reasonably sure you need parentheses on the call to read .
PIEBALDconsult 18-Mar-18 15:15pm View
   
With SQL Server, I do that with a table-valued CLR function that uses a Regular Expression.
PIEBALDconsult 15-Mar-18 21:40pm View
   
Remove the ads.
PIEBALDconsult 14-Mar-18 20:02pm View
   
I use the OleDb classes in ADO.net with the ACE Engine.
PIEBALDconsult 13-Mar-18 19:28pm View
   
Sounds like set theory, so look into using sets.
PIEBALDconsult 12-Mar-18 23:48pm View
   
Uh, yeah, it wouldn't. I suspect your if/or is wrong in a particular way.
PIEBALDconsult 12-Mar-18 23:45pm View
   
Do NOT use string concatenation to form an SQL statement. Use a parameterized statement and you'll be fine.
PIEBALDconsult 11-Mar-18 22:57pm View
   
It's probably having as much trouble reading it as I am. That's very difficult to parse, particularly without knowing the tables involved.
I strongly recommend against using subqueries as they tend to perform poorly. In the last few years I've been using Common Table Expression because they often perform better and I find them easier to test.
PIEBALDconsult 11-Mar-18 13:19pm View
   
Try using Int32.TryParse to test whether or not the input is a number, then (if successful) use that value as a parameter value -- and do NOT use string concatenation to form the SQL statement!
Then use ExecuteScalar (rather than ExecuteReader) to return a single value. There is no need for you to use ExecuteReader in this case, and if you do, then you need to close it -- I recommend using a using statement for DataReaders.
And you shouldn't be performing normal operations in the finally.
PIEBALDconsult 10-Mar-18 0:25am View
   
Well, if you look at how the code shows with syntax coloring, you should get a clear indication of a problem.
PIEBALDconsult 9-Mar-18 8:19am View
   
Looks OK to me. What makes you think it's wrong?
PIEBALDconsult 9-Mar-18 8:14am View
   
No, pretty sure not, judging by what Jon Skeet says.
http://csharpindepth.com/Articles/General/BeforeFieldInit.aspx
PIEBALDconsult 8-Mar-18 22:27pm View
   
Why are you even using a DataReader? Try ExecuteScalar to get a Count of matching rows instead.
PIEBALDconsult 8-Mar-18 18:34pm View
   
Visual Studio is an IDE and it may stunt your growth.
C is not a forgiving language, so not real good for beginners.
Python is a good learning language (I hear).
PIEBALDconsult 6-Mar-18 18:57pm View
   
Beginners need to start with beginner languages. If he wanted to drive big rigs would you tell him to skip trying to learn to drive a sedan and jump right to big rigs?
PIEBALDconsult 6-Mar-18 18:10pm View
   
Python. Or a proper BASIC, not Visual Basic.

Can you complete Light-Bot?
https://www.kongregate.com/games/Coolio_Niato/light-bot
PIEBALDconsult 4-Mar-18 19:42pm View
   
Or
myNumber = ( myNumber + 1 ) % imageList1.Images.Count
PIEBALDconsult 4-Mar-18 19:38pm View
   
P.S. Don't do Random like that -- it won't do what you want -- better to make it a static member of the class and instantiate it only once.
PIEBALDconsult 4-Mar-18 13:43pm View
   
Do you mean setting the tags/data/whatever in the file or making your copyright data visible in the image, and which format?
PIEBALDconsult 3-Mar-18 22:22pm View
   
(Didn't read your code.)
Unsure I'd use pointers -- more likely simple integer offsets -- but if that's the assignment requirement, then it's hardly more difficult.
If you allow only one of any particular type of argument (O, A, P, etc.) then try using strstr to find each possible argument and (if present) assign its address to a pointer to it.
http://www.cplusplus.com/reference/cstring/strstr/
Something like:
char *argA = strstr ( cmdline , "/A" ) ;

This type of issue is why the Operating System should never try to parse the command line and always allow the program to do it itself.
If you're using Windows, try using the GetCommandLine function to get the actual command line.
https://msdn.microsoft.com/en-us/library/windows/desktop/ms683156(v=vs.85).aspx
PIEBALDconsult 2-Mar-18 23:26pm View
   
Never use floats for money!
PIEBALDconsult 2-Mar-18 19:02pm View
   
No, that'll never happen in Rubular (or whatever).
PIEBALDconsult 2-Mar-18 18:54pm View
   
What language? Regex is not a "command" and of course you'll need parameters.
PIEBALDconsult 1-Mar-18 18:12pm View
   
Yes.
PIEBALDconsult 1-Mar-18 0:46am View
   
Python is a good first language. It should not be your only language.
PIEBALDconsult 27-Feb-18 22:38pm View
   
Sounds OK to me.
PIEBALDconsult 27-Feb-18 8:58am View
   
It can return a snippet of XML or CSV. :D But that seems beyond the abilitites of the OP.
PIEBALDconsult 22-Feb-18 21:34pm View
   
Only if you do it wrong.
PIEBALDconsult 21-Feb-18 18:26pm View
   
You really don't want to post your email address in a public forum.
PIEBALDconsult 21-Feb-18 8:26am View
   
I had been working on my own Regex caching scheme but found it didn't work well in some cases.
It wasn't until a few weeks ago that I noticed this in the documentation:
"This regular expression pattern is cached for rapid retrieval by the regular expression engine."
So now I am prefering the static methods, particularly when parallelism is paramount.


PIEBALDconsult 21-Feb-18 7:26am View
   
I had no trouble downloading it and opening it with 7zip and Windows Explorer.
PIEBALDconsult 21-Feb-18 6:25am View
   
There's no such thing as a "line of code".
PIEBALDconsult 21-Feb-18 6:25am View
   
Or use the static method on the Regex class -- it provides performance improvements too.
PIEBALDconsult 20-Feb-18 23:56pm View
   
Well, show us the code. Does it work?
PIEBALDconsult 20-Feb-18 23:28pm View
   
Which one is line 105?
PIEBALDconsult 20-Feb-18 20:15pm View
   
That's like no SQL I've ever seen; where did it come from?
PIEBALDconsult 19-Feb-18 15:57pm View
   
A) I strongly recommend against using string for IDs.
B) If it's an update, then why not use UPDATE?
PIEBALDconsult 19-Feb-18 15:54pm View
   
With an editor.
PIEBALDconsult 19-Feb-18 13:00pm View
   
And a lot of the code is needless.
PIEBALDconsult 19-Feb-18 12:35pm View
   
And you're trying to write the result to a different table -- does that table exist?
And where does the data come from before it's shoved into the database?
PIEBALDconsult 19-Feb-18 12:01pm View
   
Where to begin? You're definitely working too hard -- such as .Text.ToString .
There are so many ways that that code can be simplified and improved.
But first, are you saying that you have these huge streams of key/value pairs stored in a database? What do they look like? Are the keys always present and in the same order?
PIEBALDconsult 19-Feb-18 9:04am View
   
Look into Recursive Common Table Expressions.
PIEBALDconsult 19-Feb-18 8:59am View
   
Unnecessary.
PIEBALDconsult 19-Feb-18 1:12am View
   
Huh?
PIEBALDconsult 19-Feb-18 0:16am View
   
Simulate?
PIEBALDconsult 18-Feb-18 21:09pm View
   
inner loop goes from 0 to len-<outer loop variable> ?
or
inner loop goes from <outer loop variable> to len-1 ?
PIEBALDconsult 18-Feb-18 20:41pm View
   
We'd need to see definition of the table and sp_insert . You do know not to begin a procedure name with "sp_", don't you?
PIEBALDconsult 18-Feb-18 16:48pm View
   
Not enough information.
PIEBALDconsult 18-Feb-18 16:11pm View
   
NO!
PIEBALDconsult 18-Feb-18 11:19am View
   
I have had trouble (non Win 10) in that the OS has to find the keyboard and mouse in a particular order -- I always think of it as the keyboard before the mouse.
Try connecting the devices in a different order?
PIEBALDconsult 18-Feb-18 9:34am View
   
I don't think that's a concern for development; as Rick said, that's more about deploying to production. There shouldn't be anything that needs to be done differently in development.
PIEBALDconsult 17-Feb-18 23:48pm View
   
You should be removing any existing SPACEs.
PIEBALDconsult 17-Feb-18 17:09pm View
   
Interesting, I have an idea...
I will say that I can't guarantee the order, but the M-F-M... order should be doable.
PIEBALDconsult 17-Feb-18 10:20am View
   
Maybe make the setters private though.
PIEBALDconsult 17-Feb-18 10:00am View
   
What seems to be wrong with it?
I will say that it looks like you're trying to copy the value of the first match to all rows.
And probably all those ifs can be removed.
Mostly, you need to learn to think clearly. Simplify simplify.
PIEBALDconsult 17-Feb-18 9:33am View
   
OK. Good news.
PIEBALDconsult 17-Feb-18 1:07am View
   
Better performing, sure. You can try using a StringBuilder. Hang on, I'll update my post...
PIEBALDconsult 17-Feb-18 0:51am View
   
How does it look now?
PIEBALDconsult 17-Feb-18 0:20am View
   
OK, and you're still not getting empty lines between files?
Maybe add another Environment.NewLine + ?
PIEBALDconsult 17-Feb-18 0:04am View
   
Update the question with your current code.
PIEBALDconsult 16-Feb-18 19:11pm View
   
Modularity modularily modularity... separation of concerns.
PIEBALDconsult 16-Feb-18 17:59pm View
   
Better to know the ID _before_ you insert it.
PIEBALDconsult 15-Feb-18 23:43pm View
   
Return true. Done.

Check you order of operations.
PIEBALDconsult 14-Feb-18 21:29pm View
   
The disk could have become scratched when you spun it up.
PIEBALDconsult 14-Feb-18 18:14pm View
   
What sort of drive connection? USB? Or an actual FDD connection?
PIEBALDconsult 13-Feb-18 23:10pm View
   
You need to master the fundamentals first.
PIEBALDconsult 11-Feb-18 18:18pm View
   
I recommend looking into the Shunting Yard algorithm or simply using a Regular Expression.
https://en.wikipedia.org/wiki/Shunting-yard_algorithm
PIEBALDconsult 11-Feb-18 14:02pm View
   
"To learn how to use for loops" -- that should help.
PIEBALDconsult 10-Feb-18 13:51pm View
   
Please don't answer your own question.
PIEBALDconsult 10-Feb-18 11:28am View
   
No, we can help you, but we won't do it for you.
PIEBALDconsult 9-Feb-18 18:21pm View
   
Might be good if you provided the error text and the input that led to it.
I don't think you need to read each character on its own.
PIEBALDconsult 9-Feb-18 8:32am View
   
Isn't that the one above?
PIEBALDconsult 8-Feb-18 21:40pm View
   
Prepare for disappointment.
PIEBALDconsult 7-Feb-18 22:39pm View
   
"This types in System.Data.OracleClient are deprecated and will be removed in a future version of the .NET Framework."
-- https://msdn.microsoft.com/en-us/library/system.data.oracleclient(v=vs.110).aspx
PIEBALDconsult 7-Feb-18 19:17pm View
   
I'm not sure I follow you -- you want to use XSLT to transform XML to XSLT ?
PIEBALDconsult 6-Feb-18 0:06am View
   
Have you tried BCP ?
PIEBALDconsult 4-Feb-18 23:57pm View
   
I don't know whether or not that will work, even with MySQL.
I suspect that the database server software still has to be installed and running on the host system -- and then mount/attach the database once the removable drive is attached.

What you describe might be possible with SQL Server CE -- because it's not server-based.
PIEBALDconsult 4-Feb-18 23:54pm View
   
Are there no records returned?
PIEBALDconsult 31-Jan-18 21:48pm View
   
Regex replace? Can't try it right now, but it should be fairly easy.
PIEBALDconsult 30-Jan-18 22:08pm View
   
Of course.
PIEBALDconsult 30-Jan-18 18:41pm View
   
Recompile. Redeploy.
PIEBALDconsult 27-Jan-18 21:24pm View
   
Unwise. Why would you want to do that?
PIEBALDconsult 26-Jan-18 20:42pm View
   
The language requires the main function to have a certain signature (or one of a few pre-defined signatures); you can't just change it.
What are you trying to accomplish?
PIEBALDconsult 22-Jan-18 22:59pm View
   
freelancer.com
PIEBALDconsult 22-Jan-18 17:58pm View
   
We'd need to see some sample data.
PIEBALDconsult 21-Jan-18 2:08am View
   
Not sure about anything else, but your SQL parameter names don't match.
PIEBALDconsult 20-Jan-18 23:15pm View
   
As with anything, don't try to do everything at once; break the task into subtasks.
PIEBALDconsult 17-Jan-18 21:27pm View
   
Don't blame the framework or the language. I avoid Linq, foreach, and many other wasteful things that are designed to keep inexperienced practitioners from becoming proficient.
You can't beat a for loop -- particularly for the kind of stuff you mention.
PIEBALDconsult 12-Jan-18 15:04pm View
   
Look inside. Deep inside.
PIEBALDconsult 12-Jan-18 14:58pm View
   
I count three.
PIEBALDconsult 11-Jan-18 19:47pm View
   
Doesn't sound code-related so no point posting the code.
PIEBALDconsult 11-Jan-18 18:57pm View
   
Separate the concerns.
PIEBALDconsult 9-Jan-18 18:30pm View
   
Why do you think it's JSON?
PIEBALDconsult 9-Jan-18 18:00pm View
   
First, copy the file to a local drive...
PIEBALDconsult 8-Jan-18 19:56pm View
   
Because it's doing exactly what you told it to do.
PIEBALDconsult 8-Jan-18 19:17pm View
   
How will you ignore them if you don't consider them?
PIEBALDconsult 8-Jan-18 18:14pm View
   
Uh huh. And the answers to my questions...?
PIEBALDconsult 7-Jan-18 11:38am View
   
Is all the code there? It looks like parts are missing. Not all parentheses are closed and what is that ELSE doing in there?
Avoid subqueries; try using Common Table Expessions instead.
And why go through all that trouble just to get a count?
PIEBALDconsult 6-Jan-18 20:34pm View
   
So?
PIEBALDconsult 2-Jan-18 21:18pm View
   
You mean like this error here?
IntelliSense: a value of type "test *" cannot be assigned to an entity of type "int *"
PIEBALDconsult 30-Dec-17 17:26pm View
   
No.
PIEBALDconsult 30-Dec-17 11:13am View
   
You really don't want to be putting your e-mail address on a public forum.
PIEBALDconsult 27-Dec-17 21:11pm View
   
Is that where it goes? I wound up using ECHO Y | NET USE ...
PIEBALDconsult 27-Dec-17 1:10am View
   
I don't see how that could work; are you sure it does?
Oh, wait, I see length is static -- so you're cheating, don't do that.
PIEBALDconsult 20-Dec-17 8:13am View
   
I think that would already have to have been written into the code from the start.
A few years back I wrote some code that simulates electrical relays and connected them to form logic gates and such.
I did it via Events and Handlers -- "connections" were defined by assigning one component's Handler to another component's Event.
You would have to sho wu show you implemented the "connections".
PIEBALDconsult 17-Dec-17 15:23pm View
   
Yeah, that certainly doesn't seem like the best place; "ProgramData" might be better.
PIEBALDconsult 17-Dec-17 14:17pm View
   
Not having looked at it too deeply, my first reaction is that you probably don't want the recursion you have created.
PIEBALDconsult 17-Dec-17 13:04pm View
   
First, learn to use parameterized statements -- they make everything easier.
And if you provide a sample snippet of XML I could probably show you how to amaze your friends -- you're working too hard.
PIEBALDconsult 17-Dec-17 12:03pm View
   
Oh, what grotty code.
Look at the definitions of the macros.
Examine the output of the pre-processor.
PIEBALDconsult 17-Dec-17 11:35am View
   
Use a BACKSLASH (\) -- not a SLASH (/) -- to escape the BRACKETs.
PIEBALDconsult 17-Dec-17 11:32am View
   
The compiler is NEVER wrong.
PIEBALDconsult 16-Dec-17 21:11pm View
   
And you have a closing BRACE out of place -- reformat your code and it should become clear.
PIEBALDconsult 16-Dec-17 20:51pm View
   
Doesn't the error message tell you the line?
I see that this:
char b[26]="Welcome To 8 Tech Hardware";
triggers this:
IntelliSense: a value of type "const char [27]" cannot be used to initialize an entity of type "char [26]"