Re: [SQL] Trigger with Stored Procedure [Client Points]

2006-08-31 Thread Aaron Bono
On 8/31/06, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote: Bono,I must check each insert on my Points(each shop generate a new line on Points table).When I insert  the  record  on points  I must  see the field Value(on points table already) and update the Client.Points field based in some

Re: [SQL] Trigger with Stored Procedure [Client Points]

2006-08-31 Thread Aaron Bono
On 8/30/06, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote: Hi list,I have a table like this:Points-Idoperationvalueand another two tables like thisClient    Rule    -

[SQL] Trigger with Stored Procedure [Client Points]

2006-08-30 Thread Ezequias Rodrigues da Rocha
Hi list,I have a table like this:Points-Idoperationvalueand another two tables like thisClient    Rule    ---id idname