Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Search
This is possible in SQL Server using the built-in @@ROWCOUNT variable. Something like this DECLARE @rows INT = 0; -- INSERT ... SET @rows = @rows + @@ROWCOUNT; -- UPDATE ... SET @rows = @rows + @...
I've just lowered the reputation requirement for both Edit and Edit Tag from 250 to 200. If folks here want it to be lower -- young communities have different needs, after all -- please make a met...
Okay, I'll be the contrarian. For this case, yes, I think a regex-based approach can be used to validate these properties. This approach will not guarantee that the provided input is valid HTML; in...
I think your edited post merits a new answer! You're right that you can make some sort of connection between addition, concatenation, and logical ‘and’—these are all operators that can be considere...
svn cleanup --vacuum-pristines can be used to clean up the pristine copies that might take a lot of space (version 1.10+). In Windows, TortoiseSVN client has the option Vacuum pristine copies to ge...
Note: this is an aggregate of the answer provided for this question. I want to get the LINQ equivalent of the following from SQL: SELECT .. FROM entity1 e1 JOIN entity2 e2 ON e1.field1 = e2.fie...
The quickest way is to make an equal join on two anonymous objects: var result = from x in entity join y in entity2 on new { x.field1, x.field2 } equals new { y.field1, y.field2 } Ano...
Can regex be used to check if input conforms to a very strict subset of HTML? The theoretical answer is Yes. The Javascript regex language is more than powerful enough to parse a recursive gramm...
One rather complicated way to get what you want (may be extended to multiple calls of statements and/or procedures) is through usage of MySQL Row-Based Binary Logs as explained here. This allows fo...
Cross posted to Meta: https://meta.codidact.com/questions/278198 If I try to provide a parent to a tag, it crashes with 500. Error Id = 6bd06f30-539d-4b88-8743-eca32a8465cd Tag to edit = htt...
Almost every table in my DB has triggers that fire on INSERT, UPDATE, DELETE and write the changes to a separate read only DB. This makes it possible to track changes and undo things well after the...
I hear the walk-before-we-run argument. I think this would be a good thing to try once we reach running speed, though. Personally, I don't like self-answered questions; I think they're an awkward f...
Having had the dubious honor of experiencing the closing process from the perspective of a question author, it seems to me that closing does not adequately communicate why the question was closed, ...
We rather need to make a close reason for every kind of off-topic reason. In this specific case, the reason could for example be Purely subjective question rather than the old "primarily opinion-ba...
To expand on my comment somewhat... In a question and answer format, personal questions like "What do you personally think?" don't tell to fare too well. There's not really any way to identify righ...
I have following setup: flutter plugin with an example app the plugin depends on a native library (flutter_plugin.podspec contains s.dependency 'native-lib', '0.1.0') for local development I pull ...
I have a function that which does some calculations. I would like to assign the result of the function to the global environment from within the function, how do I proceed? A minimal example: meanF...
First, such formatting is conditional, so there is no need for the IF functions here (nor, normally, in general for Conditional Formatting [CF]). Formatting is triggered when the response to a form...
Someone told me that I shouldn't write "NULL pointer" with capital letters, because a null pointer and NULL are different terms. And that NULL is a "null pointer constant". What's the meaning of th...
One aspect that helps with having a good balance is to have an enough number of users that help newbies ask good (or at least decent) questions. This is something reachable within rather small comm...
This is basically an unanswered code review request of mine from CodeReview Stack Exchange. I want to be able to log as accurately as possible, the time spent by a certain Web API action in an ASP....
This is a post of mine from Code Review Stack Exchange which did not get an answer yet. I am developing an Angular application that consumes an external REST API. I am using OpenAPI generator (Typ...
Assuming Check Box Form Controls in ColumnD, yes in OpenOffice Calc 4.1.4, though for some the process may be too tedious and entering say an x instead may be preferred. Unlike in Google Sheets for...
Some while ago a user of Web Applications asked after a function to avoid "an if/else just to handle negative numbers properly". Clarification provided was: Presently it round based on absolute...
An easy way (in LibreOffice Calc 5.4.3.2) is not to attempt directly to overwrite what is already present but to create the desired results with a formula in a different column, then replace the co...
