Subject Re: [ib-support] Execute Script
Author Sivaraman Krishnan
Hello,
i have to transfer the data from one gdb to another thro' cloppy.For
that i am writing all the datas in the single line,
as (execute procedure dbprocfloppydownload(param1,param2....)).

In the another application, if i load this file in the script, and execute
it, it has to transfer the data.
The parameters are going to different tables and
i write the insert statement in the procedure.Now without using this select
* from dbprocfloppydownload(param1,..param2)
how can i do this?
Can you give some suggestion for this?
Sivaraman



At 08:29 PM 14/01/2003 +1100, you wrote:
>At 02:55 PM 14/01/2003 +0530, you wrote:
> >Helen,
> >
> > I need to solve this problem right now.Can u help me?
> >
> > 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.
>
>HB
>
>
>
> >This is that sql.
> >In the front end(Delphi 5.0 ib_script,), i am getting this sql from one
> >text file and
> >when i execute script, nothing happened.
> >
> >What could be the problem?where i am doing mistake??
> >
> >Sivaraman
> >Software Associates Information Technology
> >Calicut,
> >india
> >
> >
> >
> >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/>http://docs.yahoo.com/info/terms/
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to the
><http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.