Hi Milan,

Thanks for your reply.

I am making the Insert sql and putting semicolon at the end of each Insert sql. And putting them into TStringList component.

Then i am assigning this TStringList data to TIB_Script component as follows:


var
Script_Comp : TIB_Script;
Str_List : TStringList;
begin
//after putting all Insert sql into "Str_List" TStringList component, i am executing them as follows:

Script_Comp.SQL := Str_List;
Script_Comp.Execute;
end;


Am i missing something here?

Thanks in advance

Vishal

--- On Tue, 30/3/10, Milan Babuskov <milanb@...> wrote:

> From: Milan Babuskov <milanb@...>
> Subject: Re: [firebird-support] Insert Statement Taking Time With TimeStamp values
> To: firebird-support@yahoogroups.com
> Date: Tuesday, 30 March, 2010, 6:54 PM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>  
>
>
>
>
>
>
>
>
>
> Vishal Tiwari wrote:
>
> > When i am trying to insert 2000 records with all
> columns values, it takes time, but the data is posted
> correctly.
>
>
>
> Of course it takes time, you can't expect something to
> happen in no time
>
> :) Now, how much time does it take exactly?
>
>
>
> How do you do the inserts?
>
> Do you use prepared statements?
>
>
>
> What do you use to interface to the database? If it's
> isql, show us the
>
> script (or part of it). If it's your program, show us
> some code.
>
>
>
> Also, it might help to read this:
>
>
>
> http://www.firebird
> faq.org/faq13
>
>
>
> Regards,
>
>
>
> --
>
> Milan Babuskov
>
>
>
> ============ ========= ========= ====
>
> The easiest way to import XML, CSV
>
> and textual files into Firebird:
>
> http://www.guacosof
> t.com/xmlwizard
>
> ============ ========= ========= ====
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>


Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/