eldiener's Q&A profile

• SQL Server INFORMATION_SCHEMA: Probably bug in SQL-2005

  Try to run this script, first in any database under SQL-2000, then in SQL-2005: select COLUMN_DEFAULT from INFORMATION_SCHEMA . COLUMNS WHERE COLUMN_DEFAULT IS NOT NULL In SQL-2000 values of the defaults are in single pair of brackets: COLUMN_DEFAULT --------------- ('') (0) ('') (0) (0) (getdate()) (db_name()) (1) (21) (N'anonymous') In SQL-2005 integer values are in double brackets, and all other defaults - in single brackets: COLUMN_DEFAULT --------------- ('') ((0)) ('') ((0)) ((0)) (getdate()) (db_name()) ((1)) ((21)) (N'anonymous') At the same time, OpenSchema method of ADO: Connection.OpenSchema(adSchemaColumns) returns different defaults in SQL2000 and SQL2005. In SQL2000 column defaults a ...Show All

• Gadgets file is .gadget but IE downloads as .zip

  I have packed my gadget files in a zip file. I then changed the name to *.gadget. The icon changed to a gadget icon and double-clicking it installs it. I then uploaded the file to my webserver and it is there are a gadget file. I then linked to it as a gadget file. When I click that link it downloads a .zip file and asks where to save it rather than downloading as a gadget file and installing. What am i doing wrong Here is what I think is the final fix. I was finally able to upload a valid gadget to Microsoft. (Still pending approval). 1. Create the widget 2. Compress the widget as a foo.cab file 3. Rename foo.cab to foo.zip 4. Microsoft will rename foo.zip to foo.gadget That shou ...Show All

• Windows Forms Button to Form Communication

  I have an array of buttons shown on my form. My buttons are of a custom type that inherits from Button. As is supposed to be, when I click the buttons, their OnClick method is called. I need to keep track of every two buttons that are clicked, such as a this button was clicked first, this one second kind of thing. How can I go about that Use a form variable to keep track of the last button pressed and the currentbutton Dim TheLastButton As Button = Nothing Dim TheCurrentButton As Button = Nothing Private Sub Button1_Click ( ByVal sender As Object , ByVal e As System . EventArgs ) Handles Button1 . Click, handles Button2.Click TheCurrentButton = DirectCa ...Show All

• Visual Studio Express Editions Hiding other programs

  Is there anyway to hide other program windows, for example lets say I'm on the computer using messenger and looking at hotmail while posting pictures on yahoo and don't want soemone to see what I am doing when they walk in, at that point I would press my predefined keyy and it would all "hide" posible or impossible I don't have any idea's but I need one before the end of the night so please shed some light. Average Joe technically it would be pointless if you can do it via Windows keys anyway (your keyboard) or by clicking the show desktop icon in the quick launch area. However: http://msdn2.microsoft.com/en-us/library/system.windows.forms.sendkeys.sendwait.aspx http://msdn2.microsoft.c ...Show All

• Visual Basic PInvoke unbalanced the stack kernel32.dll

  Hi, I am trying to learn how to use the Ghostscript API following the Ghostscript vb.net code example in “parrot fashion”. I do not have sufficient technical knowledge to understand error messages or the implications. I am picking up an error message during the code implementation. I suspect it is because the version of kernel32.dll on my computer is incompatible with the vb.net source code. Any pointers where I can learn about PInvoke and stacks will be much appreciated. Any help in pointing me in the right direction is appreciated. HerbiNZ New Zealand ------------------------------------------------------------------------ File: kernel32.dll Name: Window ...Show All

• Visual Studio How to execute a custom debug engine ? Thanks !

  We have already wrote a custom debug engine, using the TextInterpreter as the guide. But we always failed when try to execute it. We successful modified and compiled the MyCPrj sample project followed by the TextInterpreter tour. First we start the Visual Studio 2005 Exp hive, then we create a custom project type MyC project, next when we try to select Properties , we will hang the system. So could anyone help me to solve this issue We use Visual Studio SDK v3 and Visual Studio 2005 Professional Edition Thanks !! Hi, The easiest way to launch a custom debug engine that I found is to make a new VSPackage with a menu item which when clicked calls IVsDebugger2.LaunchDebugTargets2 with a VsDebugTargetInfo2 structure. The guid ...Show All

• Visual FoxPro how to know which field i index

  hi all, i 1 idx but i dun have documentation to know which fields it index. so i just use set index to idx then set order to && it shown the field. hehe but is that the only way to know or got other method thanks in advance. Yanyee, IDX are out since years. Use structural compact indexes instead. In any case you can check an index's expression using key(). ...Show All

• Windows Forms Master detail Records

  Hi! I am learning VB.Net programming and having some problem with master detail records. It works fine when I follow all the norms of master detail data entry i.e. when I insert a record in master table and save that record and then add the records in child table using grid then everything works fine and even the grid automatically displays the value of the field which is common in both the tables. But the problem is that I've a situation in which I've to enter the master and details record at the same time. Actually I am creating a loan registration form, in which along with all other details of the loan, I have to enter the details of the guarantors, the number of guarantors depends on the amount of the loan taken. So whenever I wi ...Show All

• Visual C# change the resolution of the system by programatically

  My system is having 1152 * 864 pixel resolution environments. Here I am developing an application and its working fine. Whereas in another machine is having 1024*758 pixel resolution. In this resolution some of the UI controls are invisible. Can anyone help me to work my application in any resolution, with out doing anything manually I assume then that you are probably creating a form that is bigger than 1024*768. In this case when it is displayed on a 1024x display some of the controls will be clipped. You should develop your forms so they fit in a 1024x pixel display. This should resolve the display issues. Michael Taylor - 12/11/06 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Multiuser games?

  Just curious... but has anyone used XNA/C# to develop MOG's or even MMOG's AndyL wrote: Back on topic - the performance of a MMORPG server is all about architecture and nothing about raw language performance. If you have the skill set to design such a system, and the time, it could be implemented equally well in C++, C# or Java. But you have to understand how to build a system that scales well across 50 to 100 servers if you are going to emulate something like Everquest. Agreed completely - just look at Second Life - they have their own interpreted language that is used for the server-side scripting of every object in the game world! I'm interested in that kind of stuff, so I found this video particularly ...Show All

• .NET Development Updating using ADO.Net

  Good Afternoon, I have database in SQL Server Version 8. I have also created a switchboard and Database Forms in VB.Net. The Client that the database has been created for specified that all database transactions need to be performed using ADO.Net. The forms are using the SQLConnection object to connect to the database to fill both the Data adpter and the Data set used to populate the form controls. Where my problem is, I cannot get the changes made in the VB.Net forms to be reflected in the database. If anyone could help me that would be greatly appreciated. Cheers, Bryan Bingham GIS-Applications Specialist Geomatics Technician Hi, Just to add on what Sohail Iqbal 's answer, you must ensure ...Show All

• Visual C# Odd VS 2005 reference warnings. "The referenced component 'System' could not be found."

  Does anyone know why (or even better, how to fix) VS 2005 randomly generates warnings like: "The referenced component 'Some .NET assembly' could not be found." then when you click on the reference in the Solution Explorer, it magically fixes whatever problem it thought it had How do I stop these warnings from showing up again Thanks for any help with this. dougzhoez Your not alone. I too have seen the same messages. As a matter of fact, I just rebooted my computer and opened a solution in VS2005 and saw: The referenced component 'System' could not be found. The referenced component 'System.Data' could not be found. The referenced component 'System.Deployment' could not be found ...Show All

• SQL Server Need help to build the MDX query please?

  I need help on how to do this in MDX query. I have an OLAP cube with the following structure as an example Measures: M Dimension A: Attritute 1, Attritute 2, Attritute 3 Dimension B: Attritute 4, Attritute 5 (date/time) Dimension C: Attritute 6, Attritute 7 I need the dataset with all the attritutes and measures of this cube for the Reporting Services. First of all Attritute 1 and Attritute 5 are the parameters (cascade prompt) for the report. Based on this parameters it will filter out the Attritute 6 to a smaller subset of the original data. Then I need to apply the Attritute 1 (again) and the "filtered" Attritute 6 to filter out the cube data with the condition that Attritute 5 is less than or equal to the Attritute 5 selected ...Show All

• Visual Studio How would you improve MSBuild?

  Hello MSBuild Users, Just a reminder that we're always interested in suggestions for improving MSBuild. For small suggestions, the best route is via opening a suggestion at https://connect.microsoft.com/feedback/Search.aspx SiteID=210 . If there's a small change or improvement you'd like to see, that isn't really a bug, I'd encourage you to open a suggestion there: we can track it, and if it's possible, appropriate, and we have time, we'll address it. For big suggestions ("please implement distributed build", "please add native code support") that's probably not a good way. Instead I'd suggest you let us know via this forum -- for example, by replying to this post. The team would like to know what's important to you and wha ...Show All

• Visual FoxPro Copy and Past function under VFP9

  I found the Ctrl+C and Ctrl+V function under VFP9 is not working on the users' end. Sometimes, I found the same problem on my PC. What seems to be the problem Thank you both. How do I check the system main menu In my main application menu, I do have a submenu called Edit and short cut keys for Ctrl+C and Ctrl+V, labeled as Copy , Paste. I modified my menu and got a prompt sth. like "Do you want to update the menu." I click "Yes" and rebult the project and rebuilt the exe file. But when I dump it to the user's side, it still does not work. You type some words, and highlight them. You found they were replaced by some sentences from your Email. You have to erase a ...Show All