Robert F Bouillon's Q&A profile

• SQL Server Need to do exact opposite of current trigger

  I have a trigger ALTER TRIGGER trInvoiceDetails_IU_UpdateQty ON InvoiceDetails FOR INSERT , UPDATE AS IF @@ROWCOUNT = 0 RETURN IF UPDATE (Qty) UPDATE WInventory SET WInventory.InStock = ( WInventory.InStock - i.Qty ) FROM inserted i JOIN WInventory ON i.ItemID = WInventory.ItemID This works perfectly, Now I need trigger on Delete ALTER TRIGGER trInvoiceDetails_ID_ReplaceQty ON dbo.InvoiceDetails FOR DELETE AS /* IF UPDATE () ...*/ --IF update (InvoiceID) return UPDATE WInventory SET WInventory.InStock = ( WInventory.InStock + d.Qty ) FROM deleted d JOIN WInventory ON d.ItemID = WInventory.ItemID This tells ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XBox 360 shader compatibility?

  As the XNA framework will be PC <-> XBox 360 I'd like to know what shaders are supported by the XBox 360. Afaik the ATI Xenos GPU of the XBox 360 supports every shader even up to the coming shader model 4.0 (160 operations per cycle), is this correct As far as I'm aware the Xbox shader model is a superset of Windows shader 3.0. I could be wrong about some details, but it is certainly close to that. You can't run 3.0 Windows shaders directly on Xbox, though, because the output format is different. Xbox doesn't support the same token format as Windows, so it won't be able to handle the output of the Windows HLSL compiler. That means you need to compile your shaders twice: once for Windows targetting shader model 3.0, a ...Show All

• Visual Studio Express Editions is there a add-on "reportview" that can be use in VB Express?

  is there a add-on "reportview" that can be use in VB Express What exactly are you trying to do Create a report in access and then show it in a form using VB Express If you are working with access then you can do reports in access. Access has (VBA) Visual Basic for Applications. ...Show All

• Windows Forms can i Connect multi table on the datagridView

  please answer me can i connect multi table with dataGridview if can give me example thanks Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Dim dsOrdersAndDetails As New DataSet() Dim daOrders As New SqlClient.SqlDataAdapter() Dim daDetails As New SqlClient.SqlDataAdapter() Dim conn As New SqlClient.SqlConnection() Dim tblOrders As New DataTable() Dim tblDetails As New DataTable() dsOrdersAndDetails.Tables.Add(tblOrders) dsOrdersAndDetails.Tables.Add(tblDetails) conn.ConnectionString = "Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI" ...Show All

• .NET Development My.User.Name returns empty string.

  I made a console application like this... Module Module1 Sub Main () Debug . Print ( String . Format ( "UserName = {0}" , My . User . Name )) Debug . Print ( String . Format ( "IsAuthenticated = {0}" , My . User . IsAuthenticated )) End Sub End Module And all I get from the My.User.Name is an empty string... any ideas I'm logged in to the network at my job so it shouldn't be because it thinks I'm not logged in. interesting. Namespaces should be supported fully regardless of the type of application , being it a winforms or console. I just tested this and I too have this problem. (And I am running WS2003EE SP1) I've ...Show All

• .NET Development rename file

  I'm having problems with the c# code below. ----------------------------------------------------------------- using System; using System.Collections.Generic; using System.IO; using System.Text; namespace myLog_FileCopy { class Program { static void Main(string[] args) { string winfile = @"C:\Log\alog.txt"; string unixfile = @"C:\Log\Ulog.txt"; //rename the files RenameWinLog(winfile); RenameUnixLog(unixfile); } //rename windows log file static void RenameWinLog(string winFile) { string winfileRenamed = @"C:\Log\aw.txt"; if (!SourceFileExists(winFile)) return; //Error File.Move(winFile, winfileRenamed); } //rename unix ...Show All

• Visual C# Generics in C# - new() cnstraint

  Hello...   I am trying to play a bit with the generics feature of the .Net 2.0 Framework and I ran into this "Problem"   I try to create a Singelton Base-Class, which will create an instance of itself if the instance is accessed. Since I want to create an Instance of <T> inside my generic Base, I need to supply a new() contraint to <T>. This "forces" me to create a public constructor, since that what new() means.  I think the scope of new should not be "public" but  "protected". Protected would allow me to hide the constructor from the outside world, but it would still allow the creation of the class inside the baseclass. Since I am not able to do this, a direct creation of my Bas ...Show All

• SQL Server Poor performance and statistics

  I have a process that runs throughout the day. For the past month we have been fighting performance issues with this process. It normally runs for 30-45 seconds but then all of a sudden it will start taking 5 minutes to complete. The server is idle with no queue waits. One I run Update Statistics With FULLSCAN everything returns back to the normal 30-45 second runtime. I run this command for all tables in the database on a nightly basis. I have also been running a SQL Profiler trace and capturing all Auto Stats events. The results show that none of the tables/indexes that are used by this process never have auto statistics generated for them so they should still use the same statistics that were created during the nightly ...Show All

• Visual Studio Express Editions c++ code

  Hello, Why this code dot work on VC++ 2005 express, but work on Dev C++ If I write something in c++ this should work on any c++ compiler or not I was put include stadfax and nothing. Thanks in advance. #include<iostream> #include<string> using namespace std; void okvir(const int & x); int main() {     cout << "Number of lines  ";     int n;     cin >> n;     string tekst[n+1];     cout << "\nTekst:" << endl;     int a,b = n;     for (i ...Show All

• Visual Studio 2008 (Pre-release) StartupUri and custom control libraries

  Hi, I'm trying to launch my WPF app with a page that is defined in a custom control library. How do I format the StartupUri to identify the assembly that the start page is in I've tried variations of StartupUri="pack://application:,,, assembly_name;path_to_page ", all without success. How is this done Thanks! - Imad Thanks for the reply. I didn't find the answer I was looking for in the article you mentioned. However, I went back to this article: http://windowssdk.msdn.microsoft.com/en-us/library/ms743619(VS.80).aspx I realized the correct syntax is: StartupUri="pack://application:,,, assembly_name; component/ path_to_page " So the key here is to include "component/" to ...Show All

• SQL Server How to deal with the problem? "Errors in the OLAP storage engine: "

  Who can tell me how to result the problem Errors in the OLAP storage engine: The attribute key cannot be found: Table: FactSalesSummary, Column: ProductKey, Value: 212. Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute Product of Dimension: Product from Database: Teradata Adventure Works Test, Cube: Teradata Adventure Works, Measure Group: Fact Sales Summary, Partition: Fact Sales Summary, Record: 1. Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. Errors in the OLAP storage engine: An error occurred while process ...Show All

• Visual Studio Express Editions Shouldn't the Express Editions be Integrated?

  Salute to all of the folks who contribute the answers here. I have loaded VB and SQL Server. I was under the impression that the versions would be more integrated and running together as one application. Did I miss something during the installations from CDs Everything runs stand-alone. Each application has its own splash screen at startup, which lists "installed applications" or something like that. All I see is the name of the current application. Should I be seeing all of the Express Visual applications that I have installed on my machine or not Sometimes I get connect/disconnect problems with SQL databases while running VB if I open them or have them already open with SQL SMSE. I just have to pay attention to what i ...Show All

• Smart Device Development How to pair my Windows Mobile 2003 with GPS Bluetooth Device programmaticaly

  Hi Guys, I have a problem to pair WM2003 (T-mobile MDA III) with GPS Bluetooth from my application (.NET CF1.0 SP3). I found some posts, which describes, that this is not possible Good solution too is a possibility to start Bluetooth Manager from my app. Thanks Tihomir Ignatov Please follow link above, it describes how to resolve this problem. ...Show All

• SQL Server "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 1627

  Hello, We are running Windows Server 2003 SP 1 and trying to upgrade SQL 2000 SP 4 to SQL 2005 using the command line. The process finishes in under ten minutes. Summary.txt file we have this information: Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup_<ServerName>_SQL.log Last Action : ValidateUpgrade Error String : The installer has encountered an unexpected error. The error code is 2259. Database: Table(s) Update failed Error Number : 2259 In the log file named SQLSetup_ServerName_Core.log I found the following: Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "C:\Program Files\Microsof ...Show All

• Visual C# What is the equivalent solution of Microsoft?

  What is the equivalent solution of Microsoft to produce similar page (Please register for a real time trial) http://www.peachtree.com/download/trial.cfm Note that in the trial, user can try software online and the winform UI is seen inside the browser. I know that in .NET, we can load a single .dll(not an entired winform application) in a webpage. Although I haven't registered for a free time trial my guess is that they use ActiveX control. It is possible to host a User Control in IE. Depending on what exactly your requirements is you could take a look at ClickOnce deployment: ClickOnce Deployment for Windows Forms Applications ...Show All