josericardo_jr's Q&A profile

• SQL Server Passing XML file as a variable to stored procedure

  Hi! I have two assets: a URL that points to an XML file, and a stored procedure that can accept this file as a text variable and store it in a SQL 2005 table. create procedure [dbo] . [insertObjects] @availabilityXml text as DECLARE @xmlHndAdd INT EXEC sp_xml_prepareDocument @xmlHndAdd OUTPUT , @availabilityXml TRUNCATE TABLE Objects INSERT Objects SELECT * FROM OPENXML ( @xmlHndAdd , '//NewDataSet/Table1' , 2 ) WITH Objects Now, I need to find a solution to combine the URL with the proc. Does anyone have any suggestions on how I can pass my URL as a text variable to the procedure SSIS, vb-script, etc. are welcome! Thank you! My suggestion: 1. use sqlxml to be able to acce ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 360 Dev do's and don'ts

  Hi, My primary platform at the moment is Windows, but I want to ensure I don't code anything that is going to cause alot of pain when I eventually get around to subscribing to the creators club and deploying to the 360. I've read a couple of articles on GC and other performance related stuff, but I wondered if anyone has any advice generally on what to avoid or if there are preferences in how ceratin things are coded (e.g. there are many types of storage, is one better than another for XNA specifically) that will mean the transition to 360 is as smooth as possible. Any thoughts or comments welcome! Cheers :) I think I found the culprit (or one of them at least)--lots of string.toLower() nonsense. I have an ...Show All

• SQL Server Client Statistics / Network Statistics

  I am trying to track down a slowly preforming query and am looking at the client statistics tab; specifically the Network Statistics and Bytes received from server. I have two servers one running SQL Server 2000 and the other running SQL Server 2005, 64-bit. The data on the servers is similar, some schema differences, some record differences -- but nearly 32 million records in one table. The same query is taking longer on the new SQL Server 2005 machine. The main difference that I see on the client statistics tab is the bytes received from server is almost always triple on the new server. Were there any changes in the information SQL Server 2000 and 2005 reports back Could the 64-bit be the cause for the increase (might make s ...Show All

• Visual Studio error MSB4018: The "GenerateResource" task failed unexpectedly

  I have a Smart Device application that is generating the following errror when I attempt to build. I would appreciate any feedback in how to debug this error, or what might be a typical cause of this problem. C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Microsoft.Common.targets(1616,9): error MSB4018: The "GenerateResource" task failed unexpectedly. C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Microsoft.Common.targets(1616,9): error MSB4018: System.InvalidOperationException: Collection was modified; enumeration operation may not execute. C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Microsoft.Common.targets(1616,9): error MSB4018: at Microsoft.Build.Shared.ExceptionHandling.RethrowUnlessFileIO(Exception e) C:\WINDO ...Show All

• SQL Server Printer control

  Is there a way to specify the tray to print a page from I am working on an invoice that needs the first page printed on special stock and any additional pages printed on normal paper (done now using printer codes). If it were a single invoice this could be handled at print time, but we print thousands of invoices (of varying page counts) at once. ...Show All

• Visual Studio Team System Team Tester supports HTTP/HTTPS Protocols for Load Testing..

  By going thru msdn help came to know that Team Tester supports http/https requests for Load Testing. We are using different Automation testing tool for load Testing and this tool supports Soap calls, BITS.. We are trying to see if Team tester supports these kind of calls too Please let us know the Supported environments, Protocols and Interfaces for Load Testing. Or if there is a link in msdn site where this info. are available, could you provide the link. Also one more question, one of our existing Application uses BITS Protocol for File upload especially for uploading the supplementary data like CSV , PDF and TXT attachments. Just want to check to see if Team Tester tool ...Show All

• Visual Studio Toolbox icons defaulting to one icon in 2005

  I have one instance of Visual Studio 2005, long time existing, where most of the icons found in the Toolbox for winform development have taken on one icon instead of the unique icons. It occurs from the button icon to the StatusStrip; which all have the same icon. Is there a way to reset them sorry if I mis understood that response, I apologise....To reset the IDE go to tools > import and export settings > Reset all settings. or via command prompt: start > programs > Visual Studio 2005 > Visual Studio Tools > Visual Studio 2005 command prompt type: devenv /resetide ...Show All

• Visual C# confused with runtime error and compiletime error

  class B { int32 x; } class D:B { int32 y; } B b = new System.Object(); //This statement will cause a compile time error. D d = (D)b; //This statement will cause a runtime error. I am really confused, I can't find out the differences between the two statements above, I think they are the same.Who knows why Any help will be appreciated. You're example is malformed. In the latter case you use an explicit cast that bypass compiler type checking. Try this instead. B b = ( B ) new Object (); D d = ( D ) new B ();    Both compile and both raise an InvalidCastException at runtime, as expected. ...Show All

• Visual FoxPro convert text files to certain format

  Hi there, I would like to convert the text file to a text file but with "" and ; to separate the data. How could I do that Pls advice whether foxpro itself can do that or need to convert it to dbf in order to get the format. Need urgent help. Thanks. Dave Delgado pls note COPY TO command Creates a new file from the contents of the Table not from a Text file what espirit wants to do is convert from a Text file to another Text file with delimited with " and ,   espirit wrote: I have a file as below format. EQ0003929307:18:22M01208162520NLR105.5 904 NL0004 000000.0010/07/06 I would like to change it to e.g.: "1234","abc","xyz" format. How could I do that for th ...Show All

• Visual FoxPro Rotation vfp helpfiles not working

  this code is copied straight from vfp 9.0 help files. i just added the two paramateres this code works in vfp and when i run just the application on the computer that has vfp installed. however it is not working on non vfp computers. on a non vfp computer all i see is a wait window that says rendering and its tallying up the pages. PARAMETERS REPNAME,ANGLE_OF_TILT LOCAL oListener oListener = CREATEOBJECT("rotateText") oListener.ListenerType = 1 REPORT FORM &REPNAME OBJECT oListener #define FRX_OBJCOD_PAGEHEADER 1 DEFINE CLASS rotateText AS ReportListener IsInPageHeader = .F. PROCEDURE Init() DECLARE integer GdipRotateWorldTransform In GDIPlus.Dll ; integer graphics,single angle,integer e ...Show All

• Visual Studio Team System MS Project and TFS questions

  Here are some more issues that my client has encountered while using MS Project with TFS. Are there any work arounds 1. TFS seems unable to deal with special characters such as brackets ' [' e.g. Smith, John [ABC Company]. When synchronizing Project after making changes on TFS, it doesn seem to be ok with special characters like commas and parentheses ',' and '(' e.g. Smith, John (JohnSmith) 2. When changes are made to Remaining Work and completed work, how does MS Project interpret those updates It seems that the finish dates are dependent on the values entered in TFS. There is no easy way to 'approve' the changes before the update is done ( like with PWA). hey...i am sorry i missed out...one info.. ya you are correc ...Show All

• Visual Studio Team System Can't see new work items in Project Portal

  Does anyone know why I can't see new work items in reports at Porject Portal. I am using CMMI Process platform. I have added few work items using excel and I can see them from visual studio but I can't see them with any query from project portal reporting for example Work Items report doesn't give any work items Thanks in advance I suppouse you refer to Reports in the project Portal, the reports are generated based on the datawarehouse, which does not inmediatly reflects changes, you can call manually a webservice on the server to regenerate the datawarehouse to get the new work items info. ...Show All

• Visual Studio Express Editions edit a datarow on a new form without useing a datagridview

  i kinda new to vb, i have vb 2005 express. On one form I have a listbox bound to my a column in my datatable, when you select an item in the listbox, other information from that datarow is displayed in textboxes. What I,m after is when I click a button on the form, a new form opens with all the data from the table of the selected row from the listbox so that the data of that row edited then saved back to the table. Or in an easier explanation, form1 is search for a datarow from a listbox, I want to open that datarow in a new form for editing can some shed some light as how I might be able to that Nightman28, Please use the FormatPercent function like this: txt &= "FormatPercent(" & x.ToString( ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Where is the download?

  It is 12:48 pm here (GMT + 1)... in Nuku'alofa (GMT + 13) it is tomorrow... So where the hell is my download link :-D :'( Its like 1am in the states so i guess we are waiting for them :(. This is like xmas and Bill Gates is our dad, wake up Billy so I can open my XNA! ...Show All

• SQL Server Server.Execute of ProcessAdd - Synchronous or Asynchronous

  If I using AMOs Server.Execute method to send an XMLA command containing ProcessAdd commands, is that a syncronous or asynchronous operation More specifically, when the command executes, does that mean the processing is complete Or am I just kicking off a process that will finish at some point in the future I agree that all signs point that way. However, since .Execute is used for different types of XMLA commands, it isn't clear to me that for ALL commands the return of the method indicates completion of the operation. For ProcessAdd, the returned result collection is empty, so it doesn't give much clue as whether the processing is completed or not. ...Show All