Eddie Garcia's Q&A profile
SQL Server Undo Changes in Table Help!!
I accidentally executed this query Update Table Set Field = 1 Where Date < dt I need to undo this, is there i way to do so Havent touch sqlserver since the execution of that query. Hi Giber, If you are using 2005, you may be able to restore the pages that were affected, however the easiest solution may be to restore the database backup to either another server, or same server but under a different database name. You would then be able to revert to the unchanged/correct table be referring to the restored db backup. Have a look at http://msdn2.microsoft.com/en-gb/library/ms191253.aspx for an overview of backup options etc. Cheers, Rob ...Show All
Visual C++ How to trim all space character in a string?
I want to trim all space character in a string, for example there is a string " 1000 + [101001] + [101002] ", how to get another string like this: "1000+[101001]+[101002]". Are there better method to do that thks pintu* wrote: void trim2(string& str) { string::size_type pos = str.find_last_not_of(' '); if (pos != string::npos) { str.erase(pos + 1 ); pos = str.find_first_not_of(' '); if (pos != string::npos) str.erase( 0 , pos); } else str.erase(str.begin(), str.end()); } std::string name = " Hello new World " ; trim2(name) You can out it much simpler than that: std::string str = " 1000 + [101001] + [101002] " ; ...Show All
Visual C++ Writing ASP files in C++?
Hi everybody. The subject exposes very well my curiosity. We can write ASP .NET files using VB.NET or C# syntax. So I was thinking... Can I write ASP files using C++ syntax . Best regards. Demian. http://www.codeproject.com/managedcpp/helloworldmc.asp ...Show All
Visual Studio Express Editions Accessing Access through Visual Basic 2005 Express
Hello everyone. I am trying to make an application using Visual Basic 2005 Express Edition that will open Microsoft Access 2003, open a specified database file, and then execute a specified Macro/Module. Is there a way to do this Add the Office Primary Interop Assemblies onto you machine. If you dont know what these are do a web search for http://www.google.com/search hl=en&q=Microsoft+%2B+office+%2B+pia Add a reference to Microsoft Office Interop Access and then use something like the following code. Dim Adb As New Microsoft.Office.Interop.Access.Application Adb.OpenCurrentDatabase( "Path To the database" ) Adb.Run( "Macro name to be ran.." ) Adb.CloseCurrentDatabase() Adb. ...Show All
.NET Development How to store PDFs in SQL SERVER 2000
Hi All I have a windows app which require to upload pdf file in sql server 2000. Does any one know how to save PDF file in SQL Server 2000 (as BLOB). I tried using FileStream object but no luck. Thanks Yeah..You are right. Even I am using WebBrowser control in widows form to display PDF. But to display PDF in Crystal Reports is tough. Thanks ...Show All
Commerce Server Refresh Site Cache
Where does the Refresh Site Cache in the Business Applications get its URL from. It's not currently working in my system and I believe the problem lies in the URL it is using. I have already modified the Web.config file for the permissions and the rest of Catalog Manager works fine. Please Advise. We are getting closer The Application was pointed to the wrong Application Name in IIS - which I have corrected. Now I am getting an Unauthorized access error - I have already gone through the document "How to Authorize Members of a Security Group to Update Cache" - so I am not sure where else to look. ...Show All
Software Development for Windows Vista Webservice timing out when raising event to workflow
Alright, what is happening I have a workflow that is persisted using a ListenActivity and a DelayActivity. There can be several persisted instances of this workflow and we want to raise an event for 1 to all of them through the web service host. The application will may process some of the persisted workflows, but receives an error of "The operation has timed out" before they are all processed. We are using WFF 2.2 Here is the code snippet for the raising of the event: [ WebMethod ] public void Approve( string instanceId, ApprovalAction action, string comment, string approverLogin) { workflowRuntime = wfHelper.InitWorkflow( ref eventApprovalService); SetEventHandlers(); Guid Ins ...Show All
Visual Studio 2008 (Pre-release) Why can't you query an Expression Tree?
I don't know why Expression Tree's don't implement IEnumerable or IQueryable. Let's say I want to search an Expression tree a member invokation expression (see here for an example of why you might want to do this http://www.theserverside.net/tt/articles/showarticle.tss id=LinqReflections ). It's just a tree so it could even provide different methods to do a depth first or breadth first search. Expression < Func < int , int , int >> acc = x => x+1; from expr in acc.BreadthFirst() where expr.NodeType == ... Of course I can do this myself with extension methods but I'd like to know why this was omitted. Is this discouraged for some reason I'm just trying to get a handle on best practices. Thanks very much, Cong ...Show All
Visual Studio Team System VS2003 with TFS MSSCCI shows the wrong file status
Hi, I'm using VS.NET 2003 SP1 with TFS MSSCCI provider 1.1. In the Solution Explorer, some of the resx files are shown as "checked out" status (with the red icon). However I don't have anything checked out. It seems to only happen to some of the language resx files (i.e., Form.de.resx and Form.fr.resx), but not regular code .cs files. How do I clear the checkout status in VS.NET Thanks, Heng-yi Hi, I've tried creating a brand new project and used VS2003 "Add solution to Source Control" menu to check in. Form1.de.resx still showed the checkout icon in VS2003. I switched on the API tracing in TFS and the trace log is attached below. The "Test" folder was queried fo ...Show All
SQL Server ScriptComponent with multiple ReadOnly variables
I'm having trouble with a script component in which I'm trying to use two ReadOnlyVariables. If I use only one of the two variables, everything works without issue. If I use both of the variables (as part of a comma-delimited list) I get the following: The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variables collection on a container during execution of the package, and the variable is not there. The variable name may have changed or the variable is not being created. I don't believe the variables themselves are the problem. Both are scoped to the package level and I can use either of them if I have it as the only variable. Seems bug-like, but thought I'd get some ideas before pursuing t ...Show All
Visual Studio Questions about Sandcastle
I have some questions and observations regarding the July CTP of Sandcastle when using it to generate documentation. The generated CHM file doesn't seem to have an index. There's no Index tab displayed in the viewer. The generated CHM file doesn't seem to have search capability. There's no Search tab displayed in the viewer. When the CHM file is double-clicked to open it for viewing, the right-hand pane of the viewer shows a mostly-blank page with a small warning icon in the upper left-hand corner. This mostly-blank page goes away when any of the entries in the table-of-contents in the left pane are clicked. In the CHM file, the documentation entries for class constructors always seem to have ".ctor" prepended to them. The table ...Show All
SQL Server Sql server 2005 sp2 and oracle access
When I try to create a model in Report Builder based on a connection to Oracle 10g database I get the following error. ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED } Is this a bug in the CTP version or am I missing something I think this is connection properties problem on the client machine where, I assume, you run Model Designer. If possible, could you please zip your model project and send it to me so I could make a quick check. almineev on the msft com ...Show All
Visual C++ Blue tooth API reference
Dear all i have one project which need to connect with blue tooth with PC .. where i can get more information or reference website the question is how can PC it to receive blue tooth hand free API for example ... keep up phone and trun off hand free Please see the Bluetooth Reference ...Show All
Visual Studio Refresh/Reload the Document Explorer Favorites
As described at http://forums.microsoft.com/msdn/showpost.aspx postid=591632&SiteID=1 ************************************************************************* http://forums.microsoft.com/msdn/showpost.aspx postid=591632&SiteID=1 Subject: Document Explorer Favorites Author: Nishan Jebansam DExplore can be launched in such a way that it saves it's Favorites file to a folder specified by the launching program (VS, for example, launches DExplore to save it's favorites file in Documents and Settings\<username>\Application Data\Microsoft\VisualStudio\8.0\VS Help Data\Favorites.xml) ************************************************************************* DocExplorer saves the Favorites.xml file a ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Website to download components
In Mitch Walker's blog, he says he expects to see cool components from the community. Will Microsoft have a website to host these components Kind of like how highend3d lets people share all the scripts and plugins people make for cg packages. The VS code snippets feature may already fill in a good part of the needs for this. As for hosting ready-made components, we'll be looking into a solution for that as well. It would be nice to know Microsoft's plans for this though, so we're not building a redundant alternative. ...Show All