looping the new record

This is the right place for general Firebird questions regarding SQL syntax, technical questions etc.

looping the new record

Postby Soahc » Tue Feb 09, 2010 1:20 pm

Hallo,

is it possible to loop through the elements from the new record in an before update Trigger?
The only way I know to access the new record is using the point notation, like new.ID...

thanks for help,

Soahc
Soahc
 
Posts: 1
Joined: Tue Feb 09, 2010 1:11 pm

Re: looping the new record

Postby EMBarbosa » Fri Feb 12, 2010 2:32 pm

I think there's no such notation in SQL Standard.

Anyway, maybe you could use some execute statment in conjunction with systems tables. But I am helpless in this use, cause i do use it very much. :D
Also, it should be slower and a hard to understand code...
EMBarbosa
 
Posts: 39
Joined: Thu May 15, 2008 9:27 pm


Return to Firebird Database Engine

Who is online

Users browsing this forum: No registered users and 1 guest