bmartling's Q&A profile

• SQL Server Excel Column Data Type Issue

  Ok, hopefully a simple issue with a simple fix. I'm importing data from an Excel spreadsheet with values such as: 10, 20, 20 Tall, 40, 40 Tall. The column imports but is treated as numeric with values 10, 20, 20, 40, 40. I set the cells to be treated as text in Excel. Any suggestions Hi! I have set the value in the registry (TypeGuessRows=0), but i still don't get the right data type. What I have figured out: Lets say I have 25 rows in my column in the Excel file. It that column 13 are numeric values and 12 are text. In this case the column gets indentified as a Numeric type. Now if there are 12 numeric and 13 text values, then the type is set to text. Is there any way to get JET engine indentify the coulm ...Show All

• SQL Server Can I Use Non-empty Behavior for These Calculated Members?

  I still find myself extremely confused about using the non-empty behavior for calculated members. We have a series of calculated members that we refer to as "Velocity", such as "Velocity Sales". The basic definition for these velocity measures is to get the total from the previous 63 business days and then annualize that total (i.e. multiply by 4), with the 63rd business day belonging to the previous month. For example, Velocity Sales for any day in September 2006 would be totaling the sales $ for the business days in the range of 06/05/2006 through 08/31/2006, and then multiplying it by 4. Perhaps not surprisingly, these measures result in extremely poor performance. Since I'm confused on the non-empty behavior, this p ...Show All

• Software Development for Windows Vista Vista Master Volume Control with C#

  Hi, I have write a class wrapper to Vista API audio functions to control the master volume (level and mute). All functions of IAudioEndpointVolume Interface apper to work ok except the SetMute function. The problem apper to be the parameter pguidEventContext of type Guid. If I set the following value : Guid nullGuid; nullGuid = Guid.Empty; int retVal = iAudioEndpoint.SetMute(true, nullGuid); I obtain the error "value dows not fall within the expected range" while executin the SetMute function. If I set a different guid value I obtain the error "exception from HRESULT : 0x88890004" (error inside the COM library). All other functions work ok with null guid. Only the SetMute fun ...Show All

• Visual Studio Express Editions Approach to solving LNK2019s?

  Hi -- I took some MSDN code and tried to make it work but, as it often the case, I got an LNK2019 error. Now, judging from the other ones that I've gotten, the answer is to 1) add a pragma pointing to a .lib file, and 2) make sure that the LIB environment variable includes whatever folder the .lib file is in. (I'm doing command-line compiles of console, non-CLR apps.) Simply adding Advapi32.lib to the top of my apps has solved the problem in general, but I'm trying to run an MSDN code sample at http://msdn.microsoft.com/library/default.asp url=/library/en-us/secauthz/security/modifying_the_acls_of_an_object_in_c__.asp that seems to compile fine, but I get the LKN2019. My question is, how should I attack this Given an err ...Show All

• Visual Studio Express Editions Questions / Answers : Evaluation Outlines !!!

  I am developing an ITS System , in the Evaluation Stage , can someone help me with the outlines for developing the evaluation : What is the most approciate way for storing the Questions and Answers : Multiple Choices , TRUE / FALSE , and any other Questions and Answers form and ... What is the best way for Representing the Questions and Answers to the Learner and ... Finally Thank you so much :) Ken_L wrote: If all have access to a SQL server create tables that house the questions and answers - one table for each. The question table should reference the correct answer in the answers table. This way you can have multiple possible answers for the same question. If ...Show All

• Visual Basic Best method to restrict input

  I need to restrict the input in a text box to '0 to 9' max 10 digits or 'NA' max 2 char. allowing for the backspace. Can anyone suggest the best method. If regex is suggested I would need the formula. You can validate input in validating event with regex: Regex.IsMatch( <string> , "^\d{0,10}$" ) 'this match a string with 0-10 digits Regex.IsMatch( <string> , ^[a-zA-z]{0,2}$" ) 'this match a string with 0-2 chars beetween a and z case insensitive... ...Show All

• Windows Forms useing this control

  how can i use the control that is in date time properties in windows operating systethe control that is changes the time . ...Show All

• Software Development for Windows Vista XPS Viewer Scriptable?

  Hi, I was wondering if the XPS Viewer will be scriptable. In other words, will we be able to add it to a web page as an active X and control what it is displaying. We have some fairly large XPS files (>5MB) and we'd like to only send them page per page based on what the user wants to see. Will that be feasible Thank you, Tony. Hi Tony, The XPS viewer that ships as part of Windows Vista is not scriptable but it is built using the Windows Presentation Foundation APIs which should help you accomplish your scenario. Take a look at the DocumentViewer control in the .NET Framework 3.0 SDK for the details on this viewer. Thanks, -Tim ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Why is Game not a singleton?

  I'm a bit puzzled by this  - why is the game class not a singleton, i.e. there is and can be only ever one instance of it. I can't quite see any sensible reason to have more than one of them, but as it doesn't seem to be a singleton, I have to hold a reference to it anywhere I want to access game services from. Otherwise I could have just written Game.Instance.Services when I wanted access to them. Or perhaps I have missed something obvious (I know I can make my class that is derived from Game use this pattern, I'm just curious as to why it wasn't done like this in the framework in case I shouldn't be doing it either). I dont see why you cant add some static members to game to do just t ...Show All

• Visual C++ Vc++ 2005 express, how do i compile

  how do i compile a sample.cpp file located somewere on my computer like in mydocuements im a tottal noob can someone tell me how to compile the code i wrote or point me in the directions with some urls or somthing please lol I am using Vc++ Exrpess Edition. I open a new WIN32 Cosole App. The next window that comes up is asking me what the name of the new project is going to be and where do I put it. Nowhere do I see anything about turning off the pre-compiled headers or anything about an empty project. I know I must be missing something. Can you help me out ...Show All

• Visual Basic DecimalPlaces property missing in NumericUpDown?????

  I am writing a Visual Basic application for PocketPC 2003, using Visual Studio 2005. I want a NumericUpDown control with an increment value of 0.1. If I just try to set the increment value to that, it is stored as 0 and the control doesn't work. Reading the online documentation, it looks as if I should set the DecimalPlaces property, but when I look for this property, I can't find it. If I try to change it programatically: myUpDown.DecimalPlaces=1 I get an error, that the property does not exist. Any idea what I am doing wrong, or if this is a bug and if there is a work-around Thanks Larry Gatlin, How is your problem going Actually your problem is very strange because there is a property called Decima ...Show All

• Visual Studio 2008 (Pre-release) Localization question?

  Hi, If I have several assemblies (say one is the main window and another is a control library), is anyway I can put localization resource for both assemblies into one satelite dll. All examples I see seems suggests I have to create two satelite dls using msbuild and locbaml. thanks chong ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XACT audio sounds cutting out

  Hi all, I have a static class I'm using to play sounds loaded in the content pipeline through an xact audio project. In my game, several of the same sound can be played within a few milliseconds of each other. They're basically explosion sounds. Now when I hit more than three of these objects and they play their sound within a short space of time, the sounds cut each other out and sometimes don't play at all which is very poor. I'm not limiting instances in the audio project although I've tried every permutation of this I can think of anyway. I know about the garbage collection issue when using cue objects that aren't referenced etc. but I'm actually just using soundbank.playsound and not getting the cue object at all. ...Show All

• Visual Studio C#/Crystal Reports Application Deployment

  Setup program with merge files (created exactly as it is described in MSDN and many aricles) successfully installes my program on my development computer and on two other computers but failed to install on any other computer Setup process is interrupted with the message: Unable to get installer types in the C:\Program Files\...\MyAplication.exe assembly. --> Unable to load one or more of the requested types. Retrieve the LoaderException property for more information. All steps I do are have carefully checked against tens of articles. There is a difference between three computers which allow installation and all other which do not allow. Before to start develop the application I used those three computers for ...Show All

• SQL Server Iterating the rows of a script component

  Hi There, Can someone please let me know what is the best way to iterate the output rows of a script component and stick in those ids in a where clause of a select query (to retrieve additional info from a database) Is this possible at all If not, what is the best way to deal with this situation Thanks a lot!! Sam_res03 wrote: Hi There, Can someone please let me know what is the best way to iterate the output rows of a script component and stick in those ids in a where clause of a select query (to retrieve additional info from a database) Is this possible at all If not, what is the best way to deal with this situation Thanks a lot!! Probably the best way is to push the data into recordset destination a ...Show All