All values for inserts are converted to string so there are no parameters.
Sorry to hear that.
MyStatement.SQL.Text:=’INSERT INTO MyTable(Field1, Field2) VALUES (:Param1,
:Param2)’;
MyStatement.Prepare;
while not eof(InputFile) do
begin
readln(InputFile);
On 9.10.2014 ã. 14:32 ÷., brucedickin...@wp.pl [firebird-support] wrote:
Thank you guys for your input! I appreciate it!
I have some doubts.. isn't TCP/IP a bottleneck here? I mean, I am
sending for example 4 times (4 threads) more data to insert via network.
@Doychin I do have like 2-3
I'm joining this late and may have some of the details incorrect. But
doesn't your client tool have a batch insert object? If your client is
written in either Delphi or .NET, I'm pretty sure it does and that would be
the best way to insert bulk records.
Dixon
On Thu, Oct 9, 2014 at 8:18 AM,
On 9-10-2014 14:57, 'E. D. Epperson Jr' dixonepper...@gmail.com
[firebird-support] wrote:
I'm joining this late and may have some of the details incorrect. But
doesn't your client tool have a batch insert object? If your client is
written in either Delphi or .NET, I'm pretty sure it does and
I was referring to SqlBulkCopy which is part of the System.Data.SqlClient in
C#. I used that a couple of years back, but granted it was with MsSql.
However, I thought I remembered having a similar tool to that back in the
Delphi 7 days, I just don't remember if I used it with Firebird or
@Dixon It is never to late to join conversation;) Thanks for your suggestions,
I've found some interesting methods in my client's library.
@Doychin: I am using Delphi and FIBPlus. I am not sure if we mean the same
thing by batch script. Some guys at my company prefer to generate a long
script