ozakiweb's Q&A profile

• SQL Server What is sixth normal form?

  What is the 'sixth normal form' in the normalisation of tables in database management system. Perhaps a Google search might help http://www.google.co.uk/search hl=en&q=%22Sixth+Normal+Form%22&meta = ...Show All

• Visual Studio Express Editions help, program stops with no errors

  Well I have put a text search within a SQL loop: both programs work separatly that is when I execute a SQL statement it produces what I want. When I loop through a text search it works when I enter a name to search for. But when I put them together it dies - I mean does nothing but set there....I put in a msgbox and nothing happens. Thank You for the help,. I know if I change the line: Dim myName As String = field2 to read: Dim myName As String = ("name1") then it works - in the loop it just goes over and over with the same name. field2 should be changing per each loop of the SQL... I am not sure the dynamic name does not work. again I no errors when running this process.. here is my code. Dim connec ...Show All

• Visual Studio Express Editions oranisation suggestion request

  In C, at least in my micro controller programming environment, it is easy to have a header file, with various routines contained therein, which is placed ahead of the main program. What do you do for c# do you add a raft of classes into Form1, or do it some other way I am concerned about reuseability, I guess (both within the specific program, and in other future programs), hoping that I can cut down on the number of keystrokes I need, in order to create a useful piece of software. Is there an on-line tutorial that is easily understandable that covers this sort of question Thanks, Best Wishes, Ray Well just don't use them Wizards, they are in fact a bit slower to use than Visual Studio 2005-aided co ...Show All

• .NET Development C# Com Interop problem - should be simple!

  I have some trivial vb6 sample code that uses a com dll to interface to talk to some hardware but I can't seem to port it over to C# Interop successfully. I have tried many permutation of marshalling attributes but I get a "Attempted to read or write protected memory..." exception with types I believe will work and DataTypeError returned from the com interface function if I am deliberately incorrect with the types.   The com interface declaration in OLE Viewer: long RpcCall(long iJobCode, VARIANT SendData, [in, out] VARIANT * RecvData);   The sample in vb6: Dim n() as Byte Dim r() as Long n = StrConv("Time_s" & vbNullChar, vbFromUnicode) conn.RpcCall(10012, n, r)   The intero ...Show All

• Smart Device Development Managed DLL

  Hi, I'm developing smart device application by using CF1.0 on VS 2003. I need your help. My question is How to use managed dll class (which contains one control class) dynamically . The following will explain to you what my problem. The managed dll (MyControl.dll), written by using Class Library application in VS 2003 and it contains: Public Class MyControl Inherits System.Windows.Forms.Control ............................... End Class I have added the above dll as a content with my project. (Build Action = Content). My problem is how to add the above control in my application dynamically (when i click button). For importing Native dll functions ...Show All

• SQL Server Stored Procedure

  Hello, I've written the following stored procedure: CREATE PROCEDURE dbo.GetTableName ( @ConfigurationId int = 0, @TableName varchar(MAX) OUTPUT ) AS SELECT @TableName = ConfigTable FROM Configurations WHERE Configurations.ConfigurationId=@ConfigurationId; How can I get the parameter TableName now I tried EXECUTE GetTableName 0 Error Message: "Procedure or Function 'GetTableName' expects parameter '@TableName', which was not supplied". Sure, I did not supply it because I wanted to have it as return value. What is wrong I also tried: CREATE PROCEDURE dbo.GetTableName ( @ConfigurationId int = 0 ) AS DECLARE @TableName varchar(MAX); SELECT @Ta ...Show All

• SQL Server ForEach Loop - Testing for when Enumerator is Empty

  I have a SSIS package this set to run at a specific time each day. If there are no files for the ForEach tool to work upon...while it doesn't 'fail'...I would like to test for the condition that the enumerator was empty...so that I could send an email message reminding someone to followup and investigate. What would be the best way to test for that condition Cordell, Feedback can be submitted to http://connect.microsoft.com . Glad I could help, Patrik ...Show All

• SQL Server Day of the month

  I am trying to code a proceedure that will run every weekend. This process will run for a number of hours beginning at 0900 Saturday and ending at 2100 Sunday. However, on the 3rd weekend of the month, I need it run for a shorter time and to also skip some tables. What I have now to find the day of the month I need is Begin SET @3rdSaturday = @1stDayMonth /*Loops until the date of the first Saturday(DayofWeek #7) of the current month is found */ WHILE DATEPART(dw,@3rdSaturday) <> 7 /*Adds 1 day to the first day of the month until it reaches the date of the first Friday of the month */ SET @3rdSaturday = DATEADD(d,1,@3rdSaturday) /*Adds 14 days to the first Friday of the month. The end result is the 3rd Fridays date ...Show All

• Visual Studio Express Editions Continuously Update Form

  I am creating a form that is going to act as a notification system for users. It has 8 buttons on the form, each button represents a location. Based on the current status of the location, the buttons color will change. I have the program reading from a database at startup and updating the buttons color. What I am needing is how do I have the form check the database after it has been loaded to see if it needs to update the color of a button. What I am planning on doing is, using Thread.Sleep to make the program sleep for about 5 minutes, then check the database again. This would be in an infinite loop, so that the program will always run and update the color of the buttons. I tried to use the Load event, but that does not load the for ...Show All

• SQL Server OLE DB Destination

  I am proceesing a file and using a OLE Db destination for inserting the rows present into a file to the table. As of now OLE db destination points to the table and having the fileds mapping of input column and destination column. now i want to perform some calculation and want insert the rows into table based on the value of some other column for ex. if (column2 == 1) { column1 = column4 - column5 } if (column3== 1) { column1 = column4 - Column6 } Please let me know how to do this. I want to implement all this four condition in one derived column expression. if (Column1== 1) { OutputColumn = ColumnA- Column1RATE } if (Column2 == 1) { OUtpu ...Show All

• .NET Development conditionals in xquery

  I've spent about an hour looking for information on this with no luck. Here's what I'm wondering. Can you put a condtional in an xquery in c# code path = "{IF (boolean(1)) THEN 'blue' ELSE 'yellow'}"; XPathNavigator nav = baseNode.CreateNavigator(); XPathExpression query = nav.Compile(path); Always get an invalid token excpetion on the last line. I've tried all sorts of variations on the code above but always get the invalid token. Can someone show me some working code that isn't in SQL that uses a conditional in XPath It is very clearly said in the VS2005 documentation that the XPathNavigator.Compile() method compiles a string representing an XPath expression . The expression ...Show All

• Visual Studio Unable to create a new DSL project from Visual Studio

  I have reinstalled Visual Studio and the latest SDK and I start to experience problems while creating a new Domain Specific Language Designer Project. At first, after the project is unfolded I get the error message box saying “ The method or operation is not implemented” . When I press OK, I can work. I still need to run the text template manually because it probably fell before it could complete it. However, the problems are not over yet. When I run the solution, I get an error inside the experimental hive saying: “ The following files were specified on the command line: ..\..\..\Debugging\Debugging.sln. These files could not be found and will not be loaded.” Btw, I have no problems opening DSLs I develo ...Show All

• .NET Development Reflection of Enum type

  If I have the following :- public enum test_e : ushort { } How can I use the runtime reflection to determine that the type is based around a ushort I have the follwoing but it returns test_e instead of ushort. FieldInfo [] fi; fi = typeObject.GetFields (); for ( int i= fi.GetLowerBound (0); Looper <= fi.GetUpperBound (0);i++) { FieldType = fi[Looper].FieldType.FullName; } Any thoughts Hi LiamD, I believe what you are looking for is this: Enum .GetUnderlyingType( typeof ( test_e )) G ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. The Unofficial "Hooray I'm Done With my DBP Game" Thread

  When you get done with you game and sumbit it, crow about it here. A little over 24 hours left until the deadline and I'm so amazed I'm done, so much better than college Thanks to ZMan for his help, good luck all. I'll post the source code for my submission once the deadline hits. Bill I'd like to post my game somewhere, for others to see, but I'm still wodering if it is ok with MS. Anyone has an official opinion ...Show All

• Smart Device Development Sample Windows Mobile 5.0 Pocket PC SDK Projects

  Hi all, I was just having a gander through the sample projects provided with the WM5.0 SDK and noticed that the CPP (C++) projects seems far superior to those of CS (and VB). For example, the listView example project allows ListViewItems to be editted (pops up the SIP to enter text) within the control by tapping the relevant ListViewItem three times - is this not possible (editting the Text of a ListViewItem) then with in C# (Does C++ over more power in terms of developing mobile apps ) Excuse my lack of knowledge here, but C++ is not classes as managed code is it Also, if the platform supports TextBox controls, you can set a ListViewSubItem to be of this type ...Show All