Ver Mensaje Individual
  #4  
Antiguo 30-01-2010
Avatar de Lepe
[Lepe] Lepe is offline
Miembro Premium
 
Registrado: may 2003
Posts: 7.424
Reputación: 29
Lepe Va por buen camino
El "into" no viene en la sintaxis de returning.

Cita:
Empezado por Firebird-2.0-LangRef-Update.pdf
RETURNING clause
Available in: DSQL, PSQL
Added in: 2.0
Description: An INSERT query – unless it is SELECT-based – may optionally specify a RETURNING clause to
produce a result set containing the values that have been actually stored. The clause, if present, need not contain
all of the insert columns and may also contain other columns or expressions. The returned values reflect any
changes that may have been made in BEFORE tiggers, but not those in AFTER triggers.

Example:
insert into Scholars (firstname, lastname, address, phone, email)
values ('Henry', 'Higgins', '27A Wimpole Street', '3231212', null)
returning lastname, fullname, id
__________________
Si usted entendió mi comentario, contácteme y gustosamente,
se lo volveré a explicar hasta que no lo entienda, Gracias.
Responder Con Cita