brohans's Q&A profile

• SQL Server SPLIT AN ARRAY!

  dear friends, I have a stored procedure that receives a parameter like ' 123#67#1#89#52#' I need to insert each number (123, 67, 1...) in a table... How can I do it using the best performance Thanks!!! Cheers!!! Dear Friends, Thanks for all!! IT WORKS!! I selected the answer of PHIL! THANKS FOR ALL!!! ALTER procedure [dbo] . [ST_SP_INS_PROJECTO] ( @P_Nome nvarchar ( 50 ), @P_Data nvarchar ( 10 ), @P_CreatedBy nvarchar ( 20 ), @P_Descricao nvarchar ( 200 ), @P_Owner nvarchar ( 50 ), @P_Autorizacoes nvarchar ( 255 ), @P_KeyUser nvarchar ( 150 ), @P_Users nvarchar ( 255 ), @P_Manutencao nvarchar ( 255 ), @P_Storage decimal ( 18 , 2 ), @P_Observa ...Show All

• SQL Server Job Fails accessing mapped drive

  I built a package in SSIS that exports some data in a database and writes it to a flat file. The flat file is written to a mapped drive on another server (shared folder). The package runs without failure in SSIS and when I deploy it on the SQL Server. The problem comes when I try to run the package as a job; it fails. If I change the file location to the local c: drive, the job runs to sucess. The id that starts the SQL Server Agent is a domain id that is included in both the domain admin group and the local admin group. All the job log indicates is that the job failed; no details. What am I missing Thanks ...Show All

• Windows Live Developer Forums fixed map

  Hello, Does anyone know how to control the map to fixed or acctive without calling the map.LoadMap(); Thank you Yuki ...Show All

• Visual Basic Structure from VB6 gives error in 2005

  Have a legacy application migrated with wizard from VB6. Full of structures. Original author is gone. Below is edited snipped with error shown. Help would be GR8TLY appreciated. Thanks in advance. 'UDT for Simulation Parameters Structure Simulation Dim Senior As Integer 'UPGRADE_TODO: "Initialize" must be called to initialize instances of this structure. 'Click for more: 'ms-help://MS.VSCC/commoner/redir/redirect.htm keyword="vbup1026"' <VBFixedArray(5, 9)> Dim Characteristic(,) As Single Public Sub Initialize() ReDim Sim(27).Characteristic(5, 9) Characteristic.Initialize() End Sub End Structure ' Now declare the collection, with the name "Sim" 'UPGRADE_WARNING: Array Sim ...Show All

• Visual Studio Tools for Office vba6.msi

  Hi i just installed Visio Pro 2003 but when I tried to insert a chart in powerPoint, it is asking me to install vba6.msi from the installation package. This installation was done from a sever and I cannot locate the vba6.msi. is there an alternate location or an individual download that I can perform to install this file Please help. Hi Unfortunately if the Windows Installer service can't locate this from the normal locations, it will need to repair its installation. Sorry. Additionally this isnt really the right area to post this question but there is no other option than the full installation media or the correct CD it was originally Administratively installed from Regards ...Show All

• SQL Server what errors normally should i log for my SSIS package?

  I got an SSIS package that first "truncate the product table" then populate the table with new rows....if there is an error then i will invoke the send email task. However in the "truncate the product table" task, the sql i put "truncate dbo.product" instead of "truncate table dbo.product" but this error is not captured in the text file that I m going to send an email to the appropriate personnel. Under logging, and when i go into "truncate product table" tasks , "Details", i saw "OnError", "OnWarning" and other error handlers...which should i tick in order for the text file to ONLY show errors I encounteered during the running of the SSIS packa ...Show All

• Visual Studio Express Editions Distributing console app - problems with SP1

  Hi all, I've been having a problem distributing a command line tool written using Visual C++ Express and I'd like to raise the issue with the rest of you. VC++ Express, with SP1 applied, embeds the requirement for version "8.0.50727.762" of the CRT into the manifest (and hence embeds it into the executable). I ask users of my tool to download and install the VC++ Runtime from here : http://go.microsoft.com/fwlink/ linkid=65127&clcid=0x409 However this only installs the runtime version "8.0.50727.42". Normally I would expect such a minor difference in version to be acceptable but the policy installed with the VC++ Runtime only permits these "old" versions to use the instal ...Show All

• Visual C# temp+=temp.Replace(chr(13),"<br>");

  temp+=temp.Replace(chr(13),"<br>"); Compilator complains that there is no "chr" in my class, why Here's couple examples how to replace:             temp = temp.Replace("" + (char)13, "<br />");             temp = temp.Replace("" + (char)0x0D, "<br />");             temp = temp.Replace(((char)0x0D).ToString(), "<br />");             //I'd use this:             temp = temp.Replace("\r", "<br />"); The latte ...Show All

• Software Development for Windows Vista Event never set after calling IAudioClient::Init - IAudioClient::SetEvent - IAudioClient::Start sequence

  I'm trying to pass an Event handle to a capture device, in order to get me signaled when a buffer has been captured. In the IAudioClient::Initialize function I set the flag "AUDCLNT_STREAMFLAGS_EVENTCALLBACK" and I get a result S_OK from it. I played around with various durations too. The SetEvent function does return with S_OK too. When I start the capture device it does start capturing, however the event is never set. So this leaves my application with cumbersome polling. Maybe the security system of Vista is preventing the driver/service to set the created event. I played around with setting the security by applying the most unsafe security descriptor but this did not result in the event being set either. Is this fe ...Show All

• Windows Forms How to add ContextMenuStrip to menu item?

  Hi! How can I add a ContextMenuStrip to a menu item Matt You can use this derivated menuItem... public class ContextSpecialToolStripMenuItem : ToolStripMenuItem { private bool _showContextMenu = false; private bool _hasDropDownItems = false; private ToolStripDropDown _realDropDown = null; private ContextMenuStrip _contextMenuStrip = null; public ContextMenuStrip ContextMenuStrip { get { return _contextMenuStrip; } set { _contextMenuStrip = value; } } private Point _dropDownLocation = Point.Empty; protected override Point DropDownLocation { get { if (_showContextMenu) return _dropDownLocation; ...Show All

• Visual Basic Explorer's Send To

  Hi everyone, I'm currently working on a very importent project, and I have a problem. On the explorer, when you right click a file, on the context menu, you can choose the "Send To" submenu, and there there are options. What I want to do, is to use that option, and to "Send" a specific file to there. It's not always a folder to send to it, it's sometimes a printer driver. How can I do it Ofir. It doesn't work for me either.... Do you have any other ideas Ofir. ...Show All

• Visual Studio Is there any MSBuild Interface available?

  Hi all, Has anybody had call MSBuild via api interface from win form application Currently, I'm able to call msbuild.exe from win form using process.start() method; however, I think it would be nice if I could call msbuild directly from api interface. Best Regards, Thanks all. I got it It should be Engine.GlobalProperties.SetProperty( "Configuration" , "Debug" ); ...Show All

• Visual Studio 2008 (Pre-release) CollectionViewSource.GetDefaultView

  Hi, I have a DataSet that contains 2 DataTables that has a Parent Child relationship. e.g. Order and OrderItem tables. In my XAML, I use 2 ListViews to display the table contents. The parent List is bound to the Order DataTable, and the second List is bound to the DataRelation (ie. Order_OrderItem). Does anyone know how to get the current row of the second table I tried calling: CollectionViewSource.GetDefaultView(OrderItem table), but it seems to return a different View than what is bound in the XAML. Thanks, Setiono. here is one way you can get itemssource of the second list and convert that to DataView which will have the items(there might be more than 1 row depending on the relationship) System. ...Show All

• .NET Development Login to my ASP WEB Service

  I can't logon to my ASP Web service. I can access to folder, to .htm pages but can't to .aspx page. I can get to .aspx page by url using localhost as: http://localhost:4463/flowers/Default.aspx but when I want to acces by IP number, or computer and domein name as: http://192.168.1.1:4463/flowers/Default.aspx or http://mydomein.com:4463/flowers/Default.aspx I can't Only I can access from local machine and using localhost... What I do wrong You have posted on the XML Messaging and Serialization Forum which does not deal with ASP.NET questions. To receive a faster response to your questions, please post on the following forum: http://asp.net . Thanks. ...Show All

• Visual Studio Team System build configuration settings missing in project designer

  When I started Visual Stutio 2005 (Team Suite) today and opened the project designer (for any project type like C#Application, C# Library, C# Web Application Project), all works fine, but the top row of controls is missing. This is the line where one can specify the build configuration (debug/release, processor type), which is somewhat essential for setting the properties in the "build" tab Trials show that the settings now apply only to the "release" configuration. I have even tried the "repair" install of VS2005, but to no avail. Of course, I have installed some of the advanced tools from MS like Atlas, Sandcastle etc., but I'd really like to know how to get the controls back into the dialog! An ...Show All