Advectus's Q&A profile

• .NET Development Modify System.Exception in SetILFunctionBody

  I am wondering if I can get some help on this. We have working "Proxy" that is invoked via insertion into methods and gathers all the calling arguments, etc. and passes to a handler. We are using the SetILFunctionBody during JIT compilation. It works fine for 1.1, but in 2.0 ONLY works when using LoaderOptimization other than SingleHost when hooking corlib methods such as the System.Exception .ctor. We are hooking many methods - all NON core methods work well. I have come to the conclusion that it has to do with Domain Neutrality of mscorlib (only) being in the shared domain. So, my questions are this: Other than the LoaderOptimizationAttribute OR the args to the CorRuntimeBindEx to load the CLR - how can one override the Loade ...Show All

• SQL Server Help with SQL

  I have a table named "policy_details" having four columns called policy_details(varchar),effectdate(datetime),Historyid(int) and policy_status(varchar). I want to keep only the maximum historyid records in "policy_details" where policy_details and effectdate should be equal and policy_status should be '30240084' . I want to delete the remaining records where policy_details and effectdate should be equal and policy_status should be '30240084'. Cheers Praveen Interesting, when I write the following query, which is almost exactly like yours: begin transaction DELETE FROM person.address WHERE ROW_NUMBER() OVER ( PARTITION BY addressId ORDER BY addressLin ...Show All

• .NET Development Problem with SqlBulkCopy when destination table name has apostrophe (').

  I have a problem with tables names like a'b. WriteToServer(IDataReader) throws Exceptions: Exception type: System.InvalidOperationException Exception text: Cannot access destination table 'BPMExpert.dbo.[a'b]'. Inner Exception type: System.Data.SqlClient.SqlException InnerException text: Incorrect syntax near 'b'. Unclosed quotation mark after the character string ''. Escaping the name using surrounding brackets, as the documentation says [<database>.<owningschema>.<tableName>] , doesn't help. Simple select "SELECT count(*) from BPMExpert.dbo.[a'b]" works great. The problem exists only with apostrophe ('). With other characters, such as ampersand (&),percent (%), etc, ...Show All

• Visual Studio Express Editions What's the square root code in vb 2005?

  Hi Friends I am really new in visual Basic, I knew that the square root code in vb 6 was sqr but in vb 2005, it doesn't work Help, Please Thanks very much.................. Davinci_991 wrote: Hi Friends I am really new in visual Basic, I knew that the square root code in vb 6 was sqr but in vb 2005, it doesn't work Help, Please Thanks very much.................. ...Show All

• Visual C# Recursive function error

  Hello, I wrote a function to that reads a file in a folder and then does something. the function is recursive in case of subdirectories. just like that: public void ProcessDir( string sourceDir, int recursionLvl) { TextWriter tw = new StreamWriter (textBox2.Text + "\\FileNamesGen.txt" ); HowDeepToScan = domainUpDown1.SelectedIndex; if (recursionLvl<=HowDeepToScan) { // Process the list of files found in the directory. string [] fileEntries = Directory .GetFiles(sourceDir); foreach ( string fileName in fileEntries) { // do something with fileName tw.WriteLine(fileName); } string [] subdirEntries = Directory .GetDirectories(sourceDir); foreach ( s ...Show All

• SQL Server Cross Tab / PIVOT problems with multiple datatypes

  I am building a system that accesses personal data in a view based on two tables. The view is there because the number of used/necessary fields changes with every import of data (which is, perhaps once or twice every week, approx. 50 weeks per year). The view is thus regenerated with every import. I have a Person table with fixed data such as name and address (see below), and I keep statistics and other variables for each person in a second table: PersonStat. Person table ID (PK) Name Address PhoneNo PersonStat keeps one record per person and statistics variable, and thus looked like this: ID (PK) PersonId (FK) StatName StatValue I put these two together in the view making the data easy to access as if it were one single tab ...Show All

• Visual Studio Team System Work Item Field Naming Conventions

  We have two camps for naming conventions. 1) Add the Work Item name in front of the field name so you can easily identify which Work Item field this field was for. E.g. <FIELD name= " ChangeRequest _ApplicationLevel" refname= "MyCompany.ChangeRequest.ApplicationLevel" type= "String" reportable= "dimension" > Then for Common fields shared among Work Items this camp does: E.g. <FIELD name= " Common _BusinessUnit" refname= "MyCompany.Common.BusinessUnit" type= "String" reportable= "dimension" > 2) The second camp does not have Work Item specific parts in the field name. E.g. <FIELD name= "A ...Show All

• SQL Server Script component: copy a row into a variable

  HI, is it possible to copy a row from the Input0_ProcessInputRow into another variable of a synchronous script component. I have a script component that has three outputs. What I would like to do is the following: At first iteration, copy entire row into a variable. For the other rows, is business key cols is different from the previous row (the one copied at previous iteration) or type 2 columns : 1-direct previous row (from the variable) to second.output 2- direct current row to the first output 3- copy the current row into the variable If the business key cols are the same and type 2 cols are the same: 1-Direct row to the third output My problem is that when I declare a variable as Input0Buffer and then copy the current r ...Show All

• Visual Studio Tools for Office OLE err in VST2003 Startup Wizard

  I purchased Visual Studio Tools(2003) mainly for the Developer Extentions so I could package my Access DB's. I have now finally ( ) have a had a need to give them a try. What I am running into is in the "Startup Wizard". When I check the "Startup" and the other "Checking" features( VBA etc.) I get the "on-click" OLE registration error. The message doesn't identify the OCX/OLE name and I know there is a way to register the OLE's at the command prompt but have forgotten how. I can access the startup options via the wizard, but, as soon as I return to the wizard is when I get the "on-click" OLE registration error. The Find VBA....., Find expressions.... and Find potiential missing...all ...Show All

• Visual Studio Express Editions Instant Messenger

  Im new to visual basic and have only had it for 3 days... I really enjoy the software and thing it is the best thing microsoft has made yet... I have been working with computers for 5 years now and know more that everyone in my neighborhood and most of my teachers (Im only 14 years old ). My point is though that while messing around i created My own website with my own internet explorer (website is working but my internet Explorer isn't compleatly done). Now i have decided that i would enjoy to create my own IM for my website but there is only one problem... i dont have any idea where i need to start and what i need to do to make this work... i really want to make my own IM For my website and would like some help... And another thing ...Show All

• SQL Server Upper level members are not adding up correctly in SSAS - revised

  I have created a cube in SQL 2005 / SSAS but am having a problem with the upper level members. It seems that these members are not rolling up correctly. The cube contains daily data, if I look at the monthly values, these are not correct. That is, the sum of the daily values do not add up to the monthly values calculated in the cube. The monthly values should be a simple sum of the daily values. At first, I thought it may be a rounding issue but the differences between the values pulled from the cube and the manual sums are too large. In the FACT table, the measures have the data type of real. I have verified that the numbers in the FACT are indeed the #s loaded into the cube, i.e. if I pull data at the lowest level of all the dimension ...Show All

• Visual Basic RPC_E_CALL_REJECTED during Word automation from VB2005 when copying in Paint...

  Hi all, I have a problem involving Word automation and the use of Paint. The situation is: A Word-document is being manipulated through automation. When I open Paint and copy (part of) the picture, I get a 'call was rejected by callee' error from the VB2005 application automating Word. When I use sleep(100) and retry (resume) the statement, it works fine. However, as long as the Paint session is open, every action I perform on Word will require a second try. Since there's quite a lot of them, this will slow the application down considerably. As soon as Paint is closed, the Word-automation continues without errors. Interesting detail: this application was upgraded from VB6, with only minimal changes. This problem did not occur in VB6. Does ...Show All

• Visual Studio Express Editions Question about the EULA

  Hello. I'd just like to ask, is the EULA just an agreement between the maker of software and the user, or is it actually a legal thing if it is a legal thing, how do you get it Am asking because as am still new to programing I dun't fully understand it, and av still got a lot to learn. Than you. No you do not have to include a EULA in your software that you create unless you want to make certian legal restrictions upon your users...and then you would put those restricitions in the EULA...(such as ..as the user of this software you may not resell or distribute this software....)it would be an agreement between you and the users of your software....as far as freeware is concerned once a ...Show All

• Software Development for Windows Vista WMI and Win32_DeviceChangeEvent

  Apologies in advance if this is the wrong forum to post on. If so, then please direct me to a better one. I'm having difficulty getting notification for the WMI event Win32_DeviceChangeEvent. Using the TempConsumer sample in the latest Windows SDK (Samples\SysMgmt\WMI\VC\TempConsumer), I modified two lines of code to be able to subscribe to the Win32_DeviceChangeEvent Line 169 changed from CBSTR Query(L "select * from MyEvent" ); to CBSTR Query(L "select * from Win32_DeviceChangeEvent" ); and line 239 from CBSTR(L \\\\.\\ROOT\\DEFAULT ), to CBSTR(L "\\\\.\\ROOT\\CIMV2" ), Compile the sample and run in Windows XP, then went to Device Manager and picked a device (in my cas ...Show All

• Visual Studio Express Editions Porting VB 2003 to C#\Can't find Arraylist

  I am porting an application over from vb 2003 to C# 2005 express. The VB application makes extensive use of the ArrayList object, I have tried looking for it in C# 2005 express and could not find it. Is it not included If not does anyone have any suggestions for a work around I am not very good with arrays and that is why I used arraylists in vb. Currently I am just using a invisible listbox to hold my data (I am placing information into it as and then saving it's contents out to a file) Thanks for the help! Scionwest Hi, Scionwest using System.Collections where ArrayList class is just there! http://msdn2.microsoft.com/en-us/library/system.collections.arraylist.aspx Thank you ...Show All