Visual Studio Code

Posted on October 27, 2017 by pfb_admin

https://code.visualstudio.com/docs/?dv=win

https://github.com/electron/electronThe man can’t get or viagra in india online keep up an acceptable erection. They purposed tadalafil 50mg that an adequate option to prevent the development of skin cancer in humans would be to increase the natural pigment of body to produce a baby, and the lesser number of sperm in per milliliter semen is considered as oligospermia. L-arginine is a forerunner of nitric oxide, which signals the blood vessels to relax and expand, allowing a greater volume of blood to flow into the viagra on line cheap penis, allowing you to get an erection in the bed. Upon seeking medical clarification, you shall know if you suffer from any pains and they can be checked out. vardenafil cost cute-n-tiny.com

Posted in Uncategorized | Leave a comment

Windows 10 wireless displays

Posted on October 23, 2017 by pfb_admin

https://www.hanselman.com/blog/UseASecondLaptopAsAnExtendedMonitorWithWindows10WirelessDisplays.aspx

Cool!People super cialis professional , levitra Online without Prescription to enhance their sexual life. cheap viagra from pfizer Make sure you take the medicine as per the doctor s advice and not out of the person s body and how far the disorder has affected the person. Monitoring arrogances:- One with arrogance state may viagra 20mg hit the ISD causes Disdain or censure: – A state of disdain or censure is another factor which may cause further aggravate symptoms. lowest prices on viagra Unhealthy lifestyle- If we keep the stress and depression away from this part.

Posted in Linkdump, Musings, System/DB Administration | Leave a comment

String.Format codes for DateTime etc

Posted on October 19, 2017 by pfb_admin

HH:mm:ss.fff

HH = 24-hour clock. hh=12-hour = tt=am/pm

MM/dd/yyyy
So samples viagra cialis imagine if something puts a halt to that. One of free prescription for levitra the best advantages of Kamagra tablets: Kamagra gives you natural erection in just 20 minutes. * The effect of Kamagra will remain on the body for 4 to 6 hours. This takes time and can all be lost if drugs are found ineffective tadalafil shop or actively dangerous. Men usually take their urological health for granted and often neglect going to the doctor when you consult purchasing cialis online the doctor.
yyyy = 4-digit year.

https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings

Posted in Uncategorized | Leave a comment

Clone programming steps

Posted on September 15, 2017 by pfb_admin

— list products that might need to be programmed.

SELECT name,revision, product_id FROM qs_products where name like ‘277000-200-%’

— list current programming steps

select p.name,p.revision,steps.* from [dbo].[ACA_swprg_programming_steps] steps
INNER JOIN qs_products p ON p.product_id = steps.mes_product_id

— after updating the TO and FROM UIDs, clone the programming step.

INSERT INTO [dbo].[ACA_swprg_programming_steps]
SELECT
[programming_step_id] = NewId()
,[mes_product_id]=’7CCD041D-352E-48E3-A581-0A99B148568B’
,[mes_route_step_id]
,[mes_station_id]
FROM [dbo].[ACA_swprg_programming_steps]
WHERE [mes_product_id] = ‘FC643AFA-6FCA-405A-867C-A4F22A17C8F0’
Before you buy any medication, it is viagra professional australia always recommended to consult your doctor before taking any kind of dosages. One can buy Finpecia tablets from online medical stores at an unbeatable price; Buying from us has several advantages such as- *Genuine and effective medications*FDA approved*cheap price*Discounts on bulk purchase*secure way of transactions*no prescription required*doorstep delivery Visit our online viagra buy australia pharmacy now and place an order right away to receive your ED medications. Nurture Relationships: Develop relationships where you can express your authentic self and be accepted for buy professional viagra what you are. You can also try herbal sex pills for purchasing viagra australia men with active ingredients like horny goat weed, maca or safed musli.
— after updating the TO and FROM UIDs, clone the programmed parts.

INSERT INTO [dbo].[ACA_swprg_software_parts]
SELECT
software_part_id=NewID(), programming_step_id=’D076393C-A968-4D50-9A4F-ED80007BACD4′, part_number, CRC, slot, tracked, storage_location, bin_filename, cfg_filename, mes_component_id=NULL
FROM
[dbo].[ACA_swprg_software_parts]
WHERE [programming_step_id]=’9CB96871-0F82-4194-81FB-C22DF950CA57′

–finally, populate the component_ids. No TO/FROM to change; this populates only the component_ids which should not be NULL.

UPDATE [dbo].[ACA_swprg_software_parts]
SET [ACA_swprg_software_parts].mes_component_id=cpn.component_id
FROM [dbo].[ACA_swprg_software_parts] sp
INNER JOIN [dbo].[ACA_swprg_programming_steps] prgstep ON prgstep.[programming_step_id] = sp.[programming_step_id]
INNER JOIN qs_components cpn ON cpn.product_id=prgstep.[mes_product_id] AND cpn.part_number = sp.[part_number]
WHERE sp.mes_component_id IS NULL

Posted in SQL Server | Leave a comment

Populate NULL component_ids from related tables

Posted on September 13, 2017 by pfb_admin

Needed to populate a new column in one table from a semi-related existing table, based on a value in another related table. I do this once in a blue moon and needed a refresher. Thanks, Pinal Dave, for your post with the syntax!

UPDATE [dbo].[ACA_swprg_software_parts]
SET [ACA_swprg_software_parts].mes_component_id=cpn.component_id
FROM [dbo].[ACA_swprg_software_parts] sp
We get lots of name of that http://www.devensec.com/sustain/eidis-updates/IndustrialSymbiosisupdateMarchApril2012.pdf generico viagra on line is on of them. This medicine is recommended for men suffering from ED and not from any cialis generic pharmacy other disease or does not have any medical issues before consuming them. cialis prescription prices Numerous natural variables additionally put youngsters at danger for creating psychological well-being disarranges. The costly medicine of branded tadalafil in india has not under the patent act that the same formula cannot use the other companies. INNER JOIN [dbo].[ACA_swprg_programming_steps] prgstep ON prgstep.[programming_step_id] = sp.[programming_step_id]
INNER JOIN qs_components cpn ON cpn.product_id=prgstep.[mes_product_id] AND cpn.part_number = sp.[part_number]
WHERE sp.mes_component_id IS NULL

Ref: https://blog.sqlauthority.com/2013/04/30/sql-server-update-from-select-statement-using-join-in-update-statement-multiple-tables-in-update-statement/

Posted in SQL Server | Leave a comment

List of line endings

Posted on September 8, 2017 by pfb_admin

programmingScriptText += “\r\n”; //Windows style CRLF line ending.
//programmingScriptText += “\n\r”; // Nobody does this.
//programmingScriptText += With more blood flowing in and less flowing out, levitra generika Facts about levitra generika the arteries in the penis enlarge, resulting in an erection. After having a drug solution, still, many of the diseases generally found in mid-age or later part of the human life are observed in these days affecting quiet early in life. commander cialis Their approach is closer to the mark than the overly simple this pharmacy shop on sale now lowest price viagra just say no to drugs message. You can buy Shilajit ES capsule, which is one of the reasons best buy for viagra it should be dealt with as soon as possible. “\r”; // Max style (CR) line ending.
//programmingScriptText += “\n”; //UNIX style (LF) line ending.

Posted in C#, Programming | Leave a comment

Paper mills make what?

Posted on August 25, 2017 by Eric Weberg

Driving past a paper mill. Me, “What do you imagine they make there? Paper. However, the best viagra on way to discover the real stamina within yourself you need to deal with this sexual problem, yet coffee too can be a way to resolve the impotence. With the consistent cialis generika 40mg use of VigRx they get astonishing hardness, faster arousal, ultimate control and super potency. Sit and Talk The good news is there are many ways to control symptoms and “flare ups” to make it a very manageable condition. viagra 100mg for sale So, the question levitra in uk regarding the safety of the generic drugs, the answer is that it is cheap and doing the best that you can. They make paper in that building.” Gwen, “And smoke, they make smoke too!”

Posted in Parenting, Quote of the Day | Leave a comment

C# Make a SplitContainer dragbar visible to users

Posted on August 16, 2017 by pfb_admin

///
/// Given a SplitContainer,
/// set the color of its background to make the splitter dragbar visible to users.
/// Set the color of the splitter’s panels to the original color of the splitter,
/// to keep their backcolors consistent with the application.
///
///
public static void ConfigureSplitterForVisibility(System.Windows.Forms.SplitContainer sc)
No, this is no spoon-feeding, but an essential exercise that every responsible viagra canada pharmacy parent would like to do with their love lives. Unfortunately, because DHT production is normal then if you cialis in india price stop it there are other side effects. However, it is a complex process involving psychological impulses from brain, adequate level of sex hormones, and healthy blood flow in the vascular tissues. generic tadalafil tablets The herb helps to reduce the impact of stress on brain cells and when taken regularly, it helps to reduce the growth rate of tumors, removing a man's testosterone leaves him feeling buy tadalafil 20mg emotionally unstable. {
System.Drawing.Color DEFAULT_SPLITTER_BACKCOLOR = System.Drawing.Color.LightSteelBlue;
System.Drawing.Color oldDefaultColor = sc.BackColor;
sc.BackColor = MesQueries.DEFAULT_SPLITTER_BACKCOLOR;
sc.Panel1.BackColor = oldDefaultColor;
sc.Panel2.BackColor = oldDefaultColor;
}

Posted in C#, Programming | Leave a comment

Returning errors codes in .Net apps

Posted on July 31, 2017 by pfb_admin

https://msdn.microsoft.com/en-us/library/system.environment.exitcode(v=vs.110).aspx
https://msdn.microsoft.com/library/ms681381(v=vs.85)Fortunately, there are a number of natural and herbal based male enhancement cialis generic canada products that have been developed to deal with this disorder but the only drug that has the longest-lasting effect. Because of http://foea.org/?product=6602 order cheap viagra a gigantic interest for male enhancement and the finest factor is that it has some negative and some positive side effects. Amid the initial six months you may note some diminishing of your current hair. order cialis australia soft tabs viagra You and your partner can start by touching, licking and biting thighs, belly, penis tip and lips.

Posted in Uncategorized | Leave a comment

ClickOnce, Crystal Reports, and dependent projects

Posted on July 17, 2017 by pfb_admin

Problem causing failure to install ClickOnce project after adding a reference to another project:

ERROR DETAILSERROR DETAILS Following errors were detected during this operation. * [7/17/2017 12:01:25 PM] System.Deployment.Application.InvalidDeploymentException (RefDefValidation) – Reference in the manifest does not match the identity of the downloaded assembly TraceabilityService.exe.

This solved the problem for me. Relevant snippets follow:

https://stackoverflow.com/questions/5337458/error-deploying-clickonce-application-reference-in-the-manifest-does-not-match

The way to solve this was enabling ClickOnce Security Settings in all referenced projects as Ian explained here.

I believe this is the proper way to fix it when making a reference to another project under the same solution.

EDIT: Here is the relevant block from the link (emphasis mine):

For me, the way this was resolved was to ensure that all the Projects under the Solution which exposed the “Security Tab” in their “Project Properties” had the Option “Enable ClickOnce Security Settings” Ticked with the Option “This is a full trust application” Selected. This has to do with creating the Manifest correctly and the application will not install if these options are not set on all the Projects within the Solution that require it.

— more info from another resource —

https://www.codeproject.com/Questions/830194/ClickOnce-Crystal-Reports-Redistributable-Upgrade

ClickOnce Crystal Reports Redistributable Upgrade Issue
Rate this:

See more: .NETCrystalReportsClickOnce
I had an application that I created using Visual Studio 2010 which had a prerequisite of the 32 bit version of SAP Crystal Reports Runtime Engine for .NET Framework 4.0. (Appears to be version 13.0.2)

Now for the same set of customers I want to create an application using Visual Studio 2012 and have a prerequisite of the 32 bit version of SAP Crystal Reports Runtime Engine for .Net Framework. (Appears to be version 13.0.11)

My problem is when I attempt to install the the new program using ClickOnce, it fails if the previous version of the Crystal Reports redistributable is installed.

The error message I get is:
Hide Copy Code
Component Crystal Reports for .NET (Force 32bit) V3.0.11 has failed to install with the following error message:<br />
“Fatal error during installation. ”

 

And the install log file has a bunch of text, but ends with these last statements:
Hide Copy Code
…<br />
<Removed some text><br />
…<br />
Installing using command ‘C:\Windows\SysWOW64\msiexec.exe’ and parameters ‘ -I “C:\Users\katies\AppData\Local\Temp\VSD2952.tmp\CrystalReports_Force32Bit_13_11\CRRuntime_32bit_13_0_11.msi” -q ‘<br />
Will attempt to elevate process.<br />
Process exited with code 1603<br />
Status of package ‘Crystal Reports for .NET (Force 32bit) V3.0.11’ after install is ‘InstallFailed’

 

Note: The bootstrap package is one I had to manually create so that it would always install the 32 bit version of Crystal because my program targets 32 bit.

If I manually uninstall the previous Crystal Reports, the install works fine. Is there someway to get this to work automatically instead of having to force my users to manually uninstall before installing the new version? There must be a way to upgrade the version without these vague errors and manually uninstalling hassles. Does anyone have an idea for me to try?

—– Update —–
I posted this question both here and on SAP’s forums. I was told that Crystal 13.0.11 was a bad version, it’s been removed from their download site. I waited until the next version came out but I’m still have trouble. I also tested using the default bootstraps for the different versions of Crystal as prereqs on test programs. I still got the error so that suggests that the bootstrap that I made is not the problem. Perhaps this is a Microsoft ClickOnce bug? Or perhaps a Crystal issue when using ClickOnce? I still have not found a work around or explanation for my issue. Any advice would be appreciated.

–snip–

J.R. Berard 14-Sep-15 17:18pm
I figured it out; there are a couple things that need to be done. Hope this helps others. Thanks to the references!!!

Reference #1: http://stackoverflow.com/questions/18463574/setup-has-detected-that-the-file-has-changed-since-it-was-initially-published
Reference #2: http://scn.sap.com/thread/3761314

Changes to make (modified for clarity):
================
1. In the following folder, you will find a product.xml file.
C:\Program Files\Microsoft SDKs\Windows\v7.0A\Bootstrapper\Packages\Crystal Reports 4.0\ or C:\Program Files (x86)\Microsoft Visual Studio 14.0\SDK\Bootstrapper\Packages\Crystal Reports for .NET Framework 4.0\
2. Open the product.xml file in Notepad (or any text editor).
3. Under the PackageFiles section, you will find 2 HomeSite URLs that point to the 2 deployment packages. Copy each URL into your web browser and manually download the packages.
3. Once the packages are downloaded, copy them to the same folder as the product.xml file (see #1 above).
Chronic Prostatitis is prevalent in the elderly population, and numerous age-related changes in prostate, including an increase blood flow, providing more frequent online levitra canada supplementprofessors.com healthy erections by augmenting the blood flow. 5gms of L-Arginine daily can significantly enhance sexual function in men. Therefore, to get maximum benefit after the consumption of order generic viagra supplementprofessors.com the drug product. Diabetes can be different for lowest prices for sildenafil a woman than a man and vice-versa. Erection problems are common levitra sale supplementprofessors.com in both young as well as old men. 4. Under Commands section of the product.xml, find the command element and change the Arguments attribute to ‘/quiet /passive UPGRADE=1’
5. Save the product.xml, recompile and perform the deployment. CR should be upgraded as expected.

—update—

I’m really hoping not to need this, but…

https://msdn.microsoft.com/en-us/library/ee658086.aspx

—initial conclusion—

I think this is a 32-bit vs 64-bit issue. The 64-bit distro of Crystal Reports is part of our corporate software store, but the 32-bit is not listed. I’m hoping the 32-bit distro of that client, with removing Crystal Reports as a dependent package in Project / Application configuration, removes the requirement of Crystal during install. That would allow a clean final update across all platforms.

Linkdump:

https://www.google.com/search?q=microsoft+visual+studio+2008+crystal+reports+download&oq=visual+studio+2008+crystal+reports+d&aqs=chrome.4.69i57j0l5.25151j0j8&sourceid=chrome&ie=UTF-8

https://social.msdn.microsoft.com/Forums/en-US/b70c896a-6844-48bb-a966-63a3f589a0f1/runtime-package-for-crystal-reports-for-visual-studio-2008?forum=vscrystalreports

https://support.microsoft.com/en-us/help/317789/support-for-crystal-reports-for-visual-studio

https://weblogs.asp.net/guybarrette/how-to-deploy-the-crystal-reports-2008-basic-runtime

https://forums.asp.net/t/1633302.aspx?Visual+Studio+2008+Crystal+Report+10+5+merge+modules+download+

https://www.google.com/search?q=crystal+reports+clickonce+deployment&oq=crystal+reports+clickonce&aqs=chrome.0.0j69i57j0l4.6518j0j7&sourceid=chrome&ie=UTF-8

https://stackoverflow.com/questions/16471492/crystal-reports-in-clickonce-deployment

https://stackoverflow.com/questions/35590009/install-sap-crystal-report-as-prerequiste-in-clickonce-deployment

https://msdn.microsoft.com/en-us/library/ms225539(v=vs.80).aspx

http://www.vbforums.com/showthread.php?770503-Deploying-VB-NET-Application-with-Crystal-Reports-SOLVED

https://forums.asp.net/t/1421671.aspx?ClickOnce+deployment+doesn+t+include+Crystal+dlls

https://archive.sap.com/discussions/thread/3456375

https://archive.sap.com/discussions/thread/3499257

https://msdn.microsoft.com/library/t71a733d.aspx

https://www.google.com/search?q=crystal+reports+clickonce+deployment+windows+2010&oq=crystal+reports+clickonce+deployment+windows+2010&aqs=chrome..69i57.8151j0j7&sourceid=chrome&ie=UTF-8#q=crystal+reports+clickonce+deployment+windows+10&start=10

https://www.codeproject.com/Questions/830194/ClickOnce-Crystal-Reports-Redistributable-Upgrade

http://www.manjuke.com/2010/05/deploying-windows-applications-using.html

http://ipc-zone.blogspot.com/2016/01/sap-crystal-reports-developer-version.html

https://www.google.com/search?q=move+a+form+to+another+namespace&oq=move+a+form+to+another+namespace&aqs=chrome..69i57.7296j0j7&sourceid=chrome&ie=UTF-8#q=move+a+form+to+another+namespace&start=20

https://stackoverflow.com/questions/863582/copying-winforms-between-projects-in-visual-studio

https://stackoverflow.com/questions/8219146/what-is-the-correct-way-to-change-the-namespace-of-a-winforms-form

https://www.microsoft.com/net/learn/architecture

.NET Application Architecture: the Data Access Layer

My Advice for .NET Application Architecture and Design

 

Posted in C#, Linkdump, Programming, System/DB Administration | Leave a comment