At 08/06/2002 04:19 AM, you wrote:

>Hi All
> I Put 888.666 Rows, Reading from a Fixed Length Text file (96
>MB) to my GDB approximately 40 Minutes by using a stored procedure and
>using CommitRetaining every 10.000 records. This result satisfied me.
>
>But the result below is UNBELIVEABLE!!
>
>I'll try it also...
>
>I wonder this
>
>INSERT INTO SOME TABLE (TABLE_ID,AFILED1,AFIELD2) VALUES
>(GEN_ID(SOME_GEN,1),XXX,XXX);
>Is this Possible??

Only, if you know that your INSERT statement is correct and doesn't have
any parameters, then I would say yes otherwise let IBO check your statement
before sending it. Also, don't expect using a SELECT with this method,
since it doesn't return any results. The syntax of the this method is
TIB_Transaction.ExecuteImmediate(ACommand: String).


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)