JohnHarding's Q&A profile

• SQL Server Instead of Insert Trigger using Exists to filter out Duplicate records not working? Help please.

  Purpose: Insert multiple records into CBIZ_CONSULTANTS table with a INSTEAD OF TRIGGER that checks to see if the HomePhone, MobilePhone or Email1 match. If they do then don't insert. -----here is my trigger ----- ALTER TRIGGER [dbo].[Trg_CBIZ_Candidate_DupeCheck] ON [DBO].[CBIZ_CONSULTANTS] INSTEAD OF INSERT AS BEGIN SET NOCOUNT ON -- CHECK FOR DUPLICATE PERSON IF (NOT EXISTS (SELECT * FROM CBIZ_CONSULTANTS N, INSERTED I WHERE N.HOMEPHONE = I.HOMEPHONE or N.MOBILEPHONE = I.MOBILEPHONE OR N.EMAIL1 = I.EMAIL1 )) INSERT INTO [dbo].[CBIZ_Consultants] --MY COLUMNS SELECT --MY COLUMNS FROM INSERTED ELSE PRINT 'SEND TO DUPLICATE TABLE' END ...Show All

• Visual C++ sprintf for output as binary

  Am I able to use the sprintf function to output text as binary For example, how would you convert text in textBox1 "hello world" to binary I have the code: private : System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) { txtBx3->Clear(); String^ myString = gcnew String( txtBx1->Text ); txtBx3->AppendText( myString ); } But I want to make the code in txtBx3 appear as the binary version of the text in txtBx1. Can I use the sprintf function, what is the easiest way of doing this. ********************************************** I AM USING C++ in VS2005*************************************************** You can take each ascii charac ...Show All

• Visual Studio accessing textbox value in expressions

  Can I access a textbox value from another textbox in order to apply a function to it If so how is this done ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. loading compressed files such as zip, rar,pk3, etc

  is it a "feature" of the content pipeline or would i need to write a custom load+filesystem routine to uncompress such files You would need to derive a new ContentManager and override the OpenStream() method and derive a new Stream to read zip/pak files. YourContentManager.OpenStream() method would open the zip/pak file and position it at the specified asset. Your derived Stream class would handle reading the compressed data. Then, when you YourContentManager.Load<SomeContentType>("someasset"), the rest of the work is handled by the base ContentManager. So, you don't have to create any loading routines, just the zip/pak stream reading code. ...Show All

• SQL Server Size of the cube

  Hi, Can anyone please let me know how can I get the size of my cube. I need to check out the disk space occupied by the cube. Thanks Hi, I have already processed my cube and I need to know size occupied by cube on disk. Its MOLAP cube. Does Metadata tab in Analysis manager shows proper cube size or do I need to do anything else ...Show All

• Visual Studio very slow single stepping in the 2005 sp1 debugger

  We have a large native visual C++ solution with (70+ projects, 3000 C files) and the debugger is painfully slow. Single stepping between two lines takes 5 seconds etc. We've looked here and tried a number of the "solutions" none of which have made a difference. Any suggestions on things to try Thanks, Ted Ted, I see the same symptoms. I am using the debugger with a very large application. I didn't see any problems with DevStudio .NET, but DevStudio 2005 runs very slowly when stepping through the code. I've noticed that the arrow advances to the next line of code immediately, the CPU maxes out for a couple of seconds, and then the windows in the debugger update. I closed all of the ...Show All

• Visual Studio Team System Code Analysis Failing to build due to comdef.h

  I get the following error when trying to run code analysis on one of our apps. When VSTS tries to compile it it bombs in comdef.h Error 1 error C2220: warning treated as error - no 'object' file generated C:\Program Files (x86)\Microsoft Visual Studio 8\VC\include\comdef.h 264 Warning 2 warning C6386: Buffer overrun: accessing 'argument 1', the writable size is '1*0' bytes, but '32' bytes might be written: Lines: 233, 234, 241, 251, 252, 253, 254, 258 c:\program files (x86)\microsoft visual studio 8\vc\include\comdef.h 258 Any Clues on a work around It is VS 2005 team system configured for a tester on Vista 64 bit RC2 build 5744. I did find by running code analysis on the release config it ...Show All

• Visual Studio Express Editions How to name buttons with database field values

  To begin, I know very little about VB express. I started out using VB for apps in excel. I could record macros and copy or edit, but I'm having a little trouble writing code from scratch in VB express. Anyway, here's what I'm trying to accomplish. I have about 40 buttons on a user form. I would like for each button's text to be the value of a separate field in a data table (using SQL Server Express) and update when the data table is changed. I have selected all buttons at once and through the data binding option in their properties tied the "text" property to a specific column in my data table. The problem is that when I do this, every button's text contains the first field value in this column. Since the only option when sel ...Show All

• Architecture High availability application

  Hi Everybody! We are starting a project to develop a mission-critical web application (therefore, availability,reliability and scalability are major concerns). We are thinking about using a SOA approach, using WCF services hosted on IIS (using a cluster in order to provide the required availability, scalability and reliability). My questions are 1) I've seen that WCF can be hosted on IIS or as Windows Services. I'd like to know the advantages and disatvantages of each approach (considering specially performance and development/deploy effort issues) 2) Is there any reference we could use in order to estimate the hardware requirements to support the solution (the information we can use to estimate it a ...Show All

• Visual C++ msvcr80.dll Problem

  Hi there, can someone possibly tell me why Noton WinDoctor is telling me that 10 executables in the .NET Framework 2.0 cannot access the necessary dll file msvcr80.dll I see that the dll exists in the WinSxS directory and I'm running XP pro. I didn't have this problem until I downloaded the 2.0 framework at windows update. Any advice appreciated. Thanks. Naolin I am having the same problem... I even uninstalled it.. and it didnt show a problem then I reinstalled the update and it showed up as a problem in the Windoctor again... any ideas as to what is wrong with this update Im sure its a simple fix but I cant seem to get it.. ...Show All

• SQL Server DataPump performance problem

  I'm using an SSIS under SQL 2005; i transfer data with a DataFlow Component: DataSource = OLEDB Source; Destination = OLEDB Destination The source is a View returning about 100000 records; if i execute it in query analyser it takes few seconds. But if i use it as DataPump Source it takes HOURS to execute it... I've noticed that If i modify the SELECT query inserting a "TOP 10000000000", it takes few seconds.. Why Am i missing something Netoblivion wrote: I'm using an SSIS under SQL 2005; i transfer data with a DataFlow Component: DataSource = OLEDB Source; Destination = OLEDB Destination The source is a View returning about 100000 records; if i execute it in que ...Show All

• .NET Development System.Net.WebException

  I'm using the following function to try to determine how long it takes for a file to download from a webserver. private void btnDownload_Click(object sender, System.EventArgs e) { //**************************************************** Uri uri = new Uri(" http://cslibrary.stanford.edu/107/UnixProgrammingTools.pdf#search=%22unix%20filetype%3Apdf%22 "); System.Net.WebRequest wr = System.Net.HttpWebRequest.Create(uri); System.IO.Stream stream = wr.GetResponse().GetResponseStream(); int b; int counter=0; string strResult = string.Empty; DateTime BeforeDlTime = DateTime.Now; while ((b=stream.ReadByte())!=-1) { strResult += System.Text.UTF7Encoding.UTF7.GetString(new byte[] { (byte)b },0,1); ...Show All

• Visual Basic Can't open certificate store after After vs2005 installation.

  I have client app (VB6). My client app open local store and work with user certificates, using capicom. after vs2005 installation, the app failed to open the local store. What did they change Why can't I open local store   Answer: fixed by the first SP for 2.0 after installing visual studio 2005 you have to re register the capicom.dll. go run option and register as "regsvr32 c:\capicom\capicom.dll" i.e path where capicom is located in your local machine. ...Show All

• Software Development for Windows Vista .NET 3.0 RC1 to RTM key changes documentation

  Hi I'm interested in knowing what changed between .NET 3.0 RC1 and RTM. Does anyone know if there is any document available Many thanks, Vlad ...Show All

• Visual C# Parametrized Query in Visual C# 2005

  Hello, I have a problem in setting a dynamic query in my application. Actually, I know how to work with a parametrized query and how to pass a value for one of the elements in my where clause, but I need to pass more than a value like other criteria or generally i need to change the structure of my SQL in the given query. My database is Oracle 8i. Does anybody know how I may address this Thanks you can still use a dataAdapter and SQLCommand in VS2005 and fill the typed dataset..... i just don't think it is possible to dynamically set the SQL string for a tableAdapter as the tableAdapter is built at design time. You would use a stored procedure to solve your problem by accepting a paramter o ...Show All