> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4961?src=pr&el=h1) Report > Merging [#4961](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4961?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/6134c87f139b5578a667a3e929054b6e7ec73393?src=pr&el=desc) will **decrease** coverage by `0.01%`. > The diff coverage is `94.74%`.
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4961?src=pr&el=h1) Report > Merging [#4961](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4961?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/6134c87f139b5578a667a3e929054b6e7ec73393?src=pr&el=desc) will **decrease** coverage by `0.16%`. > The diff coverage is `49.18%`.
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4961?src=pr&el=h1) Report > Merging [#4961](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4961?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/6134c87f139b5578a667a3e929054b6e7ec73393?src=pr&el=desc) will **decrease** coverage by `0.16%`. > The diff coverage is `49.18%`.
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4961?src=pr&el=h1) Report > Merging [#4961](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4961?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/6134c87f139b5578a667a3e929054b6e7ec73393?src=pr&el=desc) will **decrease** coverage by `0.16%`. > The diff coverage is `49.18%`.
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4961?src=pr&el=h1) Report > Merging [#4961](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4961?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/6134c87f139b5578a667a3e929054b6e7ec73393?src=pr&el=desc) will **decrease** coverage by `0.16%`. > The diff coverage is `43.64%`.
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4961?src=pr&el=h1) Report > Merging [#4961](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4961?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/6134c87f139b5578a667a3e929054b6e7ec73393?src=pr&el=desc) will **decrease** coverage by `0.16%`. > The diff coverage is `43.64%`.
How to search for a list of words in a word document to check whether an entire excel workbook contain any of the listed words? If they do contain, how do count the number of times it occur?
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Set wrdApp = CreateObject("Word.Application")...
Could you upload a log at least at error level? You can find tge log settings and a link to the log folder in the Rubberduck settings.
It seems that something goes wrong when evaluating the can execute condition. If there are exceptions, they will be logged on error level and the item will be deactivated.
Could you upload a log at least at error level? You can find the log settings and a link to the log folder in the Rubberduck settings.
It seems that something goes wrong when evaluating the can execute condition. If there are exceptions, they will be logged on error level and the item will be deactivated.
@this That's for remote queries, which, IIUC, means "how long to allow a query to run on a remote server before timing out". Is that how the server is looking at this? I think that's how I was reading that yesterday...
and, in any case, I'm not hitting the default 10 minute timeout:
> Inspections\Concrete\ImplicitByRefModifierInspection.cs(37,1): warning CS1570: XML comment has badly formed XML -- 'Expected an end tag for element 'example'.'
normally we would use a VS add-in or a nuget package but neither are friendly for getting setting up quickly for what is essentially a project-specific analzyer
hrm... running the query (stored proc modified to execute) from SSMS with Query Plan and Statistics on. It's run for 29 minutes without going to completion or timing out.
> Warning: The join order has been enforced because a local join hint is used. Msg 300, Level 14, State 1, Line 40 VIEW SERVER STATE permission was denied on object 'server', database 'master'. Msg 297, Level 16, State 1, Line 40 The user does not have permission to perform this action. Msg 300, Level 14, State 1, Line 333 VIEW SERVER STATE permission was denied on object 'server', database 'master'. Msg 297, Level 16, State 1, Line 333 The user does not have permission to perform this action.
TBH, I'd rather do it with DMVs since with DMVs, you can filter it much easily than with lame stored procedures. However, those have the appeal of being easy to execute.
Nope, you ain't. You'll have to content yourself with built-ins, then.
Come to think of it, the security might filter too much from the sp_** or DMVs, so you'd be blind, too.
A PTQ can contain up to 36K characters in its SQL statement. So you would be able to insert several lines (e.g. INSERT INTO ... VALUES (...), (....), (....), (...)...
I have an algorithm to create a version for an entity and then I save that version against below 2 entity:
1) Variant
2) Category
Below is the flow of my method execution :
1) Tranformation logic
2) Version
Code :
public class Variant
{
public int VariantId { get; set; }...
I can only echo what candied orange already said in your discussion. The problem you're solving with the code is not clear enough to give specific advice...
I wrote this code and it worked well as I want. To look for some values and copy paste the result to another sheet (online for selected column)
I want to know the opinion from this community regarding my code
I just learned the VBA for 1 week. Hope you can share some good advice, thanks :)
Op...
After the version is created,I want to save version againts 2 entities Variant and Category.Now both this are database operation hence I wanted to seperate out database operation in another class hence I have created VariantRepo and CategoryRepo.
As you can see here in this code : Once the version is created :
variantVersion = _entityVersion.GetVersion();
I call below method to update version against variant in my Variant_VersionMapping table Same goes for Category where i update version against category in my Category_VersionMapping table using below method :
@ILoveStackoverflow I don't understand why you're trying to avoid coupling the classes when you hardcoupled the business logic. What you want is to have the same version apply to a number of Categories and a number of Variants. Subdividing database operations by Entity is a cargo-cult pattern and the issue is that you're trying to separate something that affects two entity types at once into two classes. Don't do that
Either the Version changes should be in their own database interaction class or the business logic needs to fit the current design. Since the second is probably not what you want...
following tutorials it's easy to forget that the goal of repository pattern is to decouple data access from the rest of the application logic, so you can test the application logic without hitting the database.
I'm not sure I 100% understand the problem but I'm struck with the impression that the database operations needs to be encapsulated into a stored procedure.
So instead of trying to effect changes in code and then replicate it to database, I'd rather effect the changes in database and replace the objects that were affected by the change in database. That also allow you to get a bit more immutability with your entities.
I built a data warehouse here at work, and my Customers table is a slowly-changing dimension; the natural key includes the customer code and what you would have as the version (I'm using EffectiveFrom/EffectiveTo datetime columns, but the result is the same: any given customer entity can have many PK IDs / "versions")
when I need to pull a list of all customers, I select from a LastImageCustomers view that selects all rows where EffectiveTo is null
i.e. any application written against that database effectively ignores the "version"
but, my customers come from some ERP system, not an application
so the version handling is the job of some overnight ETL process
slight disagree here - if I pull all orders, I don't care what version of customer 1234 each order was made against - but if I only pull orders made agaisnt the last image of a customer, my reporting isn't seeing the whole picture
I think what @ILoveStackoverflow will want to do is focus on the separation between data operations vs. application operations. The application should be simply making requests to the database to make data changes, and accept the objects as-is from the database.
you want your app to only care about a Customer entity. then when you update that entity, or create a new one, you want to pass that entity object to a method that will populate the parameters to some SaveCustomer stored procedure.
SaveCustomer then determines whether the record is new (and thus it's a simple insert), or if it's modified - and then it determines whether to make a type-1 or a type-2 update, and proceeds with it
type-1 is just a plain old update that overwrites the "last image" record
type-2 invalidates the previous "last image" and insert a new one, that becomes the new "current version"
what determines type-1 vs type-2, is what fields have changed and which ones you want to keep a history for
in my case I care to keep the history of what sales rep a customer is associated to
so if I update a customer and its sales rep has changed, type-2 update logic kicks in
but if it's only their contact email that changed, it's a type-1
historical records are never, under any circumstance, updated
Imagine it's a bit too late for the current application, though. Seems nice since it moves all the logic out of your stored procedure so you can just do more simpler queries.
A great resource to pick the correct HTTP error code for your API:
http://www.codetinkerer.com/2015/12/04/choosing-an-http-status-code.html
An excerpt from the article:
Where to start:
2XX/3XX:
4XX:
5XX:
@Vogel612 I hate that. I've even seen developers who go "OMG I got 400! How will I know what went wrong! PLZ fix and give me 200 + error!!!!11133lj3rfldjlkdgww"
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4961?src=pr&el=h1) Report > Merging [#4961](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4961?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/6134c87f139b5578a667a3e929054b6e7ec73393?src=pr&el=desc) will **decrease** coverage by `0.16%`. > The diff coverage is `43.64%`.
I'm missing something. when I sent a "manual" HTTPS request against the REST API yesterday, I was able to tell it to use Tls12 for security protocol... can't seem to find where it's documented for RestEase
I have an Autodesk product, Fusion360, installed along with MZTools 8.0.0.1644 and Rubberduck 2.4.1.4627. I keep getting the ""InvalidCastException: Unable to cast object of type BClassicExtensibility.VBProjectClass' to type 'Microsoft.Vbe.Interop._VBProject" error even when I don't have Fusion360 running. The solution stated was to unload/load MZTools and Rubberduck using the Add-in manager, but what does that mean? I tried manually loading MZTools and Rubber
I would suggest that to make outbound requests like WebRequest and HttpWebRequest safe, you should follow steps to disable SSL fallback as detailed in my question at stackoverflow.com/questions/26389899/…. Basically you run this line of code first: System.Net.ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12; As I understand it, the registry fix detailed in this answer only applies to inbound connections. — Jordan RiegerFeb 16 '15 at 20:17
> Starting with the .NET Framework 4.7, the default value of this property is SecurityProtocolType.SystemDefault. This allows .NET Framework networking APIs based on SslStream (such as FTP, HTTP, and SMTP) to inherit the default security protocols from the operating system or from any custom configurations performed by a system administrator.
> The .NET Framework 4.6 includes a new security feature that blocks insecure cipher and hashing algorithms for connections. Applications using TLS/SSL through APIs such as HttpClient, HttpWebRequest, FTPClient, SmtpClient, SslStream, etc. and targeting .NET Framework 4.6 get the more-secure behavior by default.
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4961?src=pr&el=h1) Report > Merging [#4961](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4961?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/6134c87f139b5578a667a3e929054b6e7ec73393?src=pr&el=desc) will **decrease** coverage by `0.16%`. > The diff coverage is `43.64%`.
baffled by what poodles have to do with HTTP security...
back to my original timeout problem - it may be an issue with Truncate Table x. I'm trying to load my data by hand now (it's time to get this report run by any method necessary) and I'm trying to truncate the temp table before loading the next set of data and it's been executing for 5+ minutes...
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4961?src=pr&el=h1) Report > Merging [#4961](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4961?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/6134c87f139b5578a667a3e929054b6e7ec73393?src=pr&el=desc) will **decrease** coverage by `0.16%`. > The diff coverage is `43.64%`.
modifies the SP to Delete from so the stupid thing will work for now...
and... now it's spinning on ALTER PROCEDURE.
ARGH!!!!!!
these things shouldn't take sysadmin rights should they???
seriously??? In SSMS I scripted the SP as Create to new window, change the Create to Alter, changed the Truncate table x to Delete From x, and now the Alter won't run.
How to search for a list of words in a word document to check whether an entire excel workbook contain any of the listed words? If they do contain, how do count the number of times it occur?
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Set wrdApp = CreateObject("Word.Application")...
I have an algorithm to create a version for an entity and then I save that version against below 2 entity:
1) Variant
2) Category
Below is the flow of my method execution :
1) Tranformation logic
2) Version
Code :
public class Variant
{
public int VariantId { get; set; }...
I wrote this code and it worked well as I want. To look for some values and copy paste the result to another sheet (online for selected column)
I want to know the opinion from this community regarding my code
I just learned the VBA for 1 week. Hope you can share some good advice, thanks :)
Op...
A great resource to pick the correct HTTP error code for your API:
http://www.codetinkerer.com/2015/12/04/choosing-an-http-status-code.html
An excerpt from the article:
Where to start:
2XX/3XX:
4XX:
5XX:
VBA Rubberducking
VBA Rubberducking