ONEWORKNGRL's Q&A profile

• SQL Server UDAs...currency of data

  I'm looking more into UDAs and wondering if someone can help me out. I get how I use them and route to them. What about their freshness -- the data If I'm aggregating data via some methods...when is that underlying data aggregates. When the UDA is called at runtime (coulnd't that hurt performance). I guess I"m likening these things to indexed views with benefits. Am I lost here -- someone help..thanks. A UDA behaves more or less just like a native aggregate (SUM, COUNT, etc).  There is no difference with regard to data "freshness" in that locks are held for the duration of the query (or not, if you use READ UNCOMMITTED).  Basically, a UDA is just a programmatic pip ...Show All

• SQL Server MVP Problems.......

  I have a string parameter that is set to multi value. @PONUM There are no entries in the mvp box, the user enters them at run time. Problem is, I can't the the damn thing to work right. I am also using a StartRange and EndRange which works just fine. Can someone PLEASE help me out. Here is my query. If RTRIM(@PONum) = '' OR @PONum IS NULL Begin SELECT r_PurchaseOrder_1.PO, r_PurchaseOrder_1.PODescrip, r_PurchaseOrder_1.PayTerms, r_PurchaseOrder_1.DeliveryContact, r_PurchaseOrder_1.DeliveryAddress, r_PurchaseOrder_1.OrderDate, r_PurchaseOrder_1.Company, r_PurchaseOrder_1.SupplierName, r_PurchaseOrder_1.OrdFrAddrLine1, r_PurchaseOrder_1.OrdFrAddrLine2, r_PurchaseOrder_1.OrdFrAddrCity, r_PurchaseOrder_1.OrdFrAddr ...Show All

• Visual Basic writing bytes to a file

  I have a program which generates data which I want to write to a file so that I can access it later. How do I open a file to append data and later open it to acess the data Here's a general purpose file i/O dll I wrote. It contains every thing you need for most kinds of I/O Text and Binary (byte). Open and closing logic is included. These routines use a structure I call an I/O status block containing information about and I/O stream. Imports System.io Imports System.Runtime.InteropServices <ComVisible(True)> _ Public Class IONOW ' Dll for synchronous File I/O <ComVisible(True)> _ Public Enum IOStatus cOperationSuccess = 1 cEOF = 42 cTOF = 43 cFile ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. low fps

  i'm confused about fps in my programme. i draw 200 textured triangles in 640x480 window but get only approximately 160 fps. it's strange but when i zoom out from triangles fps growth momentally, but when i close... PreferMultiSampling = false ; SynchronizeWithVerticalRetrace = false ; RenderState.DepthBufferWriteEnable = false ; (i need it coz, ill render triangles with transparent textures) i use DrawIndexPrimitives, i.e. useing vertex and index buffer. any ideas how to increase fps here is my draw func protected override void Draw( GameTime gameTime) { VertexPositionColor [] axes = new VertexPositionColor ; axes[1] = new VertexPositionColor ( new Vector3 (100, 0, 0), Col ...Show All

• Visual Studio MSbuild VS 2005 AssemblyReference using enviromenent variable pointing on "subst" drive

  Hello, I'm using a " subst s: c:\Source \" to set the source code to a virtual drive, and then use s:\MyProject.vcproj, for example, in the msbuild parameters. In addition I have set up some environment variable in the system such as $(BinariesDeployement) which point to a folder somewhere on c:\ I build native c++, managed c++ and c# projects. For managed code the assembly references paths are set using my environement variable $(BinariesDeployement). (<AssemblyReference relativePath="$(BinariesDeployement)\Mydll.dll") I'm using msbuild to build all my projects. I noticed that if I use the virtual drive as root to the projects in msbuild parameter, the environment variables are not changed to their value ...Show All

• Software Development for Windows Vista Bind ExpandableObject properties

  Hi, I have an activity (CustomActivity) which defines a property of type CustomType and use the ExpandableObject as TypeConverter to allow modification of the CustomType's properties in the property grid. Each property of CustomType defines the Bindable(true) attribute. I set the CustomActivity.CustomType property as Bindable and Browsable. I can see the properties in CustomActivity.CustomType, but they are not Bindable! I tried inherit from ExpandableObjectConverter and check if the Bindable property of properties returned by the GetProperties method was set and they were... Does someone has an idea how to be able to bind those "inner" properties Help would be greatly appreciated! Christian This i ...Show All

• Visual Studio How to add an assembly reference when processing an item template?

  Hi, I have an item template that uses a base class in another assembly. Is there a way to ensure the project has a reference to that assembly and if not, add it when processing the template Regards, Alexander You could make your item template fire a recipe when unfolded and have this recipe contain an action that creates a project reference. Did you try this approach -Victor. ...Show All

• .NET Development how to return a socket connecting time?

  hi, i want to get back the time one socket successfully connecting to one server, is there any method to do that thanks a lot RizwanSharp wrote: Mike Flasko wrote: This should do the trick: Socket s = new Socket ( AddressFamily .InterNetwork, SocketType .Stream, ProtocolType .Tcp); s.Connect( new IPEndPoint ( IPAddress .Loopback, 8000)); // do processing on socket s object obj = s.GetSocketOption( SocketOptionLevel .Socket, ( SocketOptionName )0x700C); int time = ( int )obj; The variable time is the number of seconds the socket has been connected for. This works only for connection oriented sockets (ex. = tcp socket). For reference the value ...Show All

• SQL Server Sorting Values in Colum Matrix in a logical order in RS2005?

  Hello, I am curios if someonse has accountered issue when you have to sort values in a column matrix in a logical order as opposed to alphabetical order. In my case I would like to have a matrix column sort like in th example below as opposed to 'Graduate', 'Law', 'Total','Undergraduate'. I have a column called OrderKey which forces the sort I want in T-SQL but this sort seems to be ignored by a RS Any ideas how I can fix it Thanks Undergraduate Graduate Law Total Score 230 560 880 1670 It is like using nested IIF statements. Here is more info on the Switch VB function. ...Show All

• Software Development for Windows Vista i cant create a workflow using the sharepoint designer

  i installed the sharepoint designerWW and still cant create a workflow through the sharepoint designer .. why Question that are specific to the SharePoint should be posted to the SharePoint forum found at http://www.microsoft.com/office/preview/community/newsgroups.mspx . ...Show All

• Visual Studio Tools for Office Word 2007 content control event sinking in VSTO

  I am confused on whether (and if) Word 2007 Content Controls will be supported as a first class object in VSTO (similar to how Ranges and Bookmark objects are currently implemented using VSTO against Word 2003). For instance, I can create a Word 2003 template project in VSTO, and hook into the Bookmark events of the template using VSTO code. I am seeking similar functionality in Word 2007 using VSTO, but with Content Controls. At the moment, the only obvious way that I can find to access content control events is using VBA behind the Word template. (I am seeing other posts that refer to the use of "ThisDocument_ContentControlOnExit", but since VSTO SE currently supports Add-ins and not Template projects for Word 2007, I am ...Show All

• Visual C++ How can I get the ProgID of a COM dll if I did not have the source code of the COM ?

  How can I get the ProgID of a COM dll if I did not have the source code of the COM I appreciate your help. You can use OLE/COM Object Viewer to find the ProgID. It is an external tool available with Visual Studio 2005. Some tools can be found in the Tools menu bar by default. Others such as OLE/COM Object Viewer need to be added. Please see http://msdn2.microsoft.com/en-us/library/76712d27(vs.80).aspx ...Show All

• SQL Server Minimal Components to install

  Hi, I have bought SQL Server 2005 Standard Ed. which will be used only to host databases for different applications like WSUS, McAfee Protection Pilot and CA Brightstor ArcServer. I do not have intention to create corporate applications using SQL Server . In fact, I am using the SQL Server as a "multiple MSDE database server "... My question is what are the minimal components between the following features to install (as I do not not really what they are doing) : -SQL Server -Analysis Services -Reporting Services -Notification Services -Data Tranformation Services -Workstation Components Thanks in advance Eric Hi, Thank you very much for your response. But as I am comple ...Show All

• Visual Studio Will VS 2005 run on Celeron processor?

  Hi ! I want to buy new computer....I'll be working on Visual Studio 2005....If I take celeron 1.5 ghz....will VS 2005 work on celeron processor Tell me minimum system requirements......If anyone is sure.....is anyone working on celeron and VS2005 Thanks, Jiv Thanks a lot...but friend....in that link they have told....."pentium" processor then.. still bit confused. ...Show All

• Visual Basic Simple login Query Problem

  Howdy all, I'll start off by saying that I am a complete newbie when it comes to VB. I've dabbled in VBA for a many a year and am finally making the switch to VB and VS2005, but I must say that I'm having some issues. The scenario: I have the following elements in a VB project: A form called LOGIN A DataSet called 'DataSet1' that has the following tables: NameTable, ProjectTable, TaskTable The issue: Never really having to work with datasets before, I have a small problem trying to execute a simple query to authenticate a user. Let me explain as simply as i can. On the LOGIN form I have 2 textboxes called LOGIN_TB_Username and LOGIN_TB_Password, also a LinkLabel control that is being used as the 'enter' button. Now a ...Show All