Subject RE: [ib-support] Stored Procedures
Author Ignace MARTIN
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 :
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)



Software Developer

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to