Matt24's Q&A profile

• SQL Server UPDATE question

  I need to update a field in Table A from a Field in Table B. The structure of the tables is slightly different but I think it should be possible. Here are the tables basically: tblTickets (Table A) Number (PK) EmployeeID tblTicketNotes (Table B) ID (PK) ticketID (FK) this links to the Number field in tblTickets EmployeeID I want EmployeeID in tblTickets to equal employeeID in tblTicketNotes where tbltickets.number = tblTicketNotesTicketID I hope that makes sence. I am trying to use an UPDATE query but I can't figure it out. I tried: UPDATE tblTicket INNER JOIN tblTicketNotes ON tblTicket.Number ...Show All

• Visual Studio Language Service and IVsEditorFactory?

  Does a Language Service only use the core editor Or can we create our own IVsEditorFactory impl to use in conjunction with the Language Service's colorizer, etc. Yes, that was it. Thanks very much Mikhail and Dylan. The problem was I didn't have the same URI and friendly name in the .xsd as was in the registry key. ...Show All

• Visual FoxPro foxpro exe and dbf's, fpt's, bak's, tbk's, but now prgs etc.

  foxpro exe and dbf's, fpt's, bak's, tbk's, but now prgs etc. I was given a foxpro program and i would like to see the code (the formulas)... i'm not sure how to do this... thank you...   modify command <insert your prg file here> modify form <yourformname> use <yourdatabasename>   ...Show All

• Visual Basic where's the VB Snippet Upgrade add-in?

  it was mentioned in the free book (...upgrading VB...), but I cant find it anywhere David - I'm looking at the latest build, but the code upgrade tool should be there in the Beta 2 build as well. As noted by Dman1, you must have a code file open to see the command. Have you tried that - Steve Hoag ...Show All

• SQL Server The value is too large to fit in the column data area of the buffer.

  Can someone tell me how to access the MaxLength property of a data column so I can figure out where the problem is Public Overrides Sub Input0_ProcessInputRow( ByVal Row As Input0Buffer) Try Row.PrimaryDiagnosis = Mid(Row.DiagnosisCode, 1, 8) Catch ex As Exception Row.Comments = "Error copying DiagnosisCode: <" + Row.DiagnosisCode + ">. " + ex.Message End Try Output = <aaaaa > Thanks, Laurence ...Show All

• Visual C++ Fatal error c1083: cannont open included file 'eikenv.h'

  Hello, I develope a symbian c++ program for a nokia 9300. I use VS .NET 2003 and when I compile my project i get: Fatal error c1083: Cannot open included file 'eikenv.h': No such file or directory Fatal error C1083: Cannot open include file: 'txtrich.h': No such file or directory Fatal error C1083: Cannot open include file: 'NokiaApplication.h': No such file or directory All this error comes from the first code line of each file. I have included the path to 'eikenv.h' and 'txtrich.h' in the additional path directories. Whats the problem AJ You either use the /I compiler option to the compilation command: For example if the header ...Show All

• Visual C# Can't zip nested folders

  Hi people ! does anyone here used the java.util.zip package I need to zip a series of nested folders  similar to this MyProjects/MicrosoftProjects/MyProgram/bin/Debug/MyProgram.dll however the ZipOutput stream requires a file,in this case MyProgram.dll.Does anyone have a workaroud regading the above issue I keeping hitting the FileNotFoundException as i specifed the sourcestream at MyProjects/ regards Wilson Actually, if you are using ICSharpCode.SharpZipLib you can download the sample in their website, there has a sample project called CreateZipFile, you can reference that project. and just modify the zip file part to the code ...Show All

• Smart Device Development GetSelected not supported?

  I have a listbox on my compact framework form and I am trying to call the GetSelected method. I can find nothing on MSDN saying the cf does not support this call but my Visual Basic code has the blue line underneath the call and the Intellisense text says GetSelected is not a member of System.Windows.Forms.ListBox. Am I doing something wrong or is it just a case of MSDN not mentioning nonsupport of this issue If the latter, is there a workaround Thanks!! Here is what I am trying to do: If lstOptions.GetSelected(Counter1) Then Here is a replacement: Public Function GetSelected (index As Integer ) As Boolean If lstOptions. ...Show All

• SQL Server Capturing and reporting execution errors

  We have a report subscription that emails an excel file every morning at 11am. For the past two mornings the subscription fails due to one of the parameters being null. This was caused by another programmer changing a stored procedure used in the report. What I'd like to know is how can I capture and report that the report failed to be produced. I have loaded the Execution Log sample reports and the relevant DTS package to load the logs is run every 5 mins. However, this error does not show up in the reports. The entries in the Report Server log file are as follows, ReportingServicesService!dbpolling!25a4!17/08/2005-11:00:12:: EventPol ...Show All

• SQL Server columns in indexes

  How are these columns stored If I am learning correctly, the added non-key columns in the index are not part of the index limit If I have a large amount of data that I cannot fit onto an index page, what's being done. Just a pointer to the data that's isolated on it's own page I guess this would be less overheard than performing an index scan with a pointer to the non-key column (I don't know, I'm asking) and no pointer would be better insert performane. I looked in the BOL and couldn't find how this stuff is stored. Can you help - does my question even make sense   I believe you are referring to comp ...Show All

• Software Development for Windows Vista Lost collections in Visual Studio 2005[english] after Installation Windows Workflow Foundation[german]

  Does anybody know how to get back all "collection mains" i.e. starter kits and so on, after the installation of WWF(WF) A repair of Visual Studio 2005 did no effect. I have reinstalled the whole components with english one's. Now it runs fine. Thanks for help. ...Show All

• Windows Forms Windows Control Event in Web Page for .Net 2.0

  Hi, Is it possible to post a sample as http://support.microsoft.com/Default.aspx kbid=313891 but updated to the .net 2.0 version I tried to build the sample for the .net 2.0 and it did not worked maybe because of security reasons and i suspect that now with version 2.0 its not need to expose as a COM object. I tried in a WinXP with sp2 with IE 6.29 and .Net 2.0 Thanks in advance, Bruno. ...Show All

• SQL Server SQL server installation, books online trouble

  Hi there, It is my second post in this NG on the same issue I am attacking after a break. Thanks to Boris B. I investigated my setup in detail but am unable to get ahead. In short, my objectives are: (1) understand thoroughly how SQL server works, (2) understand command structure (3) find out where GUI is and how to use it. (4) get books online I should say that I have installed SQL Server 2005 Developer Edition CTP from a DVD. It is a 32-bit beta software. I got it as a part of my MSDN Pro subscription. I do have two icons now on my desktop: SQL Server 2005 Surface Area Configuration manager and SQL Server Configuration Manager. I have DTS ...Show All

• Smart Device Development xmlserialisation different in .net Framework and Compact Framework?

  Hi, looks like .net CF framework does not support xmlserialisation of the array of class that i define. the same code works without problem in my desktop but it does not deserialise properly when i use it in my PPC. i have not tried serialisation but deserialization gives problem. here is the xml that i want to deserialise: < xml version="1.0" encoding="utf-8" > < MyProfiles xmlns:xsi =" http://www.w3.org/2001/XMLSchema-instance " xmlns:xsd =" http://www.w3.org/2001/XMLSchema "> < Profiles > < ProfileName > Home </ ProfileName > < ProfileD ...Show All

• Visual Studio The report definition for report 'xxx' has not been specified

  Hello, I have to confess that I never did anything with reporting services, reports, or whatsoever. For a rather huge database application (based on sql express) I thought it might be best to do the printing with local reports, which I planed to bind to the objects, I already used as data layer in my project. I created a simple report (just a table, with two fields), bound the report to the ReportViewer-Control, set the bindingsource-properties in form load. But the only thing I see is this error message "The report definition for report 'xxx' has not been specified" So: What *is* a report definition and how *do* I specify it Are there ...Show All