> > When i execute one one procedure thro' query in ib_sql it is

executing

> >without saying any error.
> >But inside the procedure, i had written one insert query.But that row is
> >not inserted.
> >
> >select * from dbprocdownloadfloppy('si','ij');
>
> That looks like nonsense for a DML query. You don't perform a SELECT

query

> to perform an insert.

I think that the right "wording" should be:

You _shouldn't_ perform a SELECT query to perform an insert.

:)

Anyway, it's hard to tell without the procedure source.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."