Gord M's Q&A profile

• SQL Server Escape character for /SET option of dtexec

  I have a problem setting some variables in a package using the /SET option of dtexec. Specifically when the value I want to set contains a semi-colon. I get an error like: Argument ""\Package.Variables[User::Delim].Properties[Value];^;"" for option "set" is not valid. I am guessing that I will have to escape the semi-colons somehow, but with what Regards, Lars You don't show the command but from the e ...Show All

• Visual C# I Lost My Object's Reference In The Current Context

  Thank you for any assistance available to the new guy !  A "code sample" of what I'm trying to do is provided below.  1.  While running in the Main method in the MyApplication class, I can instantiate and reference members in a second InitConfig class.  I'll name this instantiated class object my InitConfigBuilder .  myInitConfigBuilder has a number of properties/methods that provide usef ...Show All

• Visual Basic How to update a row(s) content in a datagrid

  Hi everyone,      I am using vs 2005 vb/asp .net and I have a datagrid that I need to allow the users the ability to update rows. I have the grid at the point where you click edit on a row and it gives you the text boxes. Once they click update I don't know how to get that value and save it to the DB. Any help would be greatly appreciated... thanks rich I FIGURED IT OUT... For all those that need ...Show All

• Visual FoxPro Display & list to the screen

  Am new to this - first part of msg disappeared after edit - trying again.   Display or listing a dbf to the screen produces a wrap when it should all be on 1 line. The dbf consists of 6 char fields for a total of 76 characters. Arial 10pt. I am using a 19 " screen so there are gobs of room. VFox 8 doesn't recognize the screen size Have noticed this in older versions as well. Courier spells reli ...Show All

• .NET Development ISAM installable file not found

  Hello,     I am trying to open a connection to an Microsoft Access data base in visual basic.net.  I get the message ISAM installable file not found.  I have the file MSISAM11.dll in c:\windows\system32.  I registered it with regsvr32. and it still does not work.  What can I do thanks a lot in advance for your help Aurora Tellez. Actually, I am using MS Access at work, so I never try to open the media pl ...Show All

• SQL Server Management Studio not installed

  I have installed SQL Server 2005 Standard Edition from the MDSN May 2006 DVD. After installation, the SQL Server 2005 item under Start | All Programs has only one entry: Configuration Tools. Management Studio does not show up. Add/Remove Programs does not show any previous versions of SQL Server 2005 or Express installed. (I did have earlier versions at some point in the past, but they've all been uninstalled). I saw other forum questions rel ...Show All

• SQL Server Cube Write-Back

  Hi, there, I have been told that cube writeback only affect the data on the cube rather than the underlying relational table. One of the requirement is to allow users to do what-if analysis/simulation on the cube. If the writeback only affect cube data, what if I re-process the cube FYI, we are using SQL Server 2005 Enterprise here. Thanks in advance. Regards, Yong Hwee Writeback is implemented ...Show All

• Smart Device Development Target Machine Link Error

  I have used the upgrade wizard to migrate my EVC 4 project to VS 2005. I have managed to get most of my projects to build but I have a couple that give me the following link error. mfc80u.lib(MFC80U.DLL) : fatal error LNK1112: module machine type 'THUMB' conflicts with target machine type 'ARM' The configuration was originally targeting ARMV4. The "Target Machine" Linker option is set to "MachineARM (/MACHINE:ARM)". And I cannot ...Show All

• Visual Basic VB Control Arrays.

  Ok, there are many posts all over the net with possible solutions to this challenge, but none seem to suit my needs. in the 'good ol' days' (VB6 and Prior) you could simply copy/paste controls to a form and set Index properties to create an array of controls. These could then be manipulated individualy, for example: MyTextBox(1).Text ="I" MyTextBox(1).Text ="WOZ" MyTextBox(1).Text ="'ERE" But I can't find a simple s ...Show All

• SQL Server Partition Scheme

  Hello everybody, how can I verify a partition scheme in SQL Server 2005 (June edition) SELECT p .* FROM sys.partitions p , sys.objects o WHERE o . name = 'mytable' AND o . object_id = p . object_id GO this always returns only one partition thank you Eckard BTW, there is some confusion about terminology.   A partition != a partition scheme.  The query above looks at a table ...Show All

• Visual Basic program not responding when debugging

        I am new at VB 2003 and i run it on my computer. Recently i got myself a laptop  and installed VB2003 .Net on it. I copied the projects to the laptop, but when i try to run them by clicking on the start button (next to debug) The program does not respond anymore. Even when i start up a new project and try to run it, it won't react. What could be wrong Thanks for your reaction. Peter When i've made a ...Show All

• Visual C# Is there a quick way to know if the return value is a copy or reference?

  In C++ the intellisense displays if the return value is a pointer which is really nice. Is there a way to know easily if the assignment will yield a copy or a reference In C# you can't return a pointer, only a IntPtr for example. So normally when you see the return type you know enough. If thinks are a copy or not can't be marked by a type. This is allways the documentation that can tell you such things. Can ...Show All

• Visual Basic How to do sound recording ?

  I want to capture sound from windows application and save into a file, like I want to save the entire voice conversation in MSN messenger. Wong,     You can use the Windows Media Encoder SDK. See the following: http://msdn.microsoft.com/library/default.asp url=/library/en-us/wmencode/htm/windowsmediaencoderautomation.asp Drill down into: http://msdn.microsoft.com/library/en-us/wmencod ...Show All

• .NET Development ADO.Net-DataAdapter.DeleteCommand Can't Delete Row

  I recently develop a tool to add, edit, delete, filter, search, locate record on a Database Table. Also includes Relations, my tool uses sqldataadapter, dataset.etc.   My problem is when I try to perform a Delete of a record look my code :   Private Sub UpdateData()         Dim p As ParameterControlUpdate       Dim TableToUpdate As String = m_grdT ...Show All

• .NET Development wordml xsl trsansform

  I am using wordml xsl stylesheet to transform some xml. The wordml has lists that have a bullet (the normal character) as the character to use. This character is an illegal character for XSL transformation. How can I get around this issue. The output is a wordml document. By opening the new xml document it is opened in word. Thanks for any help. A little more about this issue.....Below is th ...Show All