Jason Weiler's Q&A profile
SQL Server Insert / Update in master table and also save a history of changed records : Using data flow/simple sql queries
Hi, My scenario: I have a master securities table which has 7 fields. As a part of the daily process I am uploading flat files into database tables. The flat files contains the master(static) security data as well as the analytics(transaction) data. I need to 1) separate the master (static) data from the flat files, 2) check whether that data is present in the master table, if not then insert that data into the master table 3) If data present then move that existing record to an history table and then update the main master table. All the 7 fields need to be checked to uniquely identify a single record in the master table. How can this be done Whether we can us a combination of data flow items or write a sql procedure ...Show All
SQL Server Setting up a synonym in SQL Server 2005
Can anyone tell me why I am getting this error when I try to select * from a table through a newly created synonym I have admin rights to both db, but they are on separate servers. <Error> OLE DB provider "SQLNCLI" for linked server "srvDEV" returned message "Communication link failure". Msg 10054, Level 16, State 1, Line 0 TCP Provider: An existing connection was forcibly closed by the remote host. Msg 18456, Level 14, State 1, Line 0 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. </error> <code> CREATE SYNONYM ARContractTerms_syn FOR srvDEV . EricsAdeptCastle . dbo . tblARContractTerms SELECT * FROM ARContractTerms_syn </code> Am ...Show All
Software Development for Windows Vista Show of Hands! Is WF by itself a viable approach to addressing a customer's workflow needs?
Like many of us in the forum I am in the all too often unenviable position to influence my client's decisions. I currently have a lot of customers evaluating workflow, many for the 1st time. I personally have avoided building "custom" workflow solutions whenever possible as I have had success in the past implementing packaged workflow or BPM offerings, both Microsoft-based and less recently non-Microsoft-based. It's allowed me to focus my energies on building solutions and solving real business problems, not building infrastructure. Granted, there are customer situations that don't require or afford you the opportunity to buy a packaged solution to address a workflow/BPM need, but I would argue those are/should be the exception n ...Show All
Visual Studio Team System check out script after build with tfsbuild.proj postbuild
Dear all i am prity new with the tfs and i will appreciate you kind help i whish to write a little script in the tfsbuild.proj file that after a specific build which i created, tfs checks out a file that located somewhere in the server i used the <exec> and the <target name="..."> and didnt succeeded in can someone help me pls!!!! Ron Following you original line of thinking, did you configure your Exec task to run the tf.exe commandline tool For example: <Target Name="CheckoutMyFile" DependsOnTarget="AfterDropBuild" > <!-- Checkout a file from tfs source control --> ...Show All
Visual Studio Express Editions VB2005 and microsoft access
I have been building a program with VB6 for my boss, it wasn't a perfect program but it did what it was suposed to do (most of the time). However, now we have VB2005 Express Edition and he asked me to rebuild it. I tried to convert it, but that didn't work (probably because there were to many thing that didn't work correctly) I am using forms with text-fields (all are with numbers, about 24 fields), I can see what I already had put in the database, but I can't add anything. I have seen many post on many forums about this, but I can't seem to find out how to inplant it in my program (mostly because i don't know what code is used to form the connection and what code isn't). So if someone could help me out and give me just the code needed ...Show All
Visual C++ call wrappers and function addresses in DLL's
Hi, I'm having trouble with C code that stores the addresses of functions that come from DLL's. The problem is I don't get the same value if I take the address of a particular function from two different DLL's. I can see that this is ultimately because the value my C code gets is actually an address in a jump table and my program has more than one one jump table. Here's my situation: .exe doesn't do much, just implicitly linked to DLL A which does all the work DLL A explicitly (calls LoadLibrary) on DLL B. Runs a routine in DLL B by calling GetProcAddress() etc, I'll call this initB() DLL B is implicitly linked to DLL A. When initB() is called it stores the address of a function inside DLL B in a list. I'll call that routine fu ...Show All
Smart Device Development Just API of Email
Hello, i m newbie i just want the API that will fetch the details of email contacts please help me ASAP. i m using c++ for development purpose Thanks in advance Regards Salman ...Show All
.NET Development Directory.Delete()
I use Directory.Delete(path); to delete a directory and the directory goes in recycle bin. How can i delete the direcory without going in recycle bin Thank You Hi, Directory.Delete(path); will delete the directory WITHOUT sending it in recycle bin. There must be some misunderstanding, it works perfectly, Please make it sure. HTH, ...Show All
Visual Studio Team System Inconsistent 2-tier TFS installation after SP1
First I installed the Team Foundation SP1 RTM on the application-tier and after that succeeded I went to the database tier. But I'm not able to install the service pack on it. Somewhere the installation stops and hopefully reverts it's changes. The lock-down of the SQL server through the "TFS_Quiescence" still stays. There some manuall task to revert this and the SQL server is accessable again. Now we can't get any source code anymore because there is always an error which says that an incopatible version is installed: "Detailed Message: TF53018: The application tier MY-SERVER is attempting to connect to a data tier with an incompatible version.". Could somone please help me, I really need to access the source. Is it ...Show All
Visual Studio 2008 (Pre-release) Query Builder C#/VB.NET component
Hello, I would like to incorporate a query builder component into my application so that I could bulid sql statement dinamicaly (SQL Server, Access). Are there anything in MS or third party tools you can suggest Thank you, serge Hi, You've reached the wrong MSDN Forum. Please refer to NET Framework Data Access and Storage . Guy Burstein http://blogs.microsoft.co.il/blogs/bursteg/ ...Show All
Visual Studio Express Editions strsafe.h before iostream triggers warnings
If I include strsafe.h before iostream in stdafx.h, I get numerous build errors. If I move strsafe.h after iostream, my project builds fine. It's disappointing that Microsoft's own headers can't use strsafe.h. Are there any better solutions than reordering the headers stdafx.h: #pragma once #define WIN32_LEAN_AND_MEAN // Exclude rarely-used stuff from Windows headers #include <tchar.h> #include <strsafe.h> #include <iostream> Build output: ------ Build started: Project: iostream_secure, Configuration: Debug Win32 ------ Compiling... stdafx.cpp c:\program files\microsoft visual studio 8\vc\include\cstdio(33) : error C2039: '_gets_instead_use_StringCbGetsA_or_StringCchGetsA ...Show All
Visual Studio 2008 (Pre-release) Setting foreground and background to be the same when a control is disabled
Can someone suggest XAML code that would set the foreground and background of a control (say a TextBox) to be the same when it is disabled as it was when it was enabled. I mean if the Background was white and Foreground was Black when the TextBox was enabled, if the TextBox is disabled, the Background and Foreground should remain the same and not be grayed out. this works fine for me < ControlTemplate.Triggers > < Trigger Property = " IsEnabled " Value = " False " > < Setter TargetName = " Border " Property = " Background " Value = " {TemplateBinding Background} " /> </ Trigger > </ ControlTemplate.Tri ...Show All
Windows Forms whenever user INSERTS a new record,current date must be displayed in the DATETIME picker contro
Hi, On a data-entry form in VB 2005, i have a Datatimepicker control. I want that whenever the user clicks the INSERT button to add a new record, the current date must be displayed in the control & the same saved to SQL db. The user may or may not change the date. But, by default the current date must be displayed. How can i accomplish this i am using tableadapters Alex Hi, In your "Insert" button's event handler, simply set the date on the DateTimePicker: MyDatePicker.Value = DateTime.Today(); If the DateTimePicker is data bound to a data source, then this will also update the underlying date. Hope this helps Luc ...Show All
.NET Development Code Access Security
Hello All. I'm starting work on a Windows Forms application -- still in the design stages -- and I'm at the point of laying out the security considerations. The anticipated deployment scenarios are: 1) Distribute the .msi package via Web or removable media 2a) Deploy to a single client machine, or 2b) Deploy to a LAN, either client/server or peer-to-peer. My security question pertains to the LAN deployment scenario. Now, I'm making the assumption that a standard user on a LAN will very likely be running under the "LocalIntranet" permission set, which forbids calls to unmanaged code. However, the Application.Exit() method requires permission to call unmanaged code. Now, as I see it, I can do one of several th ...Show All
Visual C# Mixed lanugue
HI I look for two days for this issue and did not found a lead. I i use mixed lanuge like hebrew and english when i concating thoes two string it concating according to RTL and not to LTR. My quiestion hwo can i control it. Best Regrads, Yuval ABraham Hi Guy Thanks for the answer. The problem is the debuger, i was amazing to discavare that the debuger show me wrong. if i use substring function i found the corect data. Best Regards, Yuval ...Show All