I have an in house app that has both a Web Interface and a Desktop Interface(is an OCA using Merge Replication). We are still using SQL 2005 and have many 'Archive' tables set up. These are filled by Triggers on there relating Table. tblPersonArchive for tblPerson, etc. To keep the Replication Sets as small as possible I would like t...
I have this trigger: create or replace trigger t_calctotal after insert or update on item_fornecimento REFERENCING NEW AS NEW OLD AS OLD for each row begin if inserting then dbms_output.put_line(' On Insert'); update fornecimento f set f.total_enc_fornec = f.total_enc_fornec +:NEW.prec_total_if where f.id_fornecimento = :NEW.id...
Hi, I am trying to use the Silverlight DataStateBehavior, it works fine in most cases where I click a button which sets say a 'Selected' Property in the view model to either false or true. The DataStateBehavior then tells the VisualStateManager to go to the relevant state. Like this: <Button...> <i:Interaction.Behaviors> ...
Hi all, First question here. Anyway, here it goes: I have a XAML Windows with a lot of DatePicker controls (DatePicker from the WPFToolkit on CodePlex). Every DatePicker has a default Value of 1/1/1990 and if no other date is selected, I want (or rather my boss :-) ) to display the Text in gray italic and not in Black. Thus, it makes it...
I'm just getting started with svn so please, help me out if I saw anything stupid. I'm developing on a windows laptop using tortoisesvn. I'm deploying to a linux server. I have my repo set up and checked out on my laptop. I can't manage to check it out to a directory on the server. I've created a directory for it but can't get svn chec...
So I've decided to use Quartz.NET to schedule some tasks for me in my application and I'd like to schedule my tasks to run daily from the following 3 pieces of information. TimeSpan startTime //i.e. 10:30 TimeSpan endTime // i.e. 18:30 TimeSpan repeatInterval // 30 Minutes And the trigger will fire every day at 10:30, 11:00, 11:30......
I want to be able to "change" my listview into another control. I was thinking having the control's visibility set to hidden and when a button is clicked, change the visibility. Do I have to do this programatically? Or can I use a trigger? ...
Can anyone please tell me what is wrong with this query? create trigger Test_trigger before insert on Test for each row begin select TestSequence.nextval into :new.id from dual; end;/ When I run this query, I get the following error: ERROR at line 1: PLS-00103: Encountered the symbol "end-of-file" when expecting one of th...
My tables: TableA (id number, state number) TableB (id number, tableAId number, state number) TableC (id number, tableBId number, state number) So items in TableC are TableB's children and items in TableB are TableA's children. Vice versa - items in TableA are TableB's parents and items in TableB are TableC's parents. I'd like to con...
I know it's available since version 5.1,but : Is it stable? Is it possible to trigger event when there is insert/update operation on specific columns instead of the whole table? ...
Hello, i'm trying to make a TRIGGER in ORACLE using ORACLE SQL DEVELOPER, I would check that the dates entered as start date reservation to reservation date or date of a service charge will be equal to or greater than the current date is inserted in the record. these are the fields in my table Service (date_service, cost_variation, num...
Hi, I want to write a windows service in C# that will wait for a change in the particular table in PostgreSQL database and then operate based on the data from the last inserted row. As far as I know (I'm new to PostgreSQL) I can use triggers to execute a function in structural code - but how to make it pass the data to my service? Tha...
I have a table X in tablespace T1 and a table Y in tabelspace T2.(Oracle DB) I have to create a trigger in tablespace T1 that will, on the event of updating a column C in table X, update column D in table Y (tablespace T2). Because they are in different tablespaces, my first question is can this be done at all? And if yes then how it...
I have some code in an after insert trigger that may potentially fail. Such a failure isn't crucial and should not rollback the transaction. How can I trap the error inside the trigger and have the rest of the transaction execute normally? The example below shows what I mean. The trigger intentionally creates an error condition with th...
If there's: IF UPDATE (col1) ...in the SQL server trigger on a table, does it return true only if col1 has been changed or been updated? I have a regular update query like UPDATE table-name SET col1 = 'x', col2 = 'y' WHERE id = 999 Now what my concern is if the "col1" was 'x' previously then again we updated it to '...
I'm not sure if this is possible but is there a way to select A unless its null then select B instead? I am writing a trigger, my code is insert into tbl_a(userid, obj) select p.author, new.id FROM user_comment AS p WHERE p.id=new.parent however new.parent is a nullable long (i'll switch to foreign key once supported in system.data...
Hello, I have a little problem and I don't know how can I fix it ... I created a CustomControl called "StandardKeyView" from a Button. This control has a dependency property "DownImage" which is used to define a Background Image to my control during the mouse over. Here's the definition of the DownImage property : public SolidColorBr...
I would like an UpdatPanel to update it's content once a button is clicked - this button is contained within a UserControl placed on the webpage. However, I cannot just simply reference it using the AsyncPostBackTrigger's ControlID property, because the button is not situated directly on the webpage. Is there any way to reference it to...
Why will not this work: <Button Width="200" Height="50"> <Button.Style> <Style TargetType="Button"> <Setter Property="Height" Value="{Binding RelativeSource={RelativeSource Self}, Path=Height}"/> <Setter Property="Background" Value="Blue"/> <Style.Triggers> <Trigger Property="Button.Is...
Once again I want to load a page which contains its own script into a div using $("divid").load(...). The problem I face is related to events. Let's say we trigger("monkey") from the parent page and on the loaded page we bind("monkey") and just do an alert("monkey bound"). If the same load method is called multiple times, the bind is ...