[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);

[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

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] firebird-support@yahoogroups.com wrote: My application generates following errors occasionally: Error writing data to the connection. Unsuccessful execution caused by a system error that precludes successful

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] firebird-support@yahoogroups.com

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] 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 LSSBcfs

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] firebird-support@yahoogroups.com 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