Comments by Wendelius (Top 200 by date)

Not sure if I understood your comment, but have a look at the updated answer

If you don't want to use separate replace-calls, have a look at https://www.codeproject.com/Tips/5382272/Small-function-to-replace-characters-with-SQL-Serv

updating the row should work fine so what is the issue with that?

I see that you removed the underscore but what about the actual question. Is the suggested subquery correlation what you're after?

WHERE pur.pro_id = sales.pro_id

Try posting the original data in the table and an example what the query should return. Without this info there's not much we can do

What is the error you're referring to?

What is the exact problem you're having, getting an error message or something else?

Earlier you wrote that the expected result is

I expect
cod_orc quantidade preco_unit iva totalciva1
16 1 1 23 1,23
47 1 1 23
47 1 1 23 2,46

If that's not the case can you post an example what is the expected result?

Do you have any example data to try with?

If I run the query with your example data, the result looks correct

TotalCIVA1
3,69

What would you expect it to be?

Any example data?

What is the logic for distributing the amount? Why slno's 6,7, and 8 are selected and why the amount is not evenly distributed?

As far as I can see, the problem wasn't in the generation of the SQL, instead it happened while reading from the database.

As the error message states, the problem occurred in conversion from datetime2 (data type in SQL Server) to datetime (type in C#). So if that's the case, the problem wasn't in inserting but in reading.

Not sure if I understand your question correctly but if you want to aggregate multiple columns you need to separate them. See the added example

The error means that the column that you're referring to, needs to be indexed, preferably a primary key or unique. The same message also occurs when the data types do not match in corresponding columns.

Looking at the fk definition again, is it intentional that you refer to tools.tool_id?
How that column differs from tools.id which is the primary key? I take it tools.id should be referred or otherwise you need to build an index on tools.tool_id, preferably unique.

It seems that id column in tools is BIGINT(11) while tool_id in location id BIGINT. Try using matching data type i.e. either BIGINT(11) or BIGINT in both places

The queries seem to return data about bookings, not about available rooms. Is this only a portion of the actual query?

What is the specific problem and question you have?

Please use the "Improve question" function to give more details on your requirements and what problem you're facing.

Yes that's a length limitation for an index. Based on the SQL statement you've shared I see no reason to include value in the index.

Instead I'd index columns PartFamilyID and Key together as previously suggested.

A quick check, in the Crystal report, do you have Can grow property enabled for the object?

Can you elaborate? Just tried running it in SSMS and works the new lines are correctly in place.

Please post relevant parts of the code that are causing this error.

Glad it helped :)

Well basically you have the same kind of error here. If multiple rows are updated the select statement fails since a single variable can only hold a single value.

Another thing is the condition. In comparison you have used LIKE which is for characters but the variable is defined as int, so there's probably some kind of mismatch.

Looking at the error message in raiserror, it looks that updating the year is prohibited so in this sense you either need to change the logic in trigger you posted in the original question (preferred way) or disable the trigger when updating the data (may lead to problems).

Disabling a trigger is not mandatory. Most likely the trigger is preventing you from updating the rows. What does the trigger Update_StavkaKataloga_GodinaKatalog look like?

Glad it helped :)

What is the error message you get?

Thanks

Try using the debuggers ability to show the collections and their content. This will help you to see in which collections where the controls are located in,

Glad to be of service :)

You have a sleep in the code:

time.sleep(SELL_DELAY)

and the value for SELL_DELAY is defined as 4

Please use the "Improve question" link and edit the code to be inside a pre tag (code block). This ensures that the indentation is shown correctly.

The best way to get answers is to post a new question at https://www.codeproject.com/Questions/ask.aspx[^]

Nice explanation!

Can you post an example of the source data and the desired result?

Sorry, that was a copy paste type I had. adding the Text... is needed, just like in your original example.

Please post the relevant code related to the question

I don't think it's either bad or good. If this naming conventions suits the requirements you have, it's probably a good way to go. Just keep in mind that the maximum length for the name is 63 bytes by default.

At the moment the question does not make sense. Please use "Improve question" to explain the problem in more detail, preferably with an example.

If I understand your question correctly, you're asking help with the select statement. In order to do that we'd need some example of the source data, how does it look like and what kind of output do you require, again some example data.

Without the examples it's hard to understand the question and to provide some kind of suggestions for the select statement.

Okay, that's the select. What about the example data, how would the source data and desired output look like?

Can you provide an example of source data and desired output

If I understand your question correctly, you want to set the value of the parameter from the application? If that's the case, you can use SetParameterValue. Here's a link to the version that was used with MS ReportDocument.SetParameterValue Method (String,Object,String) (CrystalDecisions.CrystalReports.Engine) | Microsoft Docs[^]

Storing a calculated field in the database should not be done. Instead the calculation can be done when the data is fetched or shown, as in your case.

Did you go through the tutorial link? It shows how summary fields are selected in a crosstab

Can you provide an example data? Use the "Improve question" button to modify it.

At the moment the question does not make sense. Use improve question to give more details like, what is the requirement, what have you done so far, and what issue you're running into.

Yes, one is the default quantifier so it's not mandatory to include it.

Glad you got it working!

Which (nuget) package you're using?

Use parameters, please have a look at the article I linked.

Not sure what you mean. The tutorial shows how to organize the report. The data can come from a SQL database, a dataset in the program etc. That depends how the connection on your report is defined.

I know the feeling, but compared for example to SO this site is much more positive and people feel more welcome. I truly hope that positivity in overall remains the main feeling here. And we always have the "Not a question" option :)

My vote of 1: I don't believe that sarcasm is the correct approach.

Try the following
1. Create a completely new folder, for example d:\new_test
2. Copy the database you use to this folder
3. Define your connection string as follows connectionString =@"Data Source=.\SQLEXPRESS;AttachDbFilename=d:\new_test\Product.mdf;Integrated Security=True;User Instance=True"

Now try running the program a few times, ensure that the correct database is used, the one in d:\new_test\.

Does the data still disappear?

You're correct about the first solution and as I said it was a misunderstanding.

However, I don't see the problem with the recursive code, based on the info from OP why would the correct result be 3321110? As far as I understood, one is not allowed to reorder every number, just numbers as they are provided in the array.

Thanks!

Yes, that's kinda brute-force approach. Simply test all possible combinations and pick the greatest number.

I recommend using the debugger to go through the execution to fully understand what happens with the code.

Okay this was a bit different from what I understood. Have a look at the updated solution

You've missed a lot :)

Yes, it took the greatest number (101) and added the least number (1) before it. Wasn't this the requirement?

Don't remove it from the directory, remove it from your project. This ensures that the database is not copied each time the project is built.

If needed, you can copy the database to a whole different location and use that location in your connections string. This could clarify the situation.

This was just a small example, you need to do any necessary changes for this to match the requirements you have.

As said, you probably have the database in your project and that's why it's also in \bin\Debug directory. Try excluding it from the project and use the path D:\Cricket\Product Entry\Product Entry in your connection string.

And what does convert.ToDateTime do, is it your own class/method?

Because the way triangle is calculated, it's never less than i, so the elif section is never fired

One way to think about this is to let the loop find if the number is triangular and return if it is. If the loop is ran completely and triangular number is not found then return false.

Consider the following

def isTriangular(x):
    i = 0
    for i in range(1 + i, x + 1):
        triangle = i * (i + 1) / 2
        if triangle == x:
            return True
    return False

print(isTriangular(24))

x is the parameter for isTriangular

In order to get to know a language, it's important that you try and experiment what happens with your code and when you change it.

For example try using the debugger and remove the elif section. Now when debugging, investigate the variables and see what happens.

Try using the debugger. When you run the code line-by-line you'll notice that you enter the for loop only once, the value of i is 1 and the result for triangle is 1. So in the first iteration you compare 1 (i) to 3 (x) which is not equivalent and the program returns 3.

Having that said, you need to reconsider the loop so that you test all relevant positions and once done you decide if the number is triangular or not

Glad you got it solved.

Exactly, it's nor forbidden in newer version. Can't remember the exact version where using AS become possible but before that it was not supported.

As already pointed out, don't. Its a very bad way and leads to more and more problems. Instead, use IDENTITY. That's the way SQL server is supposed to be used.

When you run the code, are you sure that label1 really contains a date? Based on the error message the text in the label seems to be "label1".

Place a breakpoint on that line and investigate the text property of label1. What does it contain, could it be that you haven't yet used the date time picker and the label1 text still contains the default value...

Using the debugger, on what line you get this error? Can you post the current code your using?

Do you get an error when running the code?

5ed

SQL Server 2005 had it's own setup just like newer versions. If you have SLQ Server 2005 installed, try locating it's setup, run it and remove Management Studio from selected components.

However, note that support for SQL Server 2005 ended 10 years ago so I'd strongly suggest moving to new versions.

Glad you got it working!

Thanks

Binding is not the same as joining. In your query you join the tables but once you have fetched the data, you bind it to the user interface, that's when the problem occurs.

It's easy to test, comment out the following line from your code

rptrsize.DataBind();

Now when you run the program it probably runs okay but no data is shown in UI. This happens because now you haven't set the data source and binding does not happen. If you add the row back, the error occurs.

If this is correct, then it proofs that the problem is a mismatch between the data column names (the column in the data table) and the names used in UI binding (Eval("catname")). In other words, there is no column catname in the data table.

What is the error you're getting?

One thing to ensure is that you have proper indexing in place. For example check that ID field is indexed in products table.

For more information about indexes, see CREATE INDEX[^]

Thanks

Not sure I still understand. Query2, query3 and query4, they all return only one row and a single value. On the other hand query1 returns multiple rows.

Can you post, what each query returns when run alone and how would you like to combine these results (the final result set)?

Could you post some example data how the result should look like.

You're welcome :)

That doesn't look what you would need Consider the pseudo example added to the solution

Could elaborate more, what is duplicate compared to what?

Thanks

Thank you!

If you already have the system then details about that system would be needed to answer you're question. Based on the information you're provided we cannot know where and how the data is stored or how it could be queried.

Thank you!

It probably would be easier and more safe to use builtin function HAS_PERMS_BY_NAME. See HAS_PERMS_BY_NAME (Transact-SQL) - SQL Server | Microsoft Docs[^]

Yes, just remember to check both public roles, the server role and the one in the database. If they contain no privileges and no other roles are granted to the user then no privileges should be active until you grant new roles.

Of course, it's always good practice to test and verify the situation :)

Since this is a bit different issue than the original question, I believe it's best if you post a whole new question with the relevant code parts and explanation.

I guess that depends on how you want to organize your code. There's no single 'correct' place for the code.

Is the mysqldump utility installed on the same computer where you're running php?

Nice instructions!

if you need to match the length, try using a computed, persisted, and indexed column, see Specify Computed Columns in a Table - SQL Server | Microsoft Docs[^]

For question 3, something like

;WITH
gfr as (
SELECT distinct r.familyid,
r.GroupID,
IIF(r.PortionKey='blank','',r.PortionKey) ,
IIF(m.PortionKey='blank','',m.PortionKey)
FROM extractreports.dbo.GetFinalResultParts r with(nolock)
inner join extractreports.dbo.GetFinalResultMasks m with(nolock) on r.groupid=m.groupid
and r.familyid=m.familyid
and (r.portionid = m.portionid or m.portionid= 0)
where len(r.portionkey)=len(m.portionkey)
),
cte AS (
SELECT t1.familyid,t2.GroupID,cast((t1.PartNumber+ t2.PartNumber) as varchar(200)) PartNumber,cast((t1.MaskNumber+t2.MaskNumber) as varchar(200)) MaskNumber
FROM gfr t1
inner join gfr t2 on t1.groupid=1 and t2.groupid=2
WHERE t1.GroupID = 1
UNION ALL
SELECT t.familyid,t.GroupID,cast((s.PartNumber+ t.PartNumber) as varchar(200)) PartNumber,cast((s.MaskNumber+t.MaskNumber) as varchar(200)) MaskNumber

FROM gfr t INNER JOIN
cte s ON t.GroupID = s.GroupID + 1
)
SELECT familyid,PartNumber,MaskNumber
into extractreports.dbo.getfinaldatapc
from cte
where GroupID =(select max(GroupID) from extractreports.dbo.GetFinalResultMasks with(nolock))
group by familyid,PartNumber,MaskNumber

I don't quite understand the second question

For question 1, see Create Foreign Key Relationships - SQL Server | Microsoft Docs[^]

What is the exact question you have?

Glad you got it solved

Not sure what you mean, but I suggest opening a new question to Q&A. Just remember to explain your goal and the issue you're facing.

As far as I know, it doesn't support MERGE.

You already have an example in your code. The line

if (prop!= 'tracks'...

checks if the property is named 'tracks' or not.

If you mean how the names are found out, there are multiple ways and situations, but have a look at for example Object.getOwnPropertyNames() - JavaScript | MDN[^]

I'm not sure, a nice death metal tune always brings the right mood :)

Based on that short excerpt I'm not able to say what should be done. Please post the whole SQL statement causing the problem.

In that case you need to return it from the subquery in order to be able to use it in sorting in the main query or add ORDER BY clause to the inline view. However, I'd suggest returning the value from the inline view since it allows you to combine sort criteria from multiple tables.

Just a note, if your query is as simple as the example, you don't need an inline view at all. Just use

select s.name,
s.age,
s.number
from Student s
order by s.SomeOtherColumn

That's good. As said that was only pseudo code to demonstrate the idea.

Glad you got it solved

The key here is to debug your code to get more information out of the situation. For example, have a look at A Detailed Guide to PHP Debugging – Stackify[^]

In order to solve the problem, details are needed.
What was the error message you got?

Some typo? If I run for example

a.SelectSingleNode("//*/DUEMONTH[contains(text(),'202103')]/../OVERDUESTATUS", ns)

I get a node and for that node the inner text is

InnerText "NAB" string

That explains, after setting the bind variables, continue normally with the statement

...
Cmd.Parameters.AddWithValue("@LoanAmount", TxtLoanAmount.Text)
Con.Open()
Cmd.ExecuteNonQuery()
Con.Close()
...

That was just part of your original code. Did you still have the connection open and ExecuteNonQuery etc as you have in your original post?

Well you can go back one level and then select the element you like. For example

a.SelectSingleNode("//*/DUEMONTH[contains(text(),'202102')]/../OVERDUESTATUS", ns);

But furthermore, I suggest you get yourself familiar with XPath. For example have a look at XPath Tutorial[^]

You can then use contains. For example
a.SelectSingleNode("//*/DUEMONTH[contains(text(),'202102')]", ns)

Note that depending on the structure and the data of the XML you may have zero, one, or multiple matches.

Thanks for the comment, it was well-grounded.

You're most welcome :)

See the updated answer

I can't quite understand why you convert number to strings and then back to numbers. Can you explain in detail what is the desired solution you're referring to?

That's correct. The control template is replacing the whole header control so you need to define the sizing ability in the template. See the updated example where Thumb Class (System.Windows.Controls.Primitives) | Microsoft Docs[^] is added

In more complex situations you may want to use control templates or create even your own UI classes. See the modified answer.

So in the process of learning C, where are you stuck at?

Yes, WindowState changes only the state of the form. For individual controls I'd prefer anchoring. See Anchor Controls - Windows Forms .NET Framework | Microsoft Docs[^]

Please do not repost. If you need to modify the question, you can use the green "Improve question" link just below the question.

You're welcome :)

Thank you

In terms of SQL you wouldn't update the record. Instead when the student moves to then next year, you add a new record. This way you have both current situation and the history in the junction table.

So for an individual student who is studying the third year the junction table could contain

studentid yearid
--------- ------
57 2019
57 2020
57 2021

It's a value of an object, not an object by itself. So you cannot reference tracks alone without specifying the object. However, you can investigate if the property is named tracks

Please do not repost, it's often considered rude. Give your original question a reasonable amount of time to collect answers.

Also if you have questions or comments on answers already given, you can use the "Have Question or Comment" button to ask for more clarification etc.

First of all this is an English speaking site so all questions and comments should be posted in English.

About your question, Microsoft PDF Printer -driver does exactly that. It saves the printout to a PDF file which is saved to hard disk. Even though it's a printer driver, it doesn't actually print anything, just saves the result.

Thank you :)

Are you sure this is the complete compiling code? You have an end if without corresponding if...

You're most welcome!

If you need to send a message to a person who wrote the solution, use the "Have a Question or Comment?" button to write a comment like this one.

If you're worried that the value gets too high, I don't see this as a problem. The max value for an integer is 9'223'372'036'854'775'807 so if you have 10'000 rows per day it would take roughly 2'526'951'242'973 years before you hit the limit.

So as said I'd still recommend not resetting the value since it introduces different kinds of potential problems. But if you decide to do that, you would use ExecuteNonQuery just like you do with delete.

Glad to be of service :)

Can't see the reason why the data is split into two tables but beyond that if you need to combine the tables, union would be the way to do it. Rest of the conditions seem to be related to your logic.

So why do you seek an alternative way, something wrong with current approach?

Yes, those tables contain the id's but how should Model be joined?

Can you post some example data from the tables and the result you would like to have?

What I mean is, what is the column that joins the rows in Model and Week? As far as I can see, there's no WeekId nor ProductionDayId

How Model is related to Week or ProductionDay?

No, in SQL conditions are not separated using a comma

You need to control when to put OR's or AND's into the statement. An easy way is to use a simple boolean variable indicating if first condition is already applied or not. Based on the variable value you then add OR or AND between the conditions.

Nicely explained!

You're welcome :)

What is the problem you're having?

Sorry, I read it wrong.

So does the table contain columns Id, Name, and Gender? How the id's would change? If I understand the description correctly, Id 4 is male in the data but in the result it's female...

In order for us to help we need to know the structure of the tables.

You're welcome :)

As far as I can see you should leave everything else as-is. I only modified the single query so you still need to declare the variables, have the if-else structure and so forth.

See the updated solution

I can't seem to find where exactly did you try to put the query (SELECT T0.[ItemCode]..)?

Can you post the whole query you currently have, the one that fails?

Looking at the answer in Solution 3, do you mean you want to display the content of a table. In such case you would use SELECT - MariaDB Knowledge Base[^]. If you need to modify the content then you would use
- INSERT - MariaDB Knowledge Base[^]
- UPDATE - MariaDB Knowledge Base[^]
- DELETE - MariaDB Knowledge Base[^]

Note, if you have a question concerning a solution, please use the "Have a Question or Comment" button. This is the only way the person who gave the answer, sees the comment

Good to know, thanks!

If both return data then have a look at the joining values from both result sets. An inner join would require matching key, please see Join (SQL) - Wikipedia, Inner join[^]

Could you describe, what you're trying to do?

Please be more specific. What do you actually mean with 'messed up'. If you want to create a script, what is the goal, what have you done, where are you stuck at etc.

Not sure if I understand your reply, but based on the error message you have a mismatch in the parameters compared to the call.

Can you post the definition for the PKG_MANAGE_OFFERS_TEST.CREATE_OFFER_T, In other words the header of the package

What does the definition of the PKG_MANAGE_OFFERS_TEST.CREATE_OFFER_T look like?

Very good point.

Thanks!

That's great! I'll have to read those articles at some point, always nice to learn new things.

A common reason for that exception is that the user running the application does not have access to the folder specified.

The important thing is the account that is running the code. For example if the code is run from a service under local system account then it has no access to network resources even though you may have those privileges when logged into the same computer using a different account. The same could happen also for example with ASP.NET applications if the service is run using an account without proper privileges or for example when using remote debugging.

So using appropriate account is one option and another option could be to impersonate user in code, see c# - Logon failure: unknown user name or bad password.error while accessing other server - Stack Overflow[^]

What is the error you get?

You're very welcome :)

Hello Espen and glad to hear from you! Long time no see :)

Thank you!

Locking is basically waiting in queue so I would prefer using the existing mechanism over creating a custom one.

The difference in locking the data during select is in the type of the locks. When the select is run and update lock is required, no-one else can update that specific record until you release the lock. With the default behaviour, even if you have selected the data someone else can start updating it and ask for X lock since only S lock is acquired during select.

It's quite possible that OP has left something relevant out. If that's the case, let's hope they give more info :)

Thank you :)

Seconded!

To find out the actual error returned by the database, use PHP mysqli_error() function / mysqli::$error - w3resource[^]

What is the error text it returns?

Also note that it's not a good idea to use MD5 for hashing. For more details, see PHP: Password Hashing - Manual[^]

When checking if the passwords match, don't hash them yet, use the input from the user as-is.

But after the check is complete, do not store the password as plain text in the database. Instead, hash it just like explained in the article I referenced.

It would be easier to solve the problem if you would post the whole statements you're trying to use.

You're welcome!

Why do you convert it to string? As far as I can see you don't need DATE_FORMAT. Just try something like

INSERT INTO MyTable (....)
SELECT STR_TO_DATE(dob, '%m/%d/%Y'),
...
FROM ...

Thanks!

Because the concatenation is inside an if statement, if p_Bot_Ids is null then the concatenation will not happen.

To answer if the query will fetch all rows, it will fetch the rows having id less than 200 because that is a constant condition.

What calendar control you're using? MonthCalendar?

Null check added

Thanks!

Depends on the selected collation, also in SQL Server. Also note that it is not operator specific, the same applies to equality etc.

For the type definition yes, but I understood that you wanted a table so next step would be creating an object table of that type.

Have a look at the examples in CREATE TABLE documentation.

It looks like you're still handling only one of the combo boxes in this event. Try changing the code to handle all the combo boxes in a single event

Private Sub ComboBox2_SelectedIndexChanged(sender As Object, e As EventArgs) Handles ComboBox2.SelectedIndexChanged, ComboBox3.SelectedIndexChanged, compbo.ComboBox2_SelectedIndexChanged

You're welcome :)

See the updated answer

You're welcome :)

You're welcome