Fradam's Q&A profile

• Visual Studio Team System Data Generation - Unable to bypass circular references

  I'm trying to create a generation plan for my database but keep hitting the problem of "Table <x>: The Data Generation plan contains a circular reference. Population cannot continue". Note that I didn't design this database There are two tables, Survey and Property. Survey is many-to-one related to Property, and so has a foreign key of the PropertyId On Property there is a column called SurveyToUse which is a foreign key to Survey. Apparently there is nothing I can do to avoid the error. In theory, I should be able to deselect generation of the SurveyToUse column in Property (it's nullable), which will avoid the circular reference. Sadly this doesn't work. Is there anything I can do to get around ...Show All

• SQL Server include column from table in SELECT in an INSERT OUTPUT clause

  Hey All – I am having problems with the OUTPUT clause in an INSERT. I have something like this: INSERT INTO dbo.Person ( PersonID ,Name ) OUTPUT p.AuditVersionGUID ,inserted.PersonID ,inserted.Name INTO dbo.PersonAudit ( AuditVersionGUID ,PersonID ,Name ) SELECT p.PersonID, p.Name FROM #Person p AuditVersionGUID is not and shouldn’t be defined on the Person table but I do have it defined in my #Person table. I get this error: Msg 4104, Level 16, State 1, Procedure spExtractPerson, Line 275 The multi-part identifier "P.AuditVersionGUID" could not be bound. I can accomplish this when I ...Show All

• Windows Forms PrintDocument quality is bad

  I made a code to a barcode, I made a class return an image to draw the barcode and the other text i need in the label then print it through a PrintDocumnet I draw the image: private void printDocument1_PrintPage( object sender, System.Drawing.Printing. PrintPageEventArgs e) { using ( Graphics g = e.Graphics) { Font fnt = new Font ( "verdana" , 8); g.DrawImage(SPMSBarcode(c1BarCode1.Image, textboxText1.Text, textboxText2.Text), 0, 0); } } then the quality of the print out is bad BUT if I draw directlly to the printDocumnet (without the class) the print out is very good. So is there any lossing in any thing while using the class or what regards, Yeah exactly. I wish someone would answer this. ...Show All

• Visual Studio Express Editions Type comparison: GetType, TypeOf, Equals.... which one is most efficient?

  Hi folks; suppose I want to figure out what type a certain control is. Then, what is the most efficient way to do it - use If (ctrl.GetType Is GetType(ComboBox) )Then ..... - or If (ctrl.GetType = GetType(ComboBox) )Then ..... - or If (ctrl.GetType.Equals(GetType(ComboBox)) Then ... - or If (TypeOf ctrl Is ComboBox) Then .... The first three can be used w. With ctrl < statements> End With, the last one is easier to read. But apart from that, is there any difference Greetings, Thymen You know what All of these questions really are answerable and there are two tools to do it. Reflector is a program available on the net. that will dissable a program and take ...Show All

• SQL Server Dimension processing taking too long

  A regular dimension with some hierarchies is defined. StorageMode:Molap ProcessingGroup:ByAttribute ProcessingMode:Regular then on processing this dimension individually, why is a "select distinct" from the relational table done for each attribute of the dimension separately and finally a select distinct <all attribs> is done in one query. What is the purpose of this this slows down processing for a large dimension table. This is not done for rolap dimensions though. Is there a way to speed up processing for Molap dimensions. Also what is the significance of the ProcessingGroup property for a dimension Regards mat Processing by table seems to process all dimensions from t ...Show All

• Visual Basic Cannot debug converted programs from 2002 to 2005

  Good Morning, I have converted several programs from 2002 vb .net to 2005 vb .net. I have notice while stepping through my code I can't step into (F8) the code of a converted dll like I could in 2002. I have even tried the debugging keys from 2002 and they just step over the code also. When using these keys the debugger steps over the code like I was pressing Shift + F8 keys. I need to step into this dll since the converted dll code is now throwing errors which are not there in the 2002 code. Is this a known bug If so is there a fix for it or will it be released in the near future We cannot migrate to the 2005 version until this is fixed since there are other issues as described above. Thank you for your time. ceoliver ...Show All

• Visual Studio Team System Project Portals stop working after restoring TFS from backups

  Synopsis of Problem: After restoring TFS from backups, the Project Portals cease working. When I try to load one I get the error message "The virtual server that is referenced here is not in the config database.". Full Story: In my evaluation of Team Foundation Server I decided to see how smoothly a backup and restore would go. The backup was easy enough. I backed up all the TFS databases (per this article ) and the reporting services encryption key (per this article ). With backups safely stored on a separate machine I wiped the server running TFS, reinstalled Server 2003, applied all available updates, and started the TFS install by following the instructions found in the installation guide for a single server configuration. ...Show All

• Windows Forms Data Grid internal optimization

  I have a general question about datagrids in win form application: Is there an internal optimization routines that kicks in when there is a large data to display I did some timing tests and discovered that it takes less time to display 20,000 rows of data with 66 columns that it would take to display 20,000 rows with only 33 columns. Thanks. ...Show All

• Microsoft ISV Community Center Forums MS Access pivot table problem, field list not available & can't drill down

  I'm having the follow problem: I'm extending an existent Access project that uses Access 2002 as the front end and connects to a SQL Server 2000 back end database. I have trouble modifing the existent pivot tables. When a pivot table is displayed, I don't have access to the Field List(The Field List button on the toolbar is dimmed. When I right click the mouse, all the items on the popup menu are dimmed as well). Also I cann't filter the displayed data by checking or unchecking the check marks next to field data. The check marks are not checkable. This problem only comes up in my computer. If I open the database project in another computer, everything works. I tried loging in as an administrator. It didn't help. I tried uninstall MS ...Show All

• Visual Studio Problem with SourceSafe and Visual C++ .Net 2003

  Ok, I added new dlg class to the project and it worked fine as always leaving both the .h and .cpp checked out. I did some editing in those files, and when I went to add a message handler, I got the error message "Add/Remove of the function is impossible, because the parent class code is read only" Now, I KNOW it's not read only both the dlg's .h and .cpp are checked out! Also, in an act of frustration, I checked out all the files in the project, and it still gave me that error. Any help would be GREATLY appreciated!! Thanks guys, Jeff It has nothing to do with VSS. Check the MESSAGE_MAP. You've probably added then manually removed the message handler's code but forgot to remove it from th ...Show All

• Windows Live Developer Forums Question about Bot SDK's

  I want to write simple natural language processing chat bot, and I spent almost entire day trying to find the proper SDK for the job. Here are some of my experiences: - Colloquis was acquired by Microsoft and their BuddyScript SDK is currently unavailable for download, and nobody knows when MS will issue a new version. - Incesoft SDK seems like a nice option, but administrative panel is incredibly slow (most of the users are complaining about their servers and leaving the entire platform), and i couldnt get the echo bot working. Probably had something to do with their servers... - Akonix L7 - At first glance, this project looked really promising, but as soon as i started making something, bunch of problems appeared. It just seems like it' ...Show All

• SQL Server Check all databases for file space used

  Hi There As part of monitoring i want to hourly check the data file percentage used for each database, to monitor growth and know in advance when a data file will be full. However i do not want to write a job for ever single database , this instance may have up to 100 databases that = 100 jobs. So i want to write a job that checks the percentage space used for all databases. My first dilema is that i cannot loop through databases dynamically, by that i mean if i use a cursor that loops through database names, and i dynamically build sql the say 'USE @DBNAME' and execute it the cursor context stays local you do not actually change database context. So how do i loop though databases, i have found sp_msforeachdb, however th ...Show All

• Visual Studio Express Editions VB Express messes up the text file when it creates it... Help

  Using the writealltext command, I generate a simple txt file (actually ends with .cmd) - everything looks fine in Windows and notepad BUT when I open it in the commandline window (since I am using this as a console applicatin) and chose "edit filename.cmd" the first four characters that are generated are non caracters !! (graphic ascii actually). Of course things are not working correctly - I also get a "header" error when running the cmd file - but there is no "header" of course. So what has VB express done to me Anybody have any ideas The pertinent lines would be the following Dim jdppart1 As String = "D:\... etc" Dim jdppart2 As String = " -user...etc" Di ...Show All

• .NET Development TcpListener

  Hi. I'm trying to make a simple application which receives data from a local host and displays it. Everything works fine upto the point where it's supposed to connect to theclient. However, when I type in whatever I want to send, I keep waiting for it to come back...an eternity thingy. Heres the code: using System; using System.Collections.Generic; using System.Text; using System.IO; using System.Net; using System.Net.Sockets; namespace MyTcpListener { class Listener { public static void Main() { TcpListener server = null ; try { Int32 port = 9000; IPAddress localAddr = IPAddress .Parse( "127.0.0.1" ); server = new TcpListener (localAddr, ...Show All

• Visual C# Multiple Edition management with VS 2005

  Hi All, Here is the big question : Suppose to need to compile the Basic, Standard and Pro editions of you app. What will you do inside VS2005 (each edition contains a different set of file/classes but, obviously, the most are shared between each app edition) 1) I create 3 project (Basic, Standard and Pro) and link the shared files/classes from the first. 2) I use conditional compiling, placing the classes inside an #if PROEDITION #endif statement. 3) I build 3 different asseblies and merge them using ILMerge. 4) Other. Thanks so much for your thoughts, I want to start with the right foot! Alberto Alberto, I think it's going to depend on how many differences there are between the different projects. I'd ...Show All