Lakshmi's Q&A profile

• SQL Server How to flag a row and allow max one row flagged in the table.

  Hi, I am new to SQL. which is the best way to flag a row Create a bit column IsFlagged Additionally, I want to create a table-level constraint that allows max 1 row flagged true in the whole table. I can't nest a select expression in the CREATE TABLE statement CONSTRAINT clause that counts flagged rows. So how do I do this Appreciate the help.   you can do something like this ...Show All

• Visual C++ OpenMP vcomp.dll problem

  Hi everyone, I have just bought and installed Visual Studio 2005 Pro, and I have a problem with its OpenMP support. I have been using the Beta 2 before, and wrote code that uses OpenMP. As you might know, vcomp.dll is required when using OpenMP. The files can be found inside some redist folder of VS 2005. So I copy this file to the executable folder, and try to start the exe. I get an error which says that it tries to load vcomp.dll wrong. Howev ...Show All

• Visual Basic Error Created when opening beta 1 file in beta 2

  How to solve this error i have save the file in beta 1 and when i upgrade to beta 2 I have this following error can some one please help me on this Error 1 Type 'System.Windows.Forms.WindowsFormsApplicationBase' is not defined.  Error 2 'AuthenticationMode' is not a member of 'Forms'.  Error 3 'ShutdownMode' is not a member of 'Forms'.  Option Strict On Option Explicit On Namespace My ...Show All

• Visual Studio Tools for Office Visio drawing control <short question, long response>

  i'm stuck. there is the ultramarvelous masked visio drawing control. perhaps i installed the sdk for visio and look the tutorial documents, the msdn technical articles and etc... i can't realize if i can or not to embed the control in a web application and change the document that belongs to the control. or i'm doomed because just can be changen whit script languaje and just the properties that the control expose, the other way is ...Show All

• Visual Basic Adding or Modifying Records: Updating Data

  I am just begining with VB2005ExpressEdition and learning step by step with the documentation at MSDN. I create a simple DataBase named Database1 with 3 columns and populeted with several rows, at first time, in the SQL enviroment. After that, I take a form at design time and I've drag the tables from dataset to the Form1, creating textbox'es that are related to the DataBase information. All works perfectly, I could see the information that I p ...Show All

• Visual Basic How to specify SQL DB location at runtime

  This was probably answered before but they were probably talking about something else and for the purpose of clarity I'm starting from a new point of view.   My app will ship with a SQL database, however, I want the DB to be placed by the user wherever they like... like on a remote drive How do I move the DB to such a location I thought that if I copied the DB to the new location and changed the path in the connection string it ...Show All

• Visual Studio Tools for Office Referencing Office XP PIAs

  I am writing a custom application where one of the requirements is to use the installed Outlook client to send an email message, using the Outlook 10.0 object library. I downloaded the PIA for Office XP and installed them to the GAC, but I am unable to reference the assembly in my class library project. Of course I can browse to the assembly file and add the reference, but I want to reference the assembly from the GAC for deployment purposes. Is ...Show All

• Visual Studio Express Editions I do not want SP2. I do not want SP2.

  Hi. I run on Windows XP Professional SP1 and I really need Visual Basic .NET Express edition, as SharpDevelop2 is very buggy (atm). The thing is: I do not want SP2. Please do not flood me with comments such as "BUT OMFG SP2 PWNZZZ SP1 ! !" but tell me one good reason why to update into it. Not "security", not "more stable", but something real. Incase it comes with some updates needed by the Visual Studio's, why not ...Show All

• Windows Forms How to set start form

  I had a single window form compiled in a winform project. Now I add a new form, rename the old form with ".sav" extension, move it to an archive folder in the project, recompile the project and am surprised to see the old form&nb ...Show All

• SQL Server Failed SQL 2005 SP1 installations (Hotifx.exe crashes)

  I am seeing repeated failures installing SP1 database services with crashes in hotfix.exe being reported and the following appearing in log files: Property(S): SqlUpgradeMessage = SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL ...Show All

• Visual Basic How to load multi image from one picture file?

  I see that some program are save all of there picture to load from run-time to one picture ( ex: eggsucker) How can i do it how to load multi picture from one image file (.bmp) Bob Powell has a example of loading a multipage tiff file on his website . I dont think there is such a thing as a multipage bitmap. ...Show All

• Windows Forms Can't add new animals ..

  Anyone else having problems when attempting to add a new creature   I get a message that states that there is a problem with the terrarium server, please try again later.  Well ... it's been three days and no luck. The se ...Show All

• Visual Studio Team System Services disappear when restoring TFS data to a different server

  I have been working through the restore to a different server process with TFS Refresh as described in http://blogs.msdn.com/vstsue/articles/500334.aspx . Got to the last step "To make clients to refresh their work item cache data" and I noticed that most of the TFS web services aren't working. For example, http://[applicationTierServerName]:8080/WorkItemTracking/v1.0/ClientService.asmx returns a blank web page. When going to the IIS ...Show All

• Windows Forms what is rating?

  hello sometimes i see on the internet the word rating and beside it i see some stars,so my question what is the real meaning of the rating thank you for the help and for the time hello thank you for these details about  this&n ...Show All

• Visual Basic Why does EnvDTE._DTE.get_CommandBars fails with HRESULT E_FAIL has been returned from a call to a COM component

  In my Addin to Visual Studio 2005 I extend the MenuBar with my own menu for the Addin. Before creating the menu I check to see if the menu already exists and if it does I delete it before creating it. Here is Basic code:  001 Dim menuCommandBar As CommandBar 002 Dim cbc As CommandBarControl 003 menuCommandBar = g_objDTE.CommandBars.item("MenuBar") 004 For Each cbc In g_objDTE.CommandBars.Item("MenuBar").Controls 005   If cbc ...Show All