This is better :

insert into tableA select fieldA,fieldB from storeprocA(Param1,param2)

-----Message d'origine-----
De : Sandeep [mailto:sandeep@...]
Envoye : mardi 30 octobre 2001 20:55
A : ib-support@yahoogroups.com
Objet : Re: [ib-support] Stored Procedures

On 30 Oct 2001, at 12:12, Mike Grover wrote:

> Is it possible to do a select on a stored procedure that
> Insert's a record into a table?
>
> If so, where can I find a example?
>
> thanks, mike

something like this might work

insert into tableA (tableAfieldA, tableAfieldB)
values (select fieldA, fieldB from StorProcA)

(the syntax might not be 100% correct)

Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/