Scott_programmer's Q&A profile

• SQL Server Processadd Dimension

  Because I have a very large subscriber dimension and the oracle temp space of the underlying Oracle db is limited, I want to do a processadd on a dimension. The dimension is defined in a named query. In the original Datasource view, the where clause limits the result set to 'NL'. I created a new DS view with only the subscriber named query in it. I copied this code in the xmla script and I changed the DS name to the original one. In this script, I also specified the where clause to take the 'UK' records. Allthough the xmla script is being executed without error messages, it seems to ignore the ds view part and always queries on 'NL' instead of 'UK'. Below, you can find the xmla source. I cannot figure out what is wrong here! ...Show All

• SQL Server sql

  1 1 100 2 1 NULL 3 1 NULL 1 2 200 2 2 NULL 3 2 NULL 1 3 300 2 3 NULL 3 3 NULL to this. 1 1 100 2 1 100 3 1 100 1 2 200 2 2 200 3 2 200 1 3 300 2 3 300 3 3 300 hi, i need sql to do this. how SELECT t1 . a , t1 . b , t2 . maxC FROM mytestx t1 INNER JOIN ( select b , max ( c ) as maxC from ...Show All

• Smart Device Development Getting file's directory

  I'm trying to get the full directory path for a file in VB .NET and have tried a variety of techniques.  My biggest problem is either a 'NULL' return or a "" return. Attempts include: 1. FileSystemInfo.FullName .... this returns a Null 2. FileInfo.Directory....returns a Null How do I get this work without it returning a null result Hi, try this using System.IO; FileInfo File = new FileInfo (FileFullPath ); Directory = File.Directory.ToString(); thanks ...Show All

• Visual C++ How to restrict a user from 'Deleting' a file by pressing DELETE key on Keyboard..???

  Hi, Here, I want to restrict a user from Deleting a file Manually (i.e, 1. By pressing DELETE Key on keyboard 2. Right-Click on file and selecting Delete. ) In MS-Word 2003, If a file is Opened, and we are trying to Delete it, it gives an error message like, " The file abc.doc cannot be delete : The file abc.doc is in use by following program Microsoft word . The file must be closed before delete." I want exact functionality as above. Could any one help me. HANDLE hFile = ::CreateFile(L "1.txt" , GENERIC_READ, 0, NULL, OPEN_EXISTING, FILE_ATTRIBUTE_NORMAL, NULL); cin.get(); It works, while you do not press ENTER in console no one can de ...Show All

• Software Development for Windows Vista Vista control panel (link and icon)

  Hi, All, I've developed a 3rd party control panel applet for Vista and basically it works fine. But I have two issues about the control panel item: 1. How can I add a custom link under the main description of my control panel item in non-classic view (e.g. the "Adjust system volume" link of "Sound" control) 2. How to provide different size icon in classic view I have a all-size (from 16x16 to 256x256) icon in the resource and use LoadIcon function to return the icon handle as the hIcon member of LPNEWCPLINFO structure. However, it seems like the explorer always use 48x48 one and make the icon looks pretty ugly in "Extra large Icons" view. Any comment will be very appreciated. Thanks, Kevin ...Show All

• Visual Studio macro to build MSI project - get popup when I set Version property

  OK, I've written a macro to build a MSI project, incrementing the version and setting the productcode GUID. However, as soon as I set the Version property I get a popup saying "It is recommended that the ProductCode be changed if you change the version. Do you want to do this ". I run this macro from the command line as part of an automatde build but this popup stops the build. It didnt do this in VS2003, but it does in VS2005. Any solutions: ways to suppress popups, or anything else Order doesnt seem to matter (ie version before ProductCode or after) Code: Dim prop As EnvDTE.Property Dim propVersion As EnvDTE.Property ' get the project version property propVersion = GetPropertyByName(proj.Properties, ...Show All

• .NET Development How to receive Fax

  I wanna develop a program, which likes Windows FaxMonitor. How do I program Liu, Unfortunately, there is no C#/.NEt API for fax API. The Windows SDK seems to be very comprehensive enough and there are examples on how to do this on the web. http://windowssdk.msdn.microsoft.com/en-us/library/ms693385.aspx there is not much help you are going to get on this forum. You need to get through the Web pages and understand how to do this yourself. Good luck ...Show All

• Visual Basic Why does the file reference change to the local copy?

  Hi, Project A references a dll (Project B). This reference's 'Copy Local' property is set to true. Build Project A and a copy of the referenced dll is created in Project A's directory, great. Now; change Project B and rebuild.. ..the instant that vs2005 deletes the dll during the rebuild, Project A says, 'hey.. where's that dll i'm referencing gone ' .. and then proceeds to remove my original reference to the dll, and replace it with a reference to the local copy. This means, whenever I make changes to my dll (Project B), I have to remove the 'changed reference' and add back the correct one. This can't be how it's supposed to work ! Is there a setting called.. "When a referenced dll 'doesn't exist anymore', don't try ...Show All

• Visual Studio Express Editions how to configure VC++ Express Edition for Open GL support !!!!

  Hi Guys !!! Sorry for talking about a topic already being talked about a lot, but i have a genuine problem configuring my VC++ express edition with OpenGl. I know I need platform SDK to be able to work upon Open GL with my Express Edition, but here's the bottleneck, when i try to install Platform SDK on my machine ( AMD Athlon Powered) I tried exe's corresponding all three architectures mentioned ( PSDK-x86.exe, PSDK-ia64.exe, PSDK-amd64.exe). None worked. The last two simply flagged an error message " not a valid win32 application ", whereas ruuning PSDK-x86.exe flags " the package could not be opened , make sure the package exist and that u can access it, or contact application vendor to verify that this is a valid window ...Show All

• Visual Studio Team System XML report does not show excluded and absent messages.

  Hi all, I have an FxCop project with certain active, excluded and absent messages but while I save the report, the excluded and absent messages are not saved in the XML. Only active message are saved. The option in project default for excluded and absent messages are checked still the report doesnot contain excluded and active messages. I want all the messages in the report. Please anybody help me in solving the problem.Thanks in advance. Although the Project default's show that excluded and absent messages are checked, can you check the actual Project's option (Project -> Options) Regards David ...Show All

• Visual Studio Problems with VS2005 download

  Hi, When I try to download Visual Studio 2005 Professional Edition 90-Day Trial I get only some .img file 631 byte big What is problem From home works fine, but from company I still have a problem I will check this with IT people, maybe is something with PC settings or internet access ...Show All

• Visual Studio Express Editions Chart Control

  I have upgraded a VB 6 application that has a chart.  The upgrade was successful but when I run the application I get the following error: System.InvalidOperationException was unhandled   Message="An error occurred creating the form. See Exception.InnerException for details.  The error is: Unable to get the window handle for the 'AxMSChart' control. Windowless ActiveX controls are not supported."   Source="WindowsApplication1"   StackTrace:        at WindowsApplication1.My.MyProject.MyForms.Create__Instance__[T](T Instance) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 180        at WindowsApplication1.My.MyProject.MyForms.get_Form1()   &nb ...Show All

• Visual Basic Can SOMEBODY HELP?

  Dear all, i develop my VB AP,but now i have a trouble.... i want put a new control object in my form (my form already put many control object) when i want add new ....it say its up limits so i can't ad any control object.. how can i slove thos problem thanks a lot . Take a look at this: http://www.informit.com/articles/article.asp p=25448&rl=1 ...Show All

• Visual Studio Team System error 1402 installing virtual server 2005 R2

  Installing virtual server 2005 R2 on a Windows XP OS, I'am getting the error "Error 1402 could not open HKEY_LOCAL_MACHINE \Software\Classes\Msxml2.DomDocument.4.0\CLSID Verify that you have sufficient access to that key, or contact your support personnel". My UserId has admin rights so I don't think that access rights are the problem. Logged under the local admin account and tried again. Same error. I tried on un Lap top with windows Xp and all is OK. Why I need help aurelio I had the same problem installing Virtual PC, and the solution that worked for me was provided by Michael Iacoviello as shown below: Open regedit, and navigate to HKLM\Software\Classes Delete all regi ...Show All

• Visual Basic TextBox to RichTextBox???

  I want to take info from two input TextBox's and insert it into a richtextbox Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If TextBox1.Text = "" Then MsgBox("Please add text before adding a item") TextBox2.Text = "" Else RichTextBox1(TextBox1.Text) TextBox1.Text = "" RichTextBox1(TextBox2.Text) TextBox2.Text = "" End If End Sub I just need help with what to put after the RichTextBox1. . (TextBox1.Text) How about Richtextbox1.text = textbox1.text Or if you want to add both Richtextbox1.text = textbox1.text & textbox2.text ...Show All