Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by a5b5c5

  1. a5b5c5

    Update trigger

    Well I looked up some examples and they had an if statement something similar to what i have..Is it wrong? If so, then what would be right way of inserting the update condition
  2. a5b5c5

    Update trigger

    The Select part of the query works perfectly because I tested it and I was able to come up with a few records..So no issues on that side.
  3. a5b5c5

    Update trigger

    No I dont get any errors when I update on the table. Here is the syntax of the trigger. CREATE TRIGGER ContacatLoadTableInsert ON Main5.dbo.Part FOR UPDATE AS IF UPDATE(Main5.dbo.Part.LSE_Complete_Date) BEGIN INSERT INTO SALESFORCEBK.dbo.Contact_Loadtest (AccountId, Birthdate...
  4. a5b5c5

    Update trigger

    Alright..here is my problem 1.Whenvever the field LSEComplete which is on table Part on database X get updated. 2.An update trigger should get executed. 3.The update trigger will import some of the fields from Part table and some of from other tables within Database X (i.e there will multiple...
  5. a5b5c5

    Update trigger

    Hi, I am trying to create an update trigger which will be triggered when a field named LSEComplete on the table named Part on database X get updated would import various fields associated with LSEComplete from more than one table on database X to a table called Contactloadtest on Database Y...
  6. a5b5c5

    automatically populating the fields from one database to another

    Scneario We have a Salesforce application that is right now being implemented to enter placement information.We also have another home grown application where we will automatically populate the placement information coming from salesforce. Issue 1. The placement information coming from...
  7. a5b5c5

    Trigger on a View help

    Hi, I created two seprate triggers for insertion and updates from a view on a database A to to multiple tables on database B.But when I tried to test the trigger by inserting records on the view on database A, the trigger did'nt do anything.Can anybody help me on this? Insertion Trigger Syntax...
See more

Part and Inventory Search

Back
Top