David J Oldfield's Q&A profile

• SQL Server UPDATETEXT problem

  Hi, For a report I need to run in my app I have an SP that will in short, create a temp table, populate table and return table. The table contains a ntext column so add more data to it I need to use UPDATETEXT. My code is: CREATE TABLE #TempReport ( [Person] varchar(255), [Status] ntext ) INSERT INTO #TempReport SELECT surname, IsNull(s.thevalue, '') --+ '<BR /><BR />' + o.thevalue FROM tbl_people p INNER JOIN tbl_lu_people lup on lup.personid = p.personid and persontypeid = 1 LEFT JOIN tbl_memo s on s.caseid =p.caseid and s.memotypeid = 6 LEFT JOIN tbl_memo o on o.caseid = p.caseid and o.memotypeid = 8 declare @value varbinary(16) SELECT @value = TEXTPTR(RT.Status) FROM #TempReport RT updatetext #tempreport.S ...Show All

• Visual Basic List Folderames in a folder

  How do I list the names of all the folders inside another folder you can either do a remove: currentFolder.Remove("\\", "") or Me.theListBox.Items.Add(currentFolder.SubString(currentFolder.LastIndexOf("\") + 1)) safer would be the first one :) ...Show All

• Visual Studio Team System Change home site for new projects

  Hello! How i can change home site for new projects Need change servername from http://SRV01/sites/ProjectName to http://srv01.domain.com/sites/ProjectName Best Regards Ivan Mokrotovarov You need to use TfsReg.exe to change the registered URL's for sharepoint ("Wss") access. get the current xml edit it to change the url's for sharepoint access tfsreg.exe the xml http://blogs.msdn.com/jmanning/archive/2006/10/12/getting-the-xml-for-running-tfsreg-exe.aspx ...Show All

• Smart Device Development [MAPI] Why I can't initilize the MAPI DLL?

  Hi: I'm trying to test a email program iva MAPI on my own Emulator customed by platform builder. To implement the ActiveSyen ,I added the SYSGEN_AS_MAIL module. But in my program,the problem is : When I use any function relateted to MAPI,compiling is all right,but when running ,it is said : Unable to start program '%csidl_program_files%\SendemailTestEmulator\SendemailTestEmulator.exe' And there is error code :0x8007007e I lookup the code 0x8007007e,this is mean : The specified module could not be found. I have already added the cemapi.lib, Some one can help me This forum is primarily monitored by Visual Studio for devices group. Please check ...Show All

• Visual Basic Problem with XPath

  Hello, I am having some problems with XPath. First off, I would really love to read some good documentation on it. I feel that the vb.net documentation on XPath usage is just terrible. If you know of any really good documentation for XPath with vb.net, please point me to it. Now on to my real problem. I have xml like this <foo> <bar>blah</bar> <bar123>test</bar123> </foo> and here is that I am using (gleaned from some site mostly). This is what it looks like after tearing my hair out and trying to fix it. Dim xpathDoc As XPathDocument Dim xmlNav As XPathNavigator Dim xmlNI As XPathNodeIterator xpathDoc = New XPathDocument(path) xmlNav = xpathDoc.CreateNav ...Show All

• Visual Studio 2008 (Pre-release) How can I control the internal WebBrowser??

  When I use this code “<Frame Source=" http://www.brugtespil.dk ” />“ a WebBrowser is hosted and it loads the page. But I have no control over the navigation (GoBack, CanGoBack, current url and so forth) frame.GoBack() and NavigationCommands.BrowseBack have no effect. Best regards, Thomas Andersen Thomas, For v1, user-initiated navigations that happen inside a Frame hosting HTML content are not integrated into the WPF navigation stack. If you need more control over navigations that happen in an HTML frame, we recommend using WinForms Interop to host the WebBrowser control. Thanks, Lauren ...Show All

• Visual Studio 2008 (Pre-release) WSE to Indigo migration help needed

  Hi, I am new to Indigo. I have a WSE 3.0 webservice which implements an Asynch Method (where the reply to address is different from the senders address). I need to upgrade my WS to Indigo and need code samples/documentation which will help me do that. My first question being does Indigo have a class similar to SoapSender in WSE Also my Existing webservice uses a policies (soapSender.SetPolicy) to communicate with other services, how are policies handled in Indigo These are probably very basic questions :) and any help given will be appreciated. Thanks, Firdosh Hi Firdosh, There are a number of documentation topics about this very subject. Here are some links: http://msdn2.microsof ...Show All

• Visual Studio Express Editions Command line error D8016

  I'm new to Visual and I just started programming... My problem is that when I turn a program into the Multi-Thread (/MT) form under the Runtime Library this error comes up when I build it: Command Line Error D8016: '/MT' and '/clr:pure' command-line options are incompatible Please help... I made this program 3 times and each one didn't work... I have to have it for school... For information, I deleted AssemblyInfo.cpp and my project compiles and builds with no errors now. The resulting executable is 245kb. One day I will find out what CLR is and what benefits I am missing out on but right now I have work to do and my little application is working (after 4 hours of this bizarre problem) ...Show All

• Windows Forms subscript / superscript?

  Dear All Is there a way of making the text label of a checkbox have subscripts and/or superscripts Some code would help please. cheers, prasad.. Don't go the RTB route, you'll have loads of trouble trying to turn it into a button or checkbox. If charmap.exe doesn't give you what you need (have you tried it ), draw the text the way you want it in a painting program and put that image on the button or checkbox... ...Show All

• Visual Studio Express Editions Can some one tell me how to find the default icon please.

  Hello. Can some one tell tell me how to show the default icon in a ListView box please Av only bean learning programming about 3 or 4 weeks now, and am stuck on the this. Am making a cleaning program, the files and the path show in the Listview box, but I want the default icon to show as well. Your help will be very much apresiated. Hears wishing every one a merry Christmas and a happy new Year, and may 2007 be a good year for you all. Thank you I'm guessing you want to display the same icon that Windows Explorer displays. That's not easy to do and especially not easy to do efficiently. You might have noticed that Windows Explorer displays the files quickly but then takes its s ...Show All

• Visual Studio 2008 (Pre-release) Apply template to button at runtime

  Hello everybody, I made a button template and I want that all buttons created at runtime to use this template. What should I do Thank you! Maybe I wasn't clear enough, but I want to do something like this Button b = new Button(); After the creation, I want to set other button template for the button. Thank you! ...Show All

• .NET Development How do i use the Typed dataset i created?

  i created a new Typed dataset by these steps : 1. Added new item (XMLSchema) called XMlSchema1. 2. dragged a table to the xsd screen which created a dataset automatically. 3. called the dataset "ProductsDataSet" but how do i use it in the book i read i just write : ProductsDataSet pDataSet = new ProductsDataSet(); (SqlDataAdapter)sqlDAdapter).Fill(pDataSet.Products); but the compiler tells me that he can't find any 'ProductsDataSet', why Why can't he find it (the XmlSchema1.xsd is in the same namespace as the code i wrote). (In the book it is written to check the "GenerateDataSet" , i don't have that kind of property. rodniko wrote: i created a new Typed dataset by these st ...Show All

• SQL Server CREATE Assembly with VJSLIB on x64

  I've got a project that requires J#. I know the J# assemblies aren't on the approved list, but I'm ok with that. I've done all the nasty things you're supposed to do to register it, and I've been succesful on my x86 machine. However, when I try the same thing on an x64 machine, it ends in failure. Here's the exact T-SQL I'm running: IF NOT EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = 'vjscor') CREATE ASSEMBLY [vjscor] FROM 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\vjscor.dll' WITH PERMISSION_SET = UNSAFE IF NOT EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = 'vjslib') CREATE ASSEMBLY [vjslib] FROM 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\vjslib.dll' WITH PERMISSION_SET = UNSAFE As I said, this runs ...Show All

• Visual Studio Team System Automating an FxCop run and collecting results?

  I've written my FxCop rules and can use 'em fine from within FxCop by: load MyRules.dll up into FxCop from the Project>Add Rules menu item turn off all other rules from the Windows>Rules menu item add a target by right clicking in the Targets pane and selecting the Add Targets popup menu item. I find that I can save the project with File>Save Project As and that I can subsequently reload the project into FxCop from the command line. What I'm missing is the ability to automate the sequence: fxcop MyProject.FxCop Hit the Analyze button Save the results with File>Save Report As Is it possible to automate these steps so that I can write a regression test to add to my suite of tests that run every day to e ...Show All

• Windows Search Technologies No results with full word. WDS 2.6.5.5378

  Hi Sometimes I get "no items found" when I enter a word. However, if I leave out the last letter of the word, I get the correct result. This affects only some words, but I cannot see any pattern to this. I have seen several posts, but no resolution, on microsoft.public.msn.search with this same problem. It also occurs on machines with a German keyboard. Can you help me to resolve this issue I have a WinXP-SP2 machine with a Swiss German keyboard, I am in a workgroup, and I am logged in as administrator. With kind regards, Matthias Klay Please try the latest release of WDS 2.6.6 located at http://www.microsoft.com/windows/desktopsearch and let me know if this problem still exi ...Show All