Comments by CHill60 - CodeProject

CHill60 13-Sep-24 4:30am View

If you want the OP to clarify their question please use the "Have a Question or Comment?" link next to their post. This is not a solution but has removed the question from the "Unanswered Questions" list.

CHill60 13-Sep-24 4:26am View

If you want to respond to a post use the "Have a Question or Comment?" next to it - the member will be notified of your response

CHill60 11-Sep-24 10:46am View

Follow the link in OG's solution to the Bugs and Suggestions Forum[^]

CHill60 28-Aug-24 3:04am View

The "What I have tried:" section is for you to post the code that you have tried. We are more than willing to help, but you have to demonstrate that you have at least tried to do this yourself.

CHill60 22-Aug-24 11:38am View

Use the "Improve Question" link to add information to your post, or the "Have a Question or Comment?" link to respond directly to Pete O'Hanlon. Don't post comments or additional information as a solution

CHill60 22-Aug-24 11:36am View

Используйте ссылку "Have a Question or Comment?", чтобы ответить. И, пожалуйста, используйте английский на этом сайте.
Use the "Have a Question or Comment?" link to respond. And please use English on this site

CHill60 19-Aug-24 4:11am View

By repeating part of your question as a solution you have forced your post OUT of the Unanswered questions list. Is that what you intended to do?

CHill60 9-Aug-24 13:11pm View

You'll be better off posting this in the right forum - CodeProject.AI Discussions[^]

CHill60 9-Aug-24 13:09pm View

If you have a question or a comment then use the "Have a Question or Comment?" link. Do not post such things as a solution

CHill60 9-Aug-24 6:23am View

Put sample data and expected result into your question, not on a link outside this site (which incidentally is blocked for me at work)

CHill60 5-Aug-24 10:32am View

Start a new question - you can include a link back to this one if it is relevant

CHill60 31-Jul-24 4:40am View

name is not CommandName

CHill60 26-Jul-24 3:15am View

Reason for my downvote - The OP is trying to put headers onto a VBA ListBox so there is nothing to record. Databases were not mentioned either.

CHill60 26-Jul-24 3:11am View

Who is this directed to? If you want to comment on a solution then use the "Have a Question or Comment?" link next to it. You also accepted as the "Best Answer" a "solution" that did not address your question

CHill60 12-Jul-24 7:23am View

There may well be other issues with your code but this is definitely something you need to fix first. After that you might like to actually tell me what does or doesn't happen. Help us to help you.

CHill60 11-Jul-24 8:48am View

This is not a solution to the question. If you wish to comment on a solution use the "Have a Question or Comment?" link next to it. That way the poster will be notified of your thanks

CHill60 11-Jul-24 7:27am View

This is not a solution to the question

CHill60 10-Jul-24 4:06am View

It might be your connection string - hard to say for sure with so little actual information

CHill60 9-Jul-24 6:22am View

see solution 3 and the OPs replies

CHill60 8-Jul-24 4:15am View

Yeah - been a right flurry of that recently. I actually laughed out loud at this one though

CHill60 8-Jul-24 3:53am View

Thank you, not. You moan about someone else's comment here then downvote my solution (that was related to Combobox as the OP required). You couldn't get it to work after 40 years of programming - and yet I could after only a couple more than that.

CHill60 1-Jul-24 6:06am View

The instructions on how to use the forum are pretty clear - https://www.codeproject.com/Questions/ask.aspx[^]

CHill60 11-Jun-24 10:40am View

You've missed my point. that link explains how to post questions in this forum. If you want to "chat" then use one of the other forums. "Discussions" at top of this Page. Select "All Message Boards". Choose an appropriate board. This is the Quick Answers forum

CHill60 11-Jun-24 5:35am View

CodeProject Quick Answers FAQ[^]

CHill60 10-Jun-24 9:50am View

Speaking as a customer I'm more likely to use a mobile-first website than an App on at least the first few visits. The app couldn't be able to let me know I'm near a store because I turn that off.

CHill60 10-Jun-24 3:11am View

If you want to comment on a solution use the "have a Question or Comment?" link next to it. The poster will be notified of your response. Post a solution to your own question and they will not.

CHill60 24-May-24 10:18am View

Nope - I've really tried hard but my crystal ball is obviously not going to work. Could you possibly post the code in the question so we have a chance to work out what might be wrong?

CHill60 24-May-24 4:24am View

If you want to thank a solution please use the "Have a Question or Comment?" link next to it. That way the poster will be notified of your response. By you posting just another (non)solution the poster would only see your response if they ever clicked on this question again - why would they?

CHill60 20-May-24 5:17am View

This works for you? When the View is Tile View? I doubt it

CHill60 14-May-24 5:10am View

Did it work?

CHill60 13-May-24 9:39am View

Try the steps detailed here Installing in VS 2013 or Later - How To · Issue #16 · ComponentFactory/Krypton · GitHub[^]

CHill60 13-May-24 9:08am View

When you state "I added the dlls files" - what exact steps did you take?

CHill60 10-May-24 4:00am View

Tony - I've removed your email from your solution in the same way Dave removed it from your Question. This is an open site, often trolled by bots. A plain email is likely to be targetted by spam.

CHill60 10-May-24 3:58am View

You should validate user input before storing it on your database to prevent stuff like this from happening.

CHill60 9-May-24 8:52am View

Do you have any scope to upgrade your version of DB2? OLAP functions have been around for a while but 2010 is well out of date

CHill60 29-Apr-24 10:05am View

If you wish to comment on a Solution then use the "Have a Question or Comment?" link next to it. Then I suggest you also apply some "logic in your brain" - when Wes posted his solution in 2012 this would NOT have appeared on a Google search because it had only just been posted.

CHill60 29-Apr-24 5:55am View

You will get better responses if you share some sample data and the expected results from that data

CHill60 25-Apr-24 12:34pm View

If Solution 1 does not resolve your issue then you will have to provide clarification of exactly what you tried - i.e. show the XML in your Post and tell us what system is giving you the error

CHill60 11-Apr-24 7:26am View

You can make your question clearer by providing some sample data and the results you expect from that data

CHill60 8-Apr-24 10:42am View

It is a good idea to share your table design, some sample data and your expected results. For example - which columns are not being returned?
Also you need to do something about the SQL injection risk - never use string concatentation to create sql queries

CHill60 8-Apr-24 10:40am View

You said "I have checked the logcat but there is problem in that." - You are not describing your problem clearly and I am trying to help you describe the problem in such a way that someone might be able to help you

CHill60 8-Apr-24 9:58am View

"but there is problem in that" - what problem?

CHill60 8-Apr-24 8:09am View

Perhaps contacting GoDaddy support would be appropriate?

CHill60 8-Apr-24 7:01am View

First you must separate out your values - if it was me, I would keep it simple and just replace all instances of ";" with "," then use the Split function. You could also look at Chip Pearson's technique - Split On Delimiters[^]

CHill60 2-Apr-24 6:23am View

wh.dwFlags gets set to WHDR_DONE when it's ... done. Read Solution 2

CHill60 25-Mar-24 6:49am View

If you have a question to ask then use the red 'Ask a Question' link at the top of the page. Do not post questions as a solution to another member's post

CHill60 18-Mar-24 4:02am View

If you have a question then use the red "Ask a Question" link at the top of the page. You will need to provide much more information than this

CHill60 14-Mar-24 5:18am View

:-D

CHill60 13-Mar-24 13:20pm View

The question is over 12 years old - however this is a perfectly valid answer that does bring something new to the thread so I am not going to downvote it.
However, it would have been better to have explained that from .NET 4.0 the IsReadOnlyCaretEnabled property of a RichTextBox is available and defaults to False so ReadOnly = true is sufficient.
Also adding how to set the text color of the RTB in your solution would have improved it even further.

CHill60 13-Mar-24 8:46am View

Have you checked that SQL Server (on the server) is configured to allow remote connections?

CHill60 12-Mar-24 12:13pm View

That's giving me KAA instead of JAA when I plug it in to my query but that's probably another error on my part - I'll revisit that in a moment. Why on earth I thought 26 * 26 was 702!
I'll get my coat. (It's been a long day)

CHill60 12-Mar-24 5:17am View

I'm sorry - this is a Quick Answers forum not a research facility, nor a tutorial facility. Chosing the "correct" tool is dependent on many things - the requirements, your expertise, how long you have got etc etc. Continue with your research, decide on a tool and come back with specific questions if necessary

CHill60 12-Mar-24 5:14am View

Then share what you tried and explain what "no luck" means to you. We are more than willing to help people who are stuck but we are not just going to do your assignment for you.

CHill60 7-Mar-24 4:59am View

You can't keep adding parameters you need to build up two strings of values and then assign those strings to the parameters.
Having said that, it is poor database design

CHill60 28-Feb-24 4:53am View

Shouldn't that be

c.execute("INSERT INTO student VALUES(?,?,?,?,?)", my_data,)

i.e. a comma after my_data?

CHill60 28-Feb-24 4:49am View

You say "use all the columns" but you not saying in what, nor showing the join. Share the SQL you are using

CHill60 28-Feb-24 3:54am View

The table name is surrounded by backticks `personal info` so the space is not a problem.
https://dev.mysql.com/doc/refman/8.0/en/identifiers.html[^]

CHill60 26-Feb-24 7:35am View

An uncommented, unrelated code dump is NOT a solution

CHill60 22-Feb-24 4:24am View

Thanks for the thought :-)

CHill60 21-Feb-24 3:49am View

See the MS documentation CREATE TABLE (Transact-SQL) - SQL Server | Microsoft Learn[^], particularly the section on Temporary Tables[^].Quote:

A local temporary table created in a stored procedure is dropped automatically when the stored procedure is finished. The table can be referenced by any nested stored procedures executed by the stored procedure that created the table. The table can't be referenced by the process that called the stored procedure that created the table.

CHill60 21-Feb-24 3:14am View

So what is the problem?

CHill60 20-Feb-24 8:56am View

ConnectionStrings.com actually suggests Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=C:\mydatabase.accdb;Uid=Admin;Pwd=;
So try
1. Lose the "ODBC;"
2. use the right driver {Microsoft Access Driver (*.mdb, *.accdb)};
3. Ensure the XXX is the fully pathed name of your MS Access database, including the .accdb
4. If your MS Access database is not password protected then lose the Uid and Pwd parts, they're not required.
5. Consider using the standard security connection Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;Persist Security Info=False;

CHill60 20-Feb-24 8:12am View

If you have a question then use the red "Ask a Question" link at the top of this page. Never post your questions or comments as a solution to another member's question

CHill60 19-Feb-24 9:20am View

"I tried CTE but having no luck on that side" - post the code you tried and the results you got. Nobody is going to write this for you if you don't show some effort of your own

CHill60 16-Feb-24 7:48am View

Is this what you are referring to? gRPC in Easy Samples for C#, JavaScript and Python[^] If so, use the forum at the bottom of that article
Apologies - replied to the wrong comment

CHill60 16-Feb-24 6:59am View

This is the Quick Answers forum, not a group. This is not a question, you will receive downvotes and reports - I suggest you delete it

CHill60 16-Feb-24 6:32am View

Deleted

Is this what you are referring to? gRPC in Easy Samples for C#, JavaScript and Python[^] If so, use the forum at the bottom of that article

CHill60 15-Feb-24 9:39am View

Quote: "In your case, you're using //// at the beginning, which is unnecessary. You only need two backslashes at the beginning for a UNC path." Incorrect, or rather, Incomplete. The OP had "////172..." whereas you are using @"//172...". In other words the OP used an escaped string and you used a verbatim string. Net result is identical.

CHill60 14-Feb-24 8:54am View

We cannot tell who you are thanking - this should have been a comment (using the 'Have a Question or Comment?' link) not a solution

CHill60 14-Feb-24 8:50am View

Upvoted - although see my response as well

CHill60 12-Feb-24 6:59am View

This is just a partial copy of comments to Solution 2. That is plagiarism and is not tolerated on this site

CHill60 23-Jan-24 10:09am View

By posting your code in a solution you have removed your question from the list of unanswered questions. I am going to post your code into your original post using the "Improve question" link, then I am going to delete your "Solution 1" - more people will see your post therefore more likely that you will get help

CHill60 23-Jan-24 8:54am View

We will also need the rest of the Sub above the snippet you have provided

CHill60 23-Jan-24 8:53am View

You also have a problem with a risk of SQL Injection - use a parameterised query. DON'T concatenate strings to construct your SQL statement

CHill60 22-Jan-24 7:14am View

Share at least one of your attempts and explain what happened

CHill60 19-Jan-24 11:46am View

The OP wanted to change the backcolor not the font

CHill60 19-Jan-24 11:44am View

You've forgotten to ask a question

CHill60 3-Jan-24 8:25am View

I think a rhetorical question can :-)

CHill60 3-Jan-24 8:22am View

A code dump with no commentary is not a good solution

CHill60 29-Dec-23 10:01am View

Reasons for my downvote:
1. A code dump without commentary is not a solution.
2. Doing someone's homework for them benefits nobody
3. You have added nothing new to this old thread - the OP accepted Solution 1 as the answer, all you have done is convert Richard's words into a code dump.

CHill60 29-Dec-23 9:56am View

That link refers to LIMIT which is MySQL not MSSQL. Nor does it answer the OPs query - I made the same mistake initially, see my amended solution

CHill60 29-Dec-23 7:54am View

Have a look at Avoid the WPF DataGrid Limitations, Replace It with Few Lines of Your Own Code[^]
Also Sacha's articles that start here - WPF: A Beginner's Guide - Part 1 of n[^]

CHill60 29-Dec-23 6:30am View

I can't use your link, but I think you'll have to build a custom control - probably a combination of a 1 by 3 datagrid next to a 1 by 7 datagrid. Trying to populate it will be fun.

CHill60 29-Dec-23 6:27am View

Don't convert it to VB - it's an algorithm - step through it "physically" to understand it - e.g. build pots in a spreadsheet and cut/paste values into them

CHill60 29-Dec-23 4:31am View

Does this answer your question - https://stackoverflow.com/questions/19197836/algorithm-to-evenly-distribute-values-into-containers[^]

CHill60 28-Dec-23 7:37am View

As an aside, your code in Page_Load is vulnerable to SQL-Injection attack. Never concatenate strings to create your SQL statements - use parameterised queries instead

CHill60 21-Dec-23 7:09am View

Please read CodeProject Quick Answers FAQ[^]
Also understand that using slang like "ya" does not endear you to many members

CHill60 20-Dec-23 3:16am View

You have added nothing new to this old thread

CHill60 19-Dec-23 7:26am View

We cannot see your screen, access your PC nor read your mind - share the code and tell us which line you placed the breakpoint on. You will also have to share which ComboBox control you are referring to
But be aware, VB6 passed out of support decades ago, so the chances of you finding someone who can help are much reduced

CHill60 15-Dec-23 5:57am View

You haven't asked a question. What is wrong with the code that you have?
"please note chtgpt is not giving me the right SQL query :P" - not really a surprise but how do you know? Is that the code you have shared?
Use the Improve Question link to clarify your problem

CHill60 14-Dec-23 5:55am View

You have forgotten to ask a question or state a problem

CHill60 14-Dec-23 4:35am View

That would be a question for the manufacturer of whatever that is

CHill60 13-Dec-23 10:18am View

5'd

CHill60 13-Dec-23 5:41am View

A combo-box starts in a collapsed state and expands to show the list of items - are you sure you mean combobox and not ListBox?

CHill60 11-Dec-23 6:09am View

I agree with Gerry's comment, but would also add you need more than one table. Store information about an "individual" with all kinds of individuals stored in there. Have another table for roles - list the roles and include characteristics of each role if appropriate. Between the two you need an intersection table that links each individual to the roles they can perform. This allows for a single individual to perform more than one role. Depending on the complexity of your system you might also want a table of Permissions with an intersection table between Roles and Permissions

CHill60 8-Dec-23 12:09pm View

This is a comment, I assume against the original question. The link for comments is "Have a Question or Comment?" next to the post you are tring to comment on.
Please don't post comments (or further questions) as a "solution" to the original post

CHill60 6-Dec-23 3:14am View

This sort of thing should be done as part of populating the listview rather than row by row afterwards

CHill60 1-Dec-23 4:12am View

This is a quick answers forum not a teaching site and most certainly not a code writing service. You are also unlikely to find anyone willing to do this in a language that has been out of support for decades.

CHill60 1-Dec-23 4:07am View

Have you tried actually looking for some?

CHill60 28-Nov-23 9:38am View

Show us what you tried. And you will need to share the table schemas, some sample data and your expected results

CHill60 25-Nov-23 19:19pm View

I vaguely remember telling you before that this is not a solution. Paranoid you might be, but I now think you are a hacker

CHill60 25-Nov-23 19:17pm View

You really have not stated your problem clearly I'm afraid. You have dumped a lot of code here without explaining what your problem is

CHill60 24-Nov-23 11:44am View

An uncommented code dump is not a solution

CHill60 24-Nov-23 11:04am View

You've forgotten to tell us what the problem is

CHill60 23-Nov-23 5:36am View

This is not a solution. You can bookmark this question - although it is unlikely to be updated

CHill60 22-Nov-23 6:25am View

You are meant to write the code yourself. Give that a try and come back with a specific question

CHill60 20-Nov-23 9:51am View

Probably because it was reported too many times as a repost. If you need to change your question in any way you can use the "Improve Question" link next to it - if it is not visible then hover a mouse pointer over your question

CHill60 20-Nov-23 9:21am View

No-one is going to wade through that amount of code. Edit one of your questions to only include the relevent code and to describe what is currently happening. Delete your other question

CHill60 20-Nov-23 4:01am View

If you have a question then use the red "Ask a Question" link at the top of the page. Be sure to read the posting guidelines.
Alternatively you can comment on a solution by using the "Have a Question or Comment?" link next to it.
Your post is not a solution to the original question

CHill60 20-Nov-23 3:59am View

What have you tried? Share your code

CHill60 20-Nov-23 3:58am View

Whilst syntactically correct

SELECT * FROM ...

is not good practice. You should explicitly list the columns you want to extract

CHill60 20-Nov-23 3:55am View

If you want to comment on a post use the "Have a Question or Comment?" link next to it. This is not a solution to the question

CHill60 17-Nov-23 7:03am View

This is not a solution. If you want to comment on a post use the "Have a Question or Comment?" link next to it, or use "Reply" next to a comment

CHill60 16-Nov-23 5:35am View

:laugh: I do but I've loaned it out to a passing circus

CHill60 16-Nov-23 4:49am View

What are the issues??

CHill60 13-Nov-23 9:09am View

Like I said 3 hours ago. Most of us will not click that link whether it's in a comment or in the body of your question. Clarify your problem and share a description of your tables

CHill60 13-Nov-23 5:53am View

Nope. Many of us are at work so won't be downloading anything. Just share details of your tables in the question - use the Improve question link. But as Dave said "It's not clear at all what you're asking for or what the problem you're having is."

CHill60 10-Nov-23 11:28am View

Copying another's work and reposting it as your own is plagiarism and is not tolerated on this site

CHill60 10-Nov-23 8:08am View

Does the table really look like that?

acctnum(c1)    note (c2)   srno
12             abc          1
               efd          2
               xyz          3
15             pqr          4...etc

or does it look like

acctnum(c1)    note (c2)   srno
12             abc          1
12             efd          2
12             xyz          3
15             pqr          4...etc

Because if it doesn't look like the 2nd example it will be incredibly difficult to get your data back again

CHill60 10-Nov-23 8:06am View

Rarely, if ever, do you need to use any kind of loop in SQL - it is set-based. See my article Processing Loops in SQL Server[^]

CHill60 9-Nov-23 7:02am View

Your question is not clear. If you assign the text of a textbox with jobtitle it will be overwritten with each st2 in the list

CHill60 9-Nov-23 4:13am View

What is wrong with your code? Apart from using default names for controls so we have no idea what they are meant to be

CHill60 9-Nov-23 3:46am View

I have updated my solution with a simple example and a link to some tutorial resource.

CHill60 8-Nov-23 3:28am View

Exactly how are you "loading" data and is the SourceData table really "new" each time?

CHill60 1-Nov-23 7:56am View

An uncommented code dump is not a solution - and this is not VB.NET!

CHill60 1-Nov-23 7:55am View

Well firstly if you search by name, what are you going to do if two students have the same name (very common). But you still have not stated what it is you want from US.
If you want to get the record where either the ID card or the University Card has been presented then use an OR clause in your WHERE clause in your SQL statement
e.g.

WHERE @IDNO = idcard OR @IDNO = unicard

CHill60 1-Nov-23 4:27am View

You've stated what you want but haven't said what the problem is

CHill60 31-Oct-23 4:04am View

An uncommented, unformatted code dump is not a solution, no matter how old the original question

CHill60 31-Oct-23 4:02am View

If you have a question then use the red "Ask a Question" link at the top of this page. Do not post your problem as a solution to someone else's question

CHill60 30-Oct-23 5:37am View

Stop posting the same question over and over again. Update your original post

CHill60 24-Oct-23 7:56am View

Given that this company provides training in AWS this is definitely a spam set up

CHill60 24-Oct-23 7:31am View

If you want to reply to a post use the "Have Questio or Comment?" link next to it. The member will be notified of your response.

CHill60 18-Oct-23 4:48am View

Ha ha - I couldn't follow the link so I really appreciate your description. Hilarious!

CHill60 18-Oct-23 4:32am View

Be aware you are likely to attract downvotes for this response - it's a very old question and the solution was actually in the comments - the same solution as yours

CHill60 18-Oct-23 4:28am View

Doing someone's homework is never a good idea, especially over a year late. Your unformatted solution won't even compile

CHill60 18-Oct-23 4:21am View

This is an English speaking site. Please use English Language only.
Este es un sitio de habla inglesa. Utilice únicamente el idioma inglés.

Please put the details of your question here, not a link to an external site.
Coloque los detalles de su pregunta aquí, no un enlace a un sitio externo.

Use 'Improve Question' link to improve your question.
Utilice el enlace 'Improve Question' para mejorar su pregunta.

CHill60 13-Oct-23 8:23am View

See my comment to Solution 5 - this is not a Solution to the original post, it is a comment (in which case use the "Have a Question or Comment?" link. This is likely to get "down voted" so will lose points. If it is reported as "Not a Solution" then at least it will disappear and you will stop losing points because of it. Or - delete it yourself.

CHill60 12-Oct-23 7:16am View

Has this ever worked on Windows 10 with this verison of Outlook? If so then a recent Office update has probably rendered Outlook incompatible with VB6 (See Richard's comment on how long since VB6 was supported)
If it has never worked with this set up then your program has reached the end of its life and must be replaced with one written in a more modern language

CHill60 9-Oct-23 7:25am View

This is not a solution to the OP's problem - in fact it will demonstrate exactly the same issue unless run in a console window.

CHill60 6-Oct-23 7:21am View

You need to provide a lot more information than this. For starters - which multicolumn treeview? Which "files" are you downloading and from where? What do you need to do with the treeview?
Remember we cannot see your screen, access your HDD but especially, we cannot read your mind nor see what you are seeing

CHill60 6-Oct-23 7:19am View

Reasons for my downvote:
1. Doing someone's homework for them does not actually help them
2. The homework was due over a year ago
3. Your solution is inaccurate - it produces the results

0 is SYAWLA
1 is KOOL
2 is on
3 is the
4 is THGIRB
5 is EDIS
6 is of
7 is !EFIL

largely because you are reversing every word that is longer than 3 characters rather than just alternate ones

CHill60 5-Oct-23 9:53am View

Give us the exact error message you receive and when you get it

CHill60 13-Sep-23 9:52am View

Buy a book

CHill60 13-Sep-23 5:55am View

That link is highly suspicious, I recommend using well known file repositories such as github.
Also - a code dump without commentary is not a good solution. Also - did you notice that the question is 9 years old? Also did you notice you haven't actually added anything new to the thread

CHill60 8-Sep-23 4:39am View

What is your actual question?

CHill60 7-Sep-23 12:08pm View

Share the code that you have tried

CHill60 7-Sep-23 10:40am View

Please do not post comments as a solution to a post. Use the "Have a Question or Comment?" link instead. This is an English language site, please post in that language only.

CHill60 7-Sep-23 4:44am View

You're attracting a lot of downvotes for this solution - here are the reasons for mine
- you're dropping a table without first checking it exists.
- You've assumed [OrderDate] is a Date - it clearly isn't, which is the original problem
- however, there is no need for that Case clause - just use

upper(convert(char(3), datename(month, [OrderDate])))

- having a temporary table to do this is overkill. Just have the right column types in the first place.

CHill60 6-Sep-23 13:56pm View

I know. If you have a working solution for the OP then post it

CHill60 5-Sep-23 4:47am View

If you are still having problems with this then please give a worked example of your expected results and share the code you have tried so far

CHill60 5-Sep-23 4:24am View

An uncommented code dump is not a solution

CHill60 1-Sep-23 9:34am View

I have just tried to recreate your problem using the code you have supplied and I am not going to persist any further. Why? Because I get errors trying to run your code to produce your tables - things like defining an IDENTITY column but then providing the value (without letting me know I need to turn IDENTITY INSERT on). Then when I fix that, I get a conflict with a foreign key constraint.
I commend you for providing the code to recreate your sample data - but please make sure it works. I do this in my spare time at work and my lunch hour just ran out - I won't come back to try again.

CHill60 1-Sep-23 9:16am View

Reasons for my downvote - this solution is so vague as to be useless, the OP accepted the two previously posted solutions implying that they address the problem and the question is 9 years old

CHill60 1-Sep-23 5:04am View

Somewhat off-topic for the QA forum - you might serve better posting on the Design and Architecture Discussion Boards[^]

CHill60 31-Aug-23 7:19am View

You're going to have to explain your problem more clearly

CHill60 30-Aug-23 10:12am View

What version of Python are you using?

CHill60 30-Aug-23 5:45am View

If it's a corporate PC with restrictions on running scripts you are unlikely to be able to run batch, powershell, vbscript or python. We have a similar situation here.
You could try translating it into VBA and running it via Excel (or Word)
Couple of other words of advice:
- "it doesn't work" doesn't tell us anything - be more specfic about your problem
- you lost me at "Chatgpt translatet me, the code into batch"
- instead of flailing around grabbing stuff of the internet and getting AI to "translate" it for you, try stating what it is you are actually trying to do

CHill60 23-Aug-23 6:36am View

Highly unlikely just doing that would solve anything, especially if the wrong connection string has been used. Apart from that SQL 2022 wasn't available to the OP in 2017

CHill60 17-Aug-23 10:07am View

If you are still looking for an answer to this problem then please correct your example and explain in better detail how you are calculating your expected results. Also show us what you have tried

CHill60 17-Aug-23 10:04am View

If only! VB6 - the "gift" that keeps on giving, and on, and on ... :laugh:

CHill60 11-Aug-23 6:57am View

Can you show a worked example of your expected results and share the code you have tried so far

CHill60 10-Aug-23 3:25am View

You have modified the code - so what? Attempt 1 or Attempt 2? What did the OP do "wrong"? A code dump without explanation is not a solution

CHill60 9-Aug-23 10:45am View

I have!

CHill60 9-Aug-23 10:01am View

This makes no sense, can you explain clearly

CHill60 8-Aug-23 10:26am View

"you cant make it" - except you can. Look at link in Solution 1. Apart from that you haven't added anything to this thread by adding an additioal "solution"

CHill60 8-Aug-23 8:19am View

I think you might need to include

AND p.wire= t.wire

to get your expected results

CHill60 8-Aug-23 3:53am View

Done!

CHill60 7-Aug-23 4:15am View

If you want to ask a poster a question use the "Have a Question or Comment?" link next to their post. This is not a solution to the original post.
If you have the same problem then use the links in Solution 1

CHill60 4-Aug-23 7:42am View

If you want to comment on a solution use the "Have a Question or Comment?" link next to - the poster will be notified. This is not a solution to the original post.

CHill60 1-Aug-23 4:57am View

So what is your question?

CHill60 1-Aug-23 4:56am View

We are more than welcome to help, but I'm afraid this post does not constitute a valid question.
When you clicked on the ask a question link you were shown posting guidelines:

A few simple rules when posting your question.
1. Be courteous. Everyone here helps because they enjoy helping, not because it's their job.
2. Have you searched or Googled for a solution?
3. Be specific! eg "How do I change the dialog colour?" instead of "My code doesn't work. Help?"
4. Tag your question appropriately.
5. If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.
6. Do not remove or empty a message if others have replied.
Your question may be edited or retagged by others. Anything inappropriate will be removed.

Also "not working" does not give us any information that will enable us to help you - Be Specific

CHill60 31-Jul-23 4:31am View

How will that help to resolve the path????

CHill60 28-Jul-23 10:55am View

And what is wrong with your code?

CHill60 27-Jul-23 4:51am View

You might also want to have a look at this CodeProject article Debugging Live Systems[^]

CHill60 27-Jul-23 4:49am View

Have you tried looking in the event log to see what's going on - and what do you mean by "session" - is this someone else's machine, or same machine different logon?

CHill60 27-Jul-23 3:39am View

Not making yourself clear at all, nor are you taking care with your dates (there is no '2023-01-02' in your sample data).
You said "I need latest or max(Date_intrans) where we have all four curve id (17,20,54,58) present for each month", are you now saying that once any curve id is absent then do not consider any date beyond that point?
E.g.
Date 1 - has all 4 ids
Date 2 - has only 3 ids
Date 3 - has all 4 ids
So required data is "Date 1" not "Date 3"

CHill60 26-Jul-23 8:52am View

Have you tried rebuilding it on that machine?
Included any libraries that may not be standard?
Not used anything that is now deprecated? (Saw someone the other day wondering why his code stopped working on WIN11 and he was trying to open Internet Explorer)
Where are you running it from?
Have you discussed this with your local IT team (thinking group policies may have changed?)

CHill60 26-Jul-23 8:48am View

But this is not a solution - so don't post it as one

CHill60 26-Jul-23 3:07am View

Quite possibly. But not without some sample data and expected results to clarify your problem - "account servicer" means nothing to those of us not working with your data

CHill60 21-Jul-23 11:13am View

Please do your own research

CHill60 21-Jul-23 6:39am View

Doing someone's homework for them does not actually help anyone. Also a code dump with no commentary is not a solution

CHill60 20-Jul-23 8:11am View

If you want us to see your replies then you have to use the "Reply" link. Until you actually tell us what the problem is then we cannot help you.

CHill60 20-Jul-23 7:49am View

"but it isn't working"/"none of them worked" is the least useful way of describing a problem. What exactly is happening that you were not expecting or is not happening that you hoped would.

CHill60 20-Jul-23 6:37am View

Exactly what was said in Solution 2 over a year ago.
If you are going to add solutions to old threads please ensure you are adding something new to the conversation and not just repeating the same information

CHill60 19-Jul-23 7:57am View

Read the comments - no SDK or API available to the OP

CHill60 12-Jul-23 5:44am View

"no OS change is involved" - there have been many OS changes in the last 20 years. OS Support for VB6 is no longer the default state, and any one of a number of Windows updates could "break" the environment. In particular the Windows support forums do contain incidents around the saving of bitmaps in Windows 10 and 11. It's time to let VB6 go.

CHill60 10-Jul-23 4:28am View

I have just run your code and it worked perfectly - for a run date of 28/06 it returned 27/06 as expected

CHill60 10-Jul-23 4:24am View

If you have a question then use the red "Ask a Question" link at the top of this page

CHill60 7-Jul-23 10:48am View

Not C# and nothing to do with the question

CHill60 6-Jul-23 6:35am View

If you have a question then use the red "Ask a Question" link at the top of the page. Be sure to read the posting guidelines you will find there

CHill60 4-Jul-23 6:04am View

If you have a question then use the red "Ask a Question" link at the top of this page. Be sure to read the posting guidelines

CHill60 28-Jun-23 7:23am View

This is not a code writing service and we also expect members to do their own research

CHill60 27-Jun-23 10:22am View

As an aside - if you want to reply to a comment use the "Reply" link next to it, if you want to comment on a post use the "Have a Question or Comment?" link next to the relevant post. It will be obvious to what you are responding and the poster will be informed of your response, but posting comments etc as a "Solution" will just confuse other readers and get you flamed.
You say you are baffled as to how it works - it will stop working when you hit a control that is not a combobox.
Regarding the issue - Graeme would not have see your error message as you commented on your own question instead of his solution, in the same way, readers will be confused as you what "Solution" 4 is referring

CHill60 27-Jun-23 8:19am View

5'd. I really don't understand why the OP would not want to use this elegant solution

CHill60 27-Jun-23 8:18am View

You are far better off checking the type of the control as per Solution 1 than relying on a naming convention. What if down the line you forget that rule? Or your work goes to another developer who starts their combobox names with cmb and no underscore?
If you really don't want to use the rather elegant Solution 1 (why not?) then you can always test using

If TypeOf (cTrl) Is ComboBox Then ...

but Solution 1 is the correct way

CHill60 21-Jun-23 9:31am View

I've pasted the code in full into my solution as a single code block. I've also retested it

CHill60 21-Jun-23 9:27am View

I even hightlighted what was missing! The line needs to read

;with Q1 as

It's a completely new CTE

CHill60 21-Jun-23 9:04am View

Nope - it was expecting ;with in front of Q1
(my bad - I missed the ; off the previous code snippet)

CHill60 21-Jun-23 7:23am View

You have to run all of the queries not just one by one. When I tested this I got exactly the results you said you wanted in your post.
CTE Q1 will not work unless you have also run CTE Q

CHill60 21-Jun-23 7:19am View

A code dump with no commentary is not a good solution

Comments by CHill60 (Top 200 by date)