If you want to use parameters then ideally you should just use
isc_dsql_execute() since it allows you to prepare it and keep it so that the
server only has to parse/compile the statement once. the
isc_dsql_executeimmediate() requires the server to parse/compile each
statement that is sent to it.

In IBO, use a TIB_DSQL component if you are doing INSERT statements. It is
the most efficient.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <simpor81@...>
To: <ib-support@yahoogroups.com>
Sent: Monday, January 29, 2001 9:44 AM
Subject: [ib-support] Writing data in tables!


> Hello!
>
> I have problems when I'm trying to write data to a table. How are you
> supposed to do it???
>
> I have managed to connect to the database (at least I think that I
> have) but when I try to write to a table it craches the hole time.
>
> I'm using the isc_dsql_execute_immediate. But I need to use a SQL
> with parameters. How does the code look like when you write to a
> table in employee.gdb "Any table will do". I will be able to write
> let us say 100 new post to it.
>
> Thanks for all the help!
>
> Simon
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>