Philip Harris's Q&A profile

• SQL Server OUTER JOIN table limit?

  I came across this statement from ASP.NET forum : "..There is a limit to the level for OUTER JOIN ANSI SQL limit is four after that you may get strange results. ..." . I did a little research but without getting clear answer from the SQL92 standard itself. I am wondering whether I can get help about this in SQL Server 2005 implementation here. I put this question in another way, How many tables can we use in OUTER JOIN(or INNER JOIN) in SQL Server 2005 Thanks. There is no limit in the ANSI SQL standard or SQL Server. In fact, the ANSI SQL standard doesn't talk about such limits anywhere. The ...Show All

• Windows Forms Windows forms and Office Word

  Hi, I'm currently developing an application for a small company. Basically, I have a windows form with some textboxes bound to a MS Access database. The company's already created a bunch of nice Word reports (documents) that took them a long time to develop. What my client wants to do is that once he finished capturing the info in the controls, have a button that fill up that same info into their Word reports and save it to the DB (which I already did). However I'm still struggling with the Word thing. Does anyone have any idea if this is possible Are there any tutorials out in the internet or a good book I've been looking ...Show All

• Software Development for Windows Vista Cannot Pass Parameters Into Workflow

  I've seen a couple of other similar posts, but I have still been unable to solve my problem. I am attempting to pass 3 parameters into my workflow. When I call the following code, I get the error that follows: workflowParameters.Add( "CurrentData" , submitData); workflowParameters.Add( "ProviderName" , _providerName); workflowParameters.Add( "ConnectionString" , _connectionString); WorkflowInstance workflowObject = _workflowRuntime.CreateWorkflow(workflowType, workflowParameters); EXCEPTION: Workflow Services semantic error: The workflow 'NdtWorkflow' has no public writable property named 'Cur ...Show All

• Visual Studio Display the current date in a report

  Hello, I added a textbox in a report. The value property of this control is setted to =Now(). But it doesn't work at all. I get an error: HRESULT 0x80131418 Isimply want to insert the current date to the report....could you help a new Reporting control user Best regards, Today will do : =CDate(Today).ToString("MMMM dd , yyyy") Good Luck, Long ...Show All

• .NET Development Reading TextFile and execute command for SQL

  Hi. I was not sure where to post this, if it should be here or in the SQL subforum but I thought it would be here since it is an IO thing. OK, I am creating a "management" panel for a WinForms app, C# .NET 2.0 and running SQL Server 2000 SP4 Now I have generated an SQL Script from SQL to create a database. This works fine, as I have copied the text into clipboard then pasting it in the Query Analyzer, did a syntax check and executed the script, works perfect no errors. So I then save this to a textfile. My application will create the database. In order to create the database, it needs the script commands. So I u ...Show All

• Smart Device Development Problem with localization Start Menu -> Settings and Programs icons on PPC(WM2003SE)...

  I have a problem with Start Menu Settings and Programs names. How can I hange the names of Programs and Settings in Start Menu. I was looking in shellres.dll, and I olso create MUI file of shellres.dll with changed that names, (in string resource number: 343) but it doesn't helped. What worse. When I change that names in shellres.dll.0415.MUI from Programs to Programy or Settings to Ustawienia, this Start menu folders are changing icons for standard folders, the names aren't changed, and when I Click on the Start Menu setting (should be named: Ustawienia after rename in MUI) I didn't see any icons. I didn't found anythink about i ...Show All

• .NET Development Operation must use an updateable Query

  Hi, I am using VS 2003 and C# with OleDb connection to read and write from Excel spreadsheets. I have no problem reading Excel data but when writing to Excel I got this error on this line: oleCmdInsert = new OleDbCommand(@"INSERT INTO [Sheet1$A1:A1] VALUES ('ABC')", _oleConn); oleCmdInsert.ExecuteNonQuery(); Here is the error: System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPAR MS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCo ...Show All

• SQL Server how to build share dimension

  in a project ,i built two cube,each cube need time dimension,i want the time dimension be a share dimension.how to do it What version of Analysis Services are you using In AS 2005 open your project in BI Dev Studio. Open your cube. Right click in the dimensions tab and select "Add cube dimensions". Make sure you go into Dimension usage tab later and specify how your dimension is assosiated with the measure group. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• SQL Server sysxlogins table and null names

  Hi all, running sql server 2000 sp4, viewing the sysxlogins table data, and am wondering about the three items listed with a <NULL> in the name column, all xstatus = 192, each has a unique srvid value of 0, 2 or 3. Looking in the MS tables reference book did not help they don't cover sysxlogins, googled around but no luck, searched this forum also. What are these entries Thx I only have one entry for that. I assume that this are internal account which are us for internal purposes, these accounts have setupadmin and sysadmins rights (xstatus 192), dedicated to the (as of the srvid) local se ...Show All

• .NET Development Pressing "Enter" key on a text box, causes webform to reload.

  Hi , I am facing a strange problem with the ASP.NET (with VB.NET) user controls. My user control contains only one text box web control and some other controls (but one and only one text box). I put this user control on a webform (web form also does'nt have any text box control) and request that web form through "http:// " request. Now, when i put some text in the text box and press the "Enter" key (while the cursor is still in the textbox ) the webform reloads i.e. Page_load event is called again for the webform and subsequentally for my user control. This initializes my user control to blank state. There is als ...Show All

• .NET Development Socket crashes on AccessViolationException when the peer side aborts (net2.0 beta2)

  Hi,   I experienced a weird problem with socket on my machine. On my colleague's it works like a charm.  When I have socket, waiting for incomming data (after I called BeginReceive) and the peer side aborts - eg. I kill the telnet.exe who I used as a client, the socket throws AccessViolationException on unknown module. The crash itself is in > imon.dll!20b0cd39()   did anyone experienced something similar, or it's problem on my machine regards   georgem Unfortunately, I can't get this to repro on my side using a current build and the dump file you sent contains only a ...Show All

• Visual Studio change readonly property

  How can I change the readonly property of a file to delete it or update it thank you You can use the Exec task to execute the attrib -r filename command like <Exec Command="attrib -r filename"/> or <Exec Command="attrib -r folder\*"/> You can use task batching to do this for multiple files like <Exec Command="attrib -r %(filename.Identity)"/> where filename is an itemlist of files ...Show All

• Visual Studio 2008 (Pre-release) Difference

  Below are 2 different query statements that produce identical result: var maxCost = db.Products.Select(p => p.UnitPrice).Max(); var maxCost = db.Products.Max(p => p.UnitPrice); According to the DLinq document, the first statement is considered to be the aggregate function applying to the sequence that sastify the expression. The latter is applied to all objects. What does it mean by sequence, expression and objects Thank you all for your help In your example, a single Product (represented by p) is an object.  (db is also an object, representing the database.) db.Products is also an object.&nb ...Show All

• Visual Basic Config file on Class Library ??

  Got a solution with 3 projects, a Web Service, a WinForms (MyUI), and a Class Library (Foo). MyUI calls methods in the DLL that access the web service. The DLL has project config settings that store the URL of the web service. I compile the solution and it compiles all 3 projects. In the DLL's bin dir it puts the foo.dll and foo.dll.config files. However, in the WinForms bin dir it puts the MyUI.exe, MyUI.exe.config, and foo.dll; it doesn't include the foo.dll.config. When I run the MyUI.exe from its bin dir, it appears to work, and is obviously getting the config settings from somewhere because it doesn't crash and successfully contacts ...Show All

• .NET Development PerformanceCounter specifications ?

  I am looking for the standard PerformanceCounter specs. Through the performance monitor application that comes with WinXP, I can see that there are loads of performance counters out there (on a WinXP machine). Is there some reference guide on those counters (at least the OS and .Net counters) Thanks in advance, Joannes Hi, BUG: NextValue method of .NET PerformanceCounter object returns zero SYMPTOMS The NextValue method of the .NET PerformanceCounter object may return zero (0) for the following LogicalDisk or PhysicalDisk performance counters: ? % Disk Time ? % Disk ...Show All