AndyL's Q&A profile

• SQL Server IDE for rss scripts.

  Is there any IDE present for writing .rss scripts which are read by the rs utility ...Show All

• SQL Server Semi-Additive Account BUG

  Hi,   I'm having a problem with semi-additive measures when I try to change the value of a account (lastnotempty type of account), like these (it's in my cube calculation):   CALCULATE; scope ([Tempo].[Tempo]. ALLMEMBERS , leaves ([Entidade]), leaves ([Produto]), leaves ([Cenario])); ([Conta].[Conta].[ESTOQUE PREVISTO], DESCENDANTS ([Tempo].[Tempo].[Todos(as) Tempo],, leaves )) = ([Conta].[Conta].[PREVISAO DE VENDAS], [Tempo].[Tempo]. CURRENTMEMBER . PREVMEMBER ) + 100; end scope ;   It didn't do any thing, all the members of the scope still with the value null. But if I change the account type to flow that uses a sum to aggregate it works fin ...Show All

• Visual C++ VC++2005 Behaviour When Reading Numbers Followed By Commas

  I’m having a problem in Visual C++ 2005 with a program that works fine in earlier versions as well as in compilers like Dev-CPP. I’ve got a file containing a series of records one on each line. Each record starts with a date followed by a series of comma separated numbers. When reading the dates in Visual C++ 2005 the program fails on the first year component which is the first value followed by a comma. To illustrate the problem I’ve written the below program. #include <iostream> #include <fstream> using namespace std; int main(int argc, char *argv[]) { ifstream fin("records.txt"); int iCurrentDay = -1; int iCurrentMonth = -1; int iCurrentYear = -1; while (fin.good()) { fin >> iCurrentDay; fin.ig ...Show All

• SQL Server Page break in report with subreports; is it a bug?

  Hi, I need an OLAP report with measures on rows and Actual 2004, Actual 2005, YTD 2006, Forecast 2006, Budget 2007, Forecast 2008 and Forecast 2009 on colums. I have done this by building a matrix-report for the Actual 2004 data. For each other column, I build a subreport also with a matrix control. Each subreport I placed exactly beside the matrix of the main-report and so on. In short words, each column of the Main-Report is a subreport. In each subreport, i have hidden the first text column in the matrix, so the report does exactly what I want and looks very good. My problem: Each matrix consists of 60 rows. When I view the report in a browser, in each subreport all rows will be displayed at the first page, only the matrix control in ...Show All

• .NET Development CodeDomProvider.Parse

  I am developing a simple form designer application using C# .NET 2005. I am trying to persist the application from the designer host to SQL server, and later reload it into the designer for further editing after reading it back from the database. Once the application design has been completed, I would like to be able to generate the CodeCompileUnit, generate C# code, compile, and run. (This part is working well). The problem is trying to get the application back onto the designer surface. My plan was to store my application as C# in a varchar(max) field in SQL Server. Then read the text back into a TextReader and recreate the CCU using CodeDomProvider.Parse(). Unfortunately this method is not implemented. Is there a way to get around th ...Show All

• Visual Studio Express Editions I do a use the textbox name with out typing it

  i am trying to take the texbox name and then send it to another procedure without typing the name of the textbox from the leave event of the textbox Normally when you create an event handler say for a windows forms application event there are two parameters - normally the first is sender as object and the second is some kind of EventArgs. Some examples are Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click,Button2Click End Sub The sender is actually identifying which control is initiating this ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. fmod

  i have allso read that fmod player is running on xbox360 and fmod has a c# interface do you have any plans to make support for this windows mobile 5.0 direct3d mobile http://cgempire.com/forum/code-submissions/801-fmod-3-75-wrapper-managed-c-windows-ce.html FModEX it comes with a C# wrapper download http://fmod.org/ ...Show All

• Visual Basic ListBox.Items.Add() doesn't work for me

  Hey everyone, I'm trying to add data to a listbox, but I get a object reference error. Here is a exmaple of my code: The listbox is already on the form: listbox1.Items.Add("Test") listbox1.Items.add("test1") When I run this code, I get a object reference is set to null(System.NullReferenceException) Can anyone help thanks, Brandon M. Hunter I tried both ways: lstBXSC is equal to Nothing Dim lstBx as new ListBox lstBx = lstBXSC lstBX.Items.Add("Test") And I did drag another listbox, and i get this same error. ...Show All

• SQL Server Error when Deploying Cube

  Hey guys, Have a really strange error, I have a AS Cube designed and ready to go. Have been deploying it previosly and was erroring out due to attributes not being found in the tables. So ive worked on fixing all of them and now, i have an error message occuring and all it says is: Server: The Operation has been cancelled. I havnt cancelled anything, it doesnt show any more details for the error either.. Is there a log file somewhere that i can look further into Or has anyone had this message before I am stumpped and now its annoying me as i was so close to having my first cube up and deployed... Thanks in advance Scotty Are you receiving the error when you build and deploy the cube Or does the error happenwh ...Show All

• .NET Development generic DictionaryBase

  In .NET 1.1 there is the DictionaryBase to derive from for own Dictionray classes. What class would I derive from in .NET 2.0 if I where to write a custom generic Dictionary<TKey,TValue> Is there a Generic Base class that adds the basic Dictionary functionality like Dictionarybase does You probably mean ICollection<T>. I wouldn't have to extra implement that interface since IDictonary<TKey,TValue> already derives from it. But anyway - isn't there a baseclass like DictonaryBase that already provides the basic functionality Only for generics ...Show All

• Windows Forms How can i take folder locations from registry or settings file and then specify these as installation paths?

  I am using the Setup Project in VS 2005 How can i take folder locations from registry or settings file and then specify these as installation paths The registry editor has options to add registry entry but no way to read values. I need to read values from both registry as well as files and use these entries (folder locations ) as the installation paths..please help Basically you need a Search Target Machine for the registry item that's a path, and that gets stored into a property you can name. Then in the File System view, add a custom folder that's got that property name in the Property field and [TARGETDIR] in the defualt location in case there is no registry path found. ...Show All

• Microsoft ISV Community Center Forums Refreshing table list in Access

  I have an Access 97 database that uses a large number of temporary tables. To save space my code creates the temporary tables in a new temporary database, and then I link the tables to the original database. Once I have finished with the tables I delete them with SQL e.g. strSQL = "DROP TABLE [tblICIMIndex];" DoCmd.RunSQL (strSQL) Then I delete the temporary database, this gets around the problem of not being able to compress on close the Access 97 db. However, the table list still shows the tables that I had linked until I click on one of the deleted tables. I have tried to refresh the list with the below line of code, but this does not work: CurrentDb().TableDefs.Refresh Any ideas how I can force the refresh o ...Show All

• Windows Forms Microsoft Product Keys

  Hello everybody, I intend to write a proram which can detect Microsoft Product Keys, such as Microsoft Windows, Microsoft Office, Microsoft Visual Studio... from the registry. But I don't know how to begin. Can you help me If you know an open source similar software, that is great ! Or can you teach me how to to this not really possible. To me sounds like you maybe planning to do some hacking, in otherwords, to obtain the product keys and log it and distribute it. Tut!. However I believe the Product Keys are not stored on the computer but perhaps uniquely generated as a different type of a product key than the one you enter when prompted during installation. why do you want to do this ...Show All

• Visual C# Regex to split a string

  Hi Guys, I am currently working on ripping some information from a text file. I am trying to use regex to split up some strings. I.e. text file has this line Serial Number .............................. ABC123456AB I need to just get the "ABC123456AB" part. So far I have not been able to work out the regex for it. I would like to search for " Serial Number .............................. " and return just the AB123456AB part. Cheers Wilson Hi, try it with the following regexp: text = "Serial Number .............................. ABC123456AB" ; Match match1 = Regex .Match(text, "( <=Serial Number\\s+\\.+\\s+).*" ); Andrej ...Show All

• Visual C# DataKeyCollection' does not contain a definition for 'Item'

  Compiler Error Message: CS0117: 'System.Web.UI.WebControls.DataKeyCollection' does not contain a definition for 'Item' In VB, I used to use it this way, but in C#, the compiler complains as above mentioned. Can anybody tell me why Thks!   void griddelete(Object Sender, DataGridCommandEventArgs E) {   articlecolumn artcol = new articlecolumn();  artcol.colid = labcolid.Text;  artcol.articleid = dg.DataKeys.Item(E.Item.ItemIndex); //<--error line   if (artcol.deletebycolidarticleid)  {   labinfo.Text = "Deleting Success!";  }  else  {   labinfo.Text = "Deleting Failure!";  }  artcol = null;  dg.EditItemIndex = -1;  bindgrid(); } ...Show All