Mturco11x's Q&A profile

• SQL Server Make a validate rule in a table

  Hi In access i can make a rule like if i have a Coloumn to date i can make a rule to say that this fields data shall be > date can i do this also in sql and how regards alvin You can create a Check Constraint on a column in a table. Check Constraints can compare a column's value to other values within the same row or to functions, but cannot compare to other rows. In your example, are you asking how to compare a column named to_date to one called date Or are you asking how to compare to_date to the value of the curent date returned from a function There are some wrinkles with the latter, since a row that passes today, might be invalid tomorrow. The constraint will be re-evaluated if the row is modified, even if ...Show All

• .NET Development How to translate a configuration file to code instructions

  Hello I have the following configuration file for a client which need to use a remote object <configuration> <system.runtime.remoting> <application> <channels> <channel ref="http" secure="false" port="0" /> </channels> <client> <wellknown type="CallbackLib.ICallbackInterface, ICallbackInterface" url="http://localhost:2222/CMyService" /> </client> </application> </system.runtime.remoting> </configuration> The object CMyService support the registration of an event (implemented as an event) called by the server and intercepted by the client. When I use the configuration file everything works f ...Show All

• SQL Server Package Name Sorting

  SISS packages do not sort by name in BIDS and they do not sort by name when deployed to a SSIS server if choosing to store in sql server. The packages do sort by name when stored in file system. We have more than 100 packages on the server and just could not keep up with the locations. The only thing I can do is to create many folders. But even folders have no way to be sorted. Do I miss something here Jamie, Thanks for your reply. I tried both solutions in BIDS. The first one works, but it seems too much work. The second one would be a good choice if I could make it work. When I try to sort the packages in a project folder called 'Test Packages', I continue to get the follow error message in th ...Show All

• SQL Server Merge Join vs. Lookup vs. Custom Script - which is fastest?

  Very often we have 50'000+ rows which you need to pull values from different source (e.g. CityNames from citycode in Excel file). Currently we are using Lookup - but the questions is which of those 3 options is best in performance wise Thanks guys for your answers - I will try it out performance testing this weekend on my free time. So far it has seemed to me merge join is slower than lookup, however, lookup seems to take much longer than i like it to - so i was wondering if creating a script transform would be better solution... Just wanted to get an idea - based on you experience which option do you use ...Show All

• .NET Development Need some help on net framework 3.0

  I still have net framework 1.1 and 2.0 and just unstalled 3.0 listed in add and remove, do i need to remove the previous ones, they don't seem to remove the older ones when you update. That is a great question. The answer is found in what the 3 products are. The following is from the .NET Framework Deployment Guide( http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnlong/html/netfx30.asp ): "How .NET Framework 3.0 Relates to .NET Framework 2.0 and Earlier The .NET Framework 3.0 adds new technologies to the .NET Framework 2.0, which makes the .NET Framework 3.0 a superset of the .NET Framework 2.0. You can think of .NET Framework 3.0 as an "additive" release to the .NET Framework 2.0, as contras ...Show All

• Windows Forms HtmlElement.InvokeMember Method (String, Object[])

  I am planning to use WebBrowser for creating virtual tree which will be html table. I am extending the example I found on the Internet trying to add rows to HTML table in C# code . Snippet from Microsoft website with "moveRow" does work , whereas "insertRow" which I want to use doesn't. I am immediaterly out of DispatchDefault without any error messages. Any ideas why [DispId(0)] public void DispatchDefault() { HTMLWindow2 win = (HTMLWindow2)_doc.parentWindow; HtmlDocument hdoc = axWebBrowser1.Document; HtmlElement he = null; HtmlElement htable = null; // mshtml.IHTMLTable htable = null; HtmlElement hrow = null; HtmlElement hcell = null; string eventtype = win.@event.type; string elementid = win.@event.srcElement. ...Show All

• Visual Studio Team System Load Test with Web Unit Test Problem

  I'm trying to create a load test that runs a Web Unit Test, but I cannot see the test in the list of available tests. When I remove the HostType ( "ASP.NET" ) attribute from the test, I can see the test in the list. Unfortunately, the unit test is no longer runnable without that attribute. Does anyone have any suggestions Thanks, Kris Unfortunately we do not support running unit tests hosted in ASP.NET in a load test. The amount of cross-process traffic was too high to make these useful, so we decided to not support it (rather than invest the time to fully test the solution). Ed. ...Show All

• Internet Explorer Development Moving Interent Explorer Toolbards

  How do you move the tool bars in interent explorer 7. When i try and move the Menu bar up or down nothing happens. Trying to get the Menu Bar on top then the URL bar 2nd and so forth but cant seem to move the toolbars. Help pls! Thanks EricLaw, This is the fix I have been looking for, to force IE7's menu bar to the top. Imported your tweek into the registry and back to a more clasic menu layout. Thanks again! ...Show All

• Visual C# How do you call a pascal DLL string parameter function with C# strings?

  Hi, I'm very new to C# btw. I'm sure someone probably has gone round this loop before.... I have a DLL that I wrote in Delphi to handle encryption of pascal strings, these are the definitions of the two functions in pascal, they are compiled into the file encrypt.dll, I'd like to use these functions from within a c# program : function decryptstring(input : string) : string; export; function Encryptstring(input : string) : string; export; I then wrote an encryption.cs file to provide a C# header to the library and compiled that with the command: csc /t:Library /out:encryption.dll encryption.cs The encryption.cs file looks like this: using System.Runtime.InteropServices; public class encryption { [DllImport("encryp ...Show All

• Visual Basic Preserve on Commit

  I want to process recordset and do periodic commits without losing the cursor. I'm trying to use the "Preserve on Commit" property but I'm getting this msg: ERROR DESCRIPTION: Item cannot be found in the collection corresponding to the requested name or ordinal . Any ideas, anybody, anywhere ------------------------------------------------------------------ Global cnConnect As ADODB.Connection Set cnOracle = New ADODB.Connection strConnection = "DRIVER={Microsoft ODBC for Oracle};" _ & "UID=" & strUserID & ";" _ & "PWD=" & strPassword & ";" _ & "SERVER=" & strDatabase & ";" cnO ...Show All

• Visual Studio 2008 (Pre-release) How to rotation a point that user clicked on the 3D model to the centre of screen?

  I have  a  3D sphere  in viewport3d ,I want rotation this point to center on screen when I click 3d model,But I can only fulfill this rotation for one time, when for the second time, the position of point changed.    below is my segment code .          <PerspectiveCamera x:Name="Camera" FieldOfView="45" NearPlaneDistance="0.1" FarPlaneDistance="513.37600661026636" Position="0,0,213.654796443738" LookDirection="0,0,-213.654796443738" UpDirection="0,1,0"/>         public void UpdateResultInfo(RayMeshGeometry3DHitTestResult rayMeshResult)         {         &n ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. What Does SWM Stand For?

  I have a quick question although I know it has nothing to do with any real hardcore programming I just wanna know what SWM stand for. Strangly I have found that SWM is a garbage company called Solid Waste Managment or (SWM) I don't think we should call our meshes... MyMesh.SolidWasteManagment So this has brought me to ask this question WHAT DOES SWM MEAN A 13 Year Old C# Programmer I think SWM = SpaceWarsModel or SpaceWarsMesh.... just a temporary solution until the Content Pipeline is done ...Show All

• SQL Server SQLWB.EXE max cpu

  SQL Server Management Studio 2005 Windows 2000 when I "Open Table" to view all the records in a table, the cpu goes to 100% and the records are drawn very slowly - about the same speed as you read ! I have re-installed all the software and also tried service pack 1. SQL 2000 worked fine. any ideas thanks John, UK Microsoft SQL Server Management Studio 9.00.2040.00 Microsoft Analysis Services Client Tools 2005.090.2040.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 built by: (_sqlbld) Microsoft MSXML 2.6 3.0 5.0 6.0 Microsoft Internet Explorer 6.0.2800.1106 Microsoft .NET Framework 2.0.50727.42 Operating System ...Show All

• .NET Development Error 80070005

  Hello, I developed for 4 month a web site with visual studio 2005. The site runs using VS2005. Mathematical computations have been done using EXCEL (Microsoft.Office.Interop.Excel). When running the site under IIS (XP pro), I get the message detailled under. I tried to give permissions on EXCEL to IUSR_MACHINENAME, then to everybody without results. It will be impossible to deploy the site until this error is solved. Thank you to help me. Server Error 80070005 in '/SiteOPCVM' Application. -------------------------------------------------------------------------------- Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005. Description: An unhandl ...Show All

• Visual Studio Bug with datetime picker?

  I create report that uses stored procedure with 2 parameters. 1st parameter is datetime, 2nd is string. In preview mode I see datetime picker for 1st parameter. I pick September 1, 2005. I use Russian regional settings and date is displayed as dd.mm.yyyy (01.09.2005). It is OK. But after I click "View Report" date is changed to 09.01.2005 (January 9, 2005) and I get empty report because I have not data on this date. I click again and date is changed to 01.09.2005 (September 1, 2005) and I get report with data. I click again and date is changed to 09.01.2005 etc. If I change Standards and Formats in Regional Options to English (mm.dd.yyyy) I get normal behaviour. But I need Russian standards. Alex, ...Show All