Suppose i am having stored procedures which performs Insert/update/delete operations on table. Depending upon some criteria i want to perform some operations. Should i create trigger or do the operation in stored procedure itself. Does using the triggers decreases the performance? Does these two tables viz Inserted and deleted exist...
I have an update panel and a list of buttons that trigger it. I need some way to find out which button was pressed when the load method (which is caused by the triggers) goes off, but I can't figure it out. Sender doesn't cast into the trigger, but the update panel itself. I need to perform some action based on which button was pressed....
I'd like to automatically update a database column with an aggregate of another column. There are three tables involved: T_RIDER RIDER_ID TMP_PONYLIST ... T_RIDER_PONY RIDER_ID PONY_ID T_PONY PONY_ID PONY_NAME ... T_RIDER and T_PONY have an n:m relationship via T_RIDER_PONY. T_RIDER and T_PONY have some more columns ...
I have a DataTemplate that will be a templated ListBoxItem, this DataTemplate has a ComboBox in it which when it has focus I want the ListBoxItem that this template represents to become selected, this looks right to me. but sadly enough it doesn't work =( So the real question here is within a DataTemplate is it possible to get or set th...
I am trying to create a simple style that highlights the focused UI Element (Textbox,combo,etc) while it has focus, and goes away when lost focus. I came up with this: ` <Style TargetType="{x:Type FrameworkElement}" x:Key="OnFocus"> <Setter Property="Effect"> <Setter.Value> <DropShadowEffect Col...
I'm currently using Microsoft Sync Framework and everything is working fine except the SQL triggers which don't appear to fire sometimes. Here is the trigger code generated by the framework. It works 90% of the time but occasionally the CreationDate is NULL after an insert. Could there be some date issue that I'm overlooking? set ANS...
I have an adjacency list on a legacy system that I would like to query recursively (need to get subtotals, etc). Can I make a trigger in MySQL that either store in a separate table, or alternatively store in separate columns in the same table the "Nested Set Equivalent" of a given set? My set is like this: +-------------+-------------...
Is there anyway invoke a PHP page / function when a record being inserted in to the mysql db table. We dont have control over the record insertion procedure.Is there some thing called trigger which can call a PHP script back ? ...
$(".LWdrop").droppable({ accept: ".LW", drop: function(event, ui){ ui.draggable.addClass("LWactive"); $(this).droppable('option', 'accept',''); $(this).css("background-color", "#444444"); }, out: function(event, ui){ $(this).droppable('option', 'accept', '.LW'); u...
What I want is simply that all my TextBoxes as by default set their cursor at the end of the text so I want in pseudocode: if (TextChanged) textbox.SelectionStart = textbox.Text.Length; Because I want that all textboxes in my application are affected I want to use a style for that. This one won't work (for obvious reasons) but you get...
Hi, Does anyone have a successful workaround for changing a style in silverlight based on a property of the underlying data object, in that when the value changes so does the style. I used WPF briefly and it obviously has the DataTrigger which seems to cover this but it is missing in Silverlight. I found this: http://blois.us/blog/2009...
Hi all, does anyone have experiences whether it's possbile to add triggers and custom tables to MBS systems? To be more exact: I want to add a trigger and table to a Microsoft CRM installation in order track several changes to some records in the system. Is that a possible way to go or are there any technical / legal issues which make ...
I have a trigger on INSERT in MySQL 5.1. I want to know, how many times per second is it called. How can I do this? ...
am using mysql 5.1..am wrote trigger after update.. CREATE TRIGGER myTrigger AFTER UPDATE ON employee FOR EACH ROW BEGIN INSERT into transaction_log values(12,'free'); END . . . here am using 2 tables..if update the data on employee table.value insert another table(transaction_log).but its not working.. ...
I am creating a simple custom control extending from toggle button that allows the user to specify checked and unchecked content directly in XAML. It works well but it is based on a trigger, and I don't know how to define the trigger except in a style. If I define the style, then I lose anything set outside of the custom control. What...
Hi! I have a login form that contains a username textbox and a password box. I want the ok button to be enabled only when both the fields contain a value. I have a converter that check for all the strings if they're null or empty. I placed a breakpoint on the first line of the Convert method, and it stops only when the MenuItem initial...
I am using mysql5.1 and wrote trigger after update.am using same table for insert and updae. table contains field .id,itemid,value1 all are integer.. my trigger is: CREATE DEFINER = 'root'@'%' TRIGGER `trig_same` AFTER UPDATE ON `vote` FOR EACH ROW BEGIN insert into vote values(10,1,100); END| ...but when i excute update com...
Hi all, can anybody explain me the below code for trigger?Please note that the above code was written by one of my class mate and I cannot understand anything in it. I am not able to understand it. Also if there is any other way to accomplish the same task then please let me know. CREATE trigger [dbo].[trg_InsertInBookIssuedDetails] ...
I am dealing with some sensitive Accounting tables and I would like to audit any SELECT statement executed on the table or any views associated with them. I did not find any DDL Events on BOL (Books Online) that had anything to do with SELECT statement. And DML triggers are for INSERT, UPDATE and DELETE only. Is it possible to log who ...
Hi! I created some dependent dropdowns in a chain. The one at the top should fire multiple Ajax requests for each dropdowns below it. I'm using jQuery 1.3.2 with livequery so event handlers should be bind for all reloaded DOM items, yet triggering change doesn't occur for newly updated elements. What am I doing wrong over here? funct...