Re: [firebird-support] BLOB

2014-10-10 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Fri, Oct 10, 2014 at 9:58 AM, tiberiu_horv...@yahoo.com [firebird-support] wrote: > > > my BLOB records are plain text phrases, somewhere between 1 and 400 char-s > , containing setup information (in Delphi I save a TStringList to file and > I backup that file in my database). > Hmmm. What

RE: [firebird-support] BLOB

2014-10-10 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
>my BLOB records are plain text phrases, somewhere between 1 and 400 char-s , >containing setup information (in Delphi I save a TStringList to file and I >backup that file in my database). > >My question was about saving these tables with gbak -v (verbose) where I can >see the time spent to back

RE: [firebird-support] BLOB

2014-10-10 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
Carlos, > LSSBcfs> Our application uses BLOB fairly extensively and can report > LSSBcfs> that the GBAK disk write rate increases very significantly when > LSSBcfs> tables with Blobs are being backed-up, orders of magnitude > LSSBcfs> faster than tables with small rows (YMMV), so this suggests > L

Re: [firebird-support] BLOB

2014-10-10 Thread tiberiu_horv...@yahoo.com [firebird-support]
my BLOB records are plain text phrases, somewhere between 1 and 400 char-s , containing setup information (in Delphi I save a TStringList to file and I backup that file in my database). My question was about saving these tables with gbak -v (verbose) where I can see the time spent to backup

Re: [firebird-support] Problem with "Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements"

2014-10-10 Thread Harriv har...@gmail.com [firebird-support]
The application is done with Delphi XE 2using UIB library for Firebird connection. Running on Windows 7, 64bit, Firebird 2.5.3 SuperServer. Application is still 32 bit however. On Fri, Oct 10, 2014 at 1:53 PM, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On Fri, 10 Oct 201

Re: [firebird-support] Problem with "Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements"

2014-10-10 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On Fri, 10 Oct 2014 12:43:42 +0300, "Harriv har...@gmail.com [firebird-support]" wrote: > My application generates following errors occasionally: > > Error writing data to the connection. > > Unsuccessful execution caused by a system error that precludes successful > execution of subsequent stat

[firebird-support] Problem with "Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements"

2014-10-10 Thread Harriv har...@gmail.com [firebird-support]
My application generates following errors occasionally: Error writing data to the connection. Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements GDS Code: 335544727 Error Code: 407 And: GDS Code: 335544726 Error Code: 406 And sometimes

[firebird-support] Re: Simultaneous inserts / selects

2014-10-10 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
>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); MyStatement.Params[0].AsInteger:=;