Seth Paul's Q&A profile

• SQL Server Report Models using Islookup and expandinline

  I am building and deploying models. I have many small description tables, they include two attributes. On attribute is the key (which is a code or type) and the other is a varchar description.  They tables are each optionalone related to the primary table.  I am "denormalizing" the description tables using Islookup.   I change the Role in the primary table to ISLOOKUP, I modify the defaultattr ...Show All

• Visual Studio Moving a project from VSS 6 to VSS 2005

  Under my guidance and administration, we are moving from VSS 6.0 to VSS 2005. I am not only new to source code control, but also new to the company and was not involved with the VSS 6.0 install, setup or administration. I have setup a number of new databases using VSS 2005.. These databases were created (by design) on the same server which VSS 2005 was installed on. These databases will be accessible to Users via a network share. We have databas ...Show All

• SQL Server Last() Function?

  Greetings, I'm having some trouble to create a report. In this report I'm supposed to get the last row for each group of customers, ordered by date. Let me explain you a bit further using an example: The table contains these fields, amongst others: CustomerID, Car, LastVisit. So, for each customer there are many rows, each one with a different value in LastVisit. What I need to get, and before I started it looked quite easy, i ...Show All

• Visual Studio 2008 (Pre-release) Problems with DataContract

  I Keep getting this error. System.Runtime.Serialization.InvalidDataContractException: Type 'Brackets.Bracket' has neither [Serializable] nor [DataContract] Can somebody help me My Application looks like this... - Object "Bracket" contains using System; using System.Collections.Generic; using System.Text; using System.ServiceModel; using System.Runtime.Serialization; namespace Brackets { [DataContract] public class Bracket { ...Show All

• Visual Basic [VBA] problem with blank input fields

  Hi all, I have written a short form in excel that executes a calculation based on user input from text fields. My problem is that when the fields are blank, and a user hits Calculate... there is a debug error. Is there anyway I can have a message box pop up and tell the to enter information and take them back to the input fields The code for the button is the following Private Sub CommandButton1_Click() dist = Sqr((TextBox1.Val ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. A supplyment...

  I'd just like to say, nice work XNA team. Since the topic is already up, I also wish to says nice work. Because it doesnt looks completely stupid rather interresting and quite genius made. This would help alot of studio organize their content more pricesly then ever. And the only people that actually hates this software is some Mod Teams for specific games, that sometimes likes to have acces to some of the un ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectDraw and Transparent Dialog boxes, flickering

  I am using XP, VC++.NET 2003, and VideoLAN (activex) for streaming video. VideoLAN uses DD2 for most of the drawing, and seems to cause issues with a transparent dialog box sitting over it. It will flicker as VideoLAN (DD2) invalidates the region sitting on-top (the transparent dialog). Is this a problem becuase they use DD2 and not D3D9 Would converting their code to D3D9 stop the flickering I basically want to have an overlay plane that ...Show All

• Windows Forms Locking down the desktop

  I am writing a custom web browser that will only allow users to view a particular website while taking an online test. While the user is taking the test, I would like to limit their desktop funcationality (ie. prevent them from running other ap ...Show All

• Visual Studio Express Editions Visual C# 2005 Express Edition Beta 2 hangs

  Hi, I am new to Visual C# 2005 Express Edition Beta 2 and I have big problem. When I create a new project the form1 is created and whatever I am doing next program hangs up. I have Windows XP Proffesional SP2, 412 MB of RAM and 62GB of hard drive. I have never had beta 1 version installed. Please, help me. Regards, Natalia  OMG! Dewan! You're right! The last time, I had installed Visual C++ Express first, then I installed C#. ...Show All

• SQL Server Drillthrough with multiple tables

  Hi, I'm having a bit of trouble with drillthrough, hope someone can help. When the user drills through, I would like them to retrieve some records that are located in another table - not in the fact table. E.g. if they drill down on one record of with a data value of 100, they should see 4 related source records that reside in another table. At the moment, when the user drills down, they always see the entire contents of the other table. Of ...Show All

• SQL Server Error rsFailedToDecryptConfigInformation

  Hi! Today we have backup everyting on our new server. Now when i try to launch my reports i have this error rsFailedToDecryptConfigInformation saying that it cannot decrypt some value. I have done some search on internet and it says that i should run rsconfig but i don't know what to do There's a lot of option and parameter and i don't know what i need for my reports to run again. Also when i tried to run my report from outside the local networ ...Show All

• Visual FoxPro Container 'when' method?

  Hi; I don't see a when event for a container. I am using 'gotfocus' but if there is a command button in the container, and I want to prevent the user to click it (in some cases), gotfocus is too late bacause the button's click method already fires. Any ideas how would I conditionally prevent a user access to everything contained in a container Thanks, Aleniko Dave; If I use the .enabled pro ...Show All

• Windows Forms ADO - aggregate functions

  Can someone please confirm my understanding of this code snippet dtParent.Columns.Add("P5Sum", GetType(Decimal), "Sum(Child(GroupBy2Summary).P5)") This code snippet should add a column to the parent table named P5Sum, which will contain the result of the sum of all&n ...Show All

• Windows Forms FindControl

  Ok, usually with a web app, this is easy to find a control... string ID= ((HtmlInputHidden)( this .FindControl("ID" + myVal))).Value; And I know forms don't have HtmlInputHidden.  The control I'm trying to find is a picturebox. Windows forms doesn't have FindControl. What is the equivalent Thanks, Zath   You can use: this .Controls.Find(key, searchInsideChildren) where th ...Show All

• Visual J# Publishing a project

  I am trying to publish my project, but when I run the installer it dies because the the project has been improperly formatted. I have been unable to find any references to formatting during publishing, or even system requirements for the published version. If you have an easy solution or if you can point me in the direction of reference material for this that would be great. Thanks. Hi, Does it say "Project" or ...Show All