Triggers

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Mike (anonymous_at_discussions.microsoft.com)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 04:06:09 -0800

Hi

In the table designer I gave the procedure name 'InsUpdAccountMasterTrigger' in the Insert and Update Trigger. Then I created the procedure in the stored procedure with the following code

Repl <fieldName> With Upper(accountName)
Return .T.

When I add records to the table, it gives me an error. I am updating another field in the same table.
How can I do this ?

Mike

Relevant Pages

  • Re: How to write long string sentences
    ... > Whether or not a stored procedure was an option, ... > a data command object placed on an Component to manage my SQL statements ... > set properties of these with the properties window. ... > designer & property window of the component will allow you to use a visual ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Databinding error using LINQDatasource with stored procedure
    ... SPROC from server explorer to the dbml file designer window and dragging it ... check the GetproductsResult class. ... procedure in the designer by dragging the stored procedure from the Server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Looking for Comments on Code
    ... I was talking about capability of LINQ to SQL designer to create wrapper methods for stored procedure invocation IOW it creates a C#/VB method with all the parameters that sp expects. ... "Jonathan Wood" wrote in message ... I preffer doing a strong typed approach - i.e. use a code generator (think CodeSmith, or LINQ Designer if you work with VS2008) that generates strong typed methods for me. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Looking for Comments on Code
    ... but then I guess I'd need to create one for each stored procedure. ... The designer is still something I haven't yet become familiar with. ... RightHand .NET consulting & development www.rthand.com ... "Jonathan Wood" wrote in message ...
    (microsoft.public.dotnet.framework.adonet)
  • Where The Hell is My Stored Procedure?
    ... I created a non result returning query using the Dataset Designer that ... titled QueriesTableAdapter with the stored procedure name in the box. ...
    (microsoft.public.dotnet.languages.vb)