hte's Q&A profile

• SQL Server Perform upgrade method

  hi I have two versions of the same dataflow component , i need to use the new version component in the packages created using the old version . How can i do this using the perform upgrade method . Thanks Mani You should not remo0ve the old DLL from the GAC becuase the component can no longer be instantiated. The new DLL should be able to live in the GAC with the old DLL because they have different versions (file or assembly or even the PublicTokenKey) Thanks, Ovidiu ...Show All

• Windows Live Developer Forums Mega Cluster logic

  Dr Neil first mentioned this on the via virtual earth site recently and now I need to use them. Just though I would put my ideas out here and see what you all think and can add. To be clear this is a concept and I’m looking for ideas / help before I build it. Basically the issue is you have X number of points to put on the map where X is very large. 1. If you go and add them all it is going to slow down to a crawl. 2. If you have points at a close proximity at certain zoom levels they are going to sit on top of each other and be unhoverable. The solution is to have a mega cluster that provides information about the points it represents. Firstly we need to look at how we calculate what po ...Show All

• SQL Server Inserting counts into a table

  Hi: I would like to count repeating field values in a table, and to insert the counts into the same table. I have managed by having a temp_table, into which I insert the values: insert into temptable values (select count(*) as Count, fieldname from table group by fieldname) I then do a join on table.fieldname=temptable.fieldname, and update table.count with temptable.count. Is very cumbersome, and does not update counts when table changes. Is there a way to put in a calculated member, or to put the vaues of auto stats into the count field TIA Kar hi karfast, you can use UPDATE FROM statement to rid yourself of the temp table UPDATE table SET table.column = t.columnValue ,table ...Show All

• Visual FoxPro Produce error when running the form

  Hi, When running the form, I got the error. The error is "Error loading file - record number 61. grid_detail < or one of its members>. ControlSource : Alias 'NEWDETAIL' is not found." I'm not sure where i go wrong on my form. Thank you. MillBear wrote: My senior IT said that there is a bug in the Visual Foxpro 6 software itself. The codes in the open file and close file method in the Data Environment has switched places. So have to correct them in the right form method. Now the form runs well. Glad to hear it runs now. VFP 6 (a very old version) had a few bugs like all complex software, but not that one. Methods don't "switch places". Someone must have inadvertently done someth ...Show All

• .NET Development advantage of creating static methods

  Hello, Is there an advantage of declaring a method as static, even if it is a private method that is called only from within the instanced class For example: public class MyClass { public void Method1() { ///Do something Method2(); } private static void Method2() { ///Do something } } I'm asking this because I've installed R# on my machine, and it throws a warning on several private methods, saying that they can be made static... Thanks in advance, Matias Yeah, I called it a "leak" only to associate to the content of James' article. It's a "leak" in the sense that you've done everything you can possibly do--without a redesign--for the object to be garbage ...Show All

• Visual Studio Express Editions SQL + DataGridView Question

  I am using SQL in Visual Studio (C#), and would like to have a datagridview listing information from my database. I actually have a couple of questions. 1) I need to track several bits of information (like orders / purchases would be handled) linked to a particular record. Do I need to have a database field called order 1, order 2, etc., or can SQL save multiple bits of information for the same item 2) I would like to have a datagridview that would list all the purchases made from this contact. I would then like to click on the line of the datagridview and have the detailed purchase information populate textboxes in the same window. How can I do this Any help would be greatly appreciated. Thanks, hi, ...Show All

• Visual Studio Express Editions Why would I be getting these errors?

  It seems strange to this newbie why these errors are popping up in a Windows .h file. Can someone enlighten me ------ Rebuild All started: Project: Driver, Configuration: Debug Win32 ------ Deleting intermediate and output files for project 'Driver', configuration 'Debug|Win32' Compiling... driver.cpp D:\WINDDK\3790.1830\inc\ddk\w2k\ntddk.h(7944) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int D:\WINDDK\3790.1830\inc\ddk\w2k\ntddk.h(7944) : error C2146: syntax error : missing ';' before identifier 'InterruptTime' D:\WINDDK\3790.1830\inc\ddk\w2k\ntddk.h(7944) : error C4430: missing type specifier - int assumed. Note: C++ does not support default-int D:\WINDDK\3790.1830\inc ...Show All

• Software Development for Windows Vista Problem with ICredentialProviderSamples

  Hi I got the ICredentialProvider samples from MSDN and I having a strange problem. I modified the sampleCredentialProvider example, to request username and password If there is no user loged on, the CPUS_LOGON scenario, I'm able to login. If the scenario is CPUS_UNLOCK_WORKSTATION I'm unable to logon, I'm using the same account, and the procedures for both scenarios are the same. The error I get is "Username or password invalid" I was able to check the values of the strings via a MessageBox and are OK. The non modified by me version also haves the same problem What could be wrong Thanks in advance It looks like you're using the Beta2 version of the samples. Here's the link to ...Show All

• SQL Server Date lookup in SSIS

  How do I perform a date lookup in SSIS. I have a date with time component in it. This has to be looked-up with a table that contains only a date element.   mike.groh wrote: Vijay: Suresh's suggestion should have worked for you. The conversion statement will look something like this: CONVERT( varchar, <table>.<datetimevalue>, 101 ) The "101" means to convert it to a string in US date format: mm/dd/yyyy CONVERT supports a number of arguments for the output string -- lookup CONVERT in Books Online to see what I mean. As Suresh suggests, you'll probably have to convert the columns in both tables to do the comparison.   Being from the UK mm/dd/yyyy does no ...Show All

• SQL Server have a problem with pericision

  I have been working on an application which require as much percision as we can get. We have defined all numeric values as (38,16) however when ever we divide a number by the result of a built in function it truncate the percision to 5 decimal place this cause us to have a small but enoying loss in the numbers being caculated we need a minimuim of 8 decimal places or better is there a work around or solution for this problem in sql server 2005. The more percision the better. example: select tna/(select sum(tna) from taum) from taum where fund_id = 2345 the result is always 5 decimal places even though fund_id tna = 2569698.23 and sum(tna) =98745612325879.36 which should equal .00000002602341683313994 instead the result = ...Show All

• Community Chat NCover usage, parameters, empty coverage report getting generated

  Hi, I'm new to using ncover and is not aware of the basics of how it can be used to test the coverage of my code and how it goes with generating the covereage report for me. Can some one please let me know any pointers or examples where I can find out how it can be used and what each of the command line parameters stand for I had used the '/ ' to get the description of what each parameter stands for. Somethings which I am not clear are the //a - Assemblies: What should I give here Should it be the .dll file of the test scripts or the .dll file which i'm testing using my test scripts I use the following command to generate the coverage report, which shows an empty page when i open the xml which is generated (TestNCoverXml.xm ...Show All

• SQL Server Articles on foreach loop container over dataflow task?

  Hi everyone, do you know any articles on foreach loop container that loops over a dataflow task...pls tell me.... thanks in advance, Praveen Dayanithi wrote: Hi everyone, do you know any articles on foreach loop container that loops over a dataflow task...pls tell me.... thanks in advance, I presume that you mean a ForEach loop that contains a data flow. Enumerating files in a Foreach loop ( http://blogs.conchango.com/jamiethomson/archive/2005/05/30/1489.aspx ) -Jamie ...Show All

• Software Development for Windows Vista Task Pages integrated within the Control Panel

  Hi, I am developing a control panel applet specifically for Windows Vista. I need this applet tightly integrated within the UI of the control panel, such that when the applet runs, it inherits the area, look and feel of the control panel. It will have custom pages that live within the area of the control panel UI when you navigate into the applet. All of this is in line with the Windows Vista User Experience Guidlines . My question is: How do I do all of these things discussed above and in the User Experience Guidelines It is clear that the intent is for ISVs to be able to accomplish these things based on their appearance in the guidelines, but I have not found any documentation regarding the actual implementation of such things. Can you ...Show All

• Smart Device Development Datagrid Current record?

  If I have a datagrid that has RecNum for the primary key column, how can I return the RecNum value for the currently selected row in the datagrid Please see this: http://groups.google.com/group/microsoft.public.dotnet.framework.compactframework/browse_frm/thread/dfcc71716efc6d14/4163dbb722e3c87a &hl=en#4163dbb722e3c87a ...Show All

• SQL Server MS Mappoint and SSRS

  Does anybody know if it's possible to embed a mappoint map into an SSRS report I'm currently using SSRS2000 but hope to upgrade to 2005 before too long. Thanks. Yes, access would be easy because you could write a macro to call mappoint and the .ptm file based on a data query. However I can't see how I could do this using ssrs except by some kind of hyperlink url perhaps, or by calling a windows batch file that ran mappoint. I do know though that if you use report manager, you can 'upload a mappoint file' onto the web page and then the mappoint session will run inside the ssrs report manage browser session, which is probably the best I will get. ...Show All