Re: [firebird-support] Re: Create or Alter Procedure: Token Unknown doing a Replace...

2016-05-02 Thread diego schumacher diego_schumac...@yahoo.com.ar [firebird-support]
const   ReplaceFmt = '  S = Replace(S, %s, %s);'; begin   [...]    //    Script1.Script.Add('-- Remove Double Letters ');    Script1.Script.Add(Format(ReplaceFmt, [QuotedStr('BB'), QuotedStr('B')]));   Script1.Script.Add(Format(ReplaceFmt, [QuotedStr('CC'), QuotedStr('C')]));  

Re: [firebird-support] Setting a generator

2016-05-02 Thread liviusliv...@poczta.onet.pl [firebird-support]
Hi, i do not understand what you try to do (why you need to set value of get max in procedure) but: gen_id(generator_name, –gen_id(generator_name, 0)+your_get_max_value) regards, Karol Bieniaszewski From: mailto:firebird-support@yahoogroups.com Sent: Monday, May 2, 2016 6:40 PM To:

Re: [firebird-support] Re: Create or Alter Procedure: Token Unknown doing a Replace...

2016-05-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.05.2016 19:06, ho...@agencybusys.com [firebird-support] wrote: > *Error Message:* > Project ABS3.exe raised exception class EIBCError with message ' > Dynamic SQL Error > SQL error code = -104 > Token unknown - line 57, column 19 > BB'. You most likely used a double quote instead of two

[firebird-support] Re: Create or Alter Procedure: Token Unknown doing a Replace...

2016-05-02 Thread ho...@agencybusys.com [firebird-support]
CORRECTION: Error Message: Project ABS3.exe raised exception class EIBCError with message ' Dynamic SQL Error SQL error code = -104 Token unknown - line 57, column 19 BB'.

Re: [firebird-support] Firebird 3.0 and GDS32.DLL

2016-05-02 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
Hello Michael, > Hi > > I have succesfully installed Firebird 3.0 on my home computer. > I can use our program. We have 3 main programs. Two are using IBX component > and > the last uses IBObjects. > On my local mashine it runs smoothly. > > I have then installed Firebird 3.0 alongside

[firebird-support] Firebird 3.0 and GDS32.DLL

2016-05-02 Thread michael.vilhelm...@microcom.dk [firebird-support]
Hi I have succesfully installed Firebird 3.0 on my home computer. I can use our program. We have 3 main programs. Two are using IBX component and the last uses IBObjects. On my local mashine it runs smoothly. I have then installed Firebird 3.0 alongside Firebird 2.5 and 2.1 on a server. Using

Re: [firebird-support] SELECT WITH LOCK, WAIT transaction, deadlock

2016-05-02 Thread Gabor Boros gaborbo...@yahoo.com [firebird-support]
Hi All, I would like to thank everyone who helped me on this subject. Dmitry committed the fix on Saturday. No more deadlock for me! :-) http://tracker.firebirdsql.org/browse/CORE-5222 https://github.com/FirebirdSQL/firebird/commit/5f0842ba2c51b4bfb2e2c4191e4aa742ad5cb470 Gabor