Hi...
People, i wanna know how can i know inside of a function whar the
trigger called, i mean which instruction SQL it called.
I do not wanna know if it´s a insert, update or delete (tp_op), i need
to know the complete instruction.
For example, i need to know something like this:
update phones
update just for that column. But
i do not know in which column his has made that change. So, i need to
know the instruction to do this. Something like a specific update for
that column modified by the user.
Thanks very much.
Wilton Ruffato Wonrath
No virus found in this outgoing message.
Check
nsert = StrInsert || virgula || StrCampo || '' - '';
End Loop;
Return new;
End;
What i need to do for the variable StrCampo returns to me "SP", "RJ", i
mean, return a value inserted into the field.
I do not want to use static command new.campo1, new.campo2.
telefone set numero = '-';
Thanks, and sorry if it´s not here to put the message... just say me
where i need to write this question... Thank you very much
Wilton Ruffato Wonrath
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Viru
Hello,
I have a doubt about a query using a range of caracters. Example:
Data Table
Inicial - Final
9C2HB02107R008000 9C2HB02107R008200
FAIXA1FAIXA100
I´m doing the