RE: [firebird-support] Escaping an ampersand in a select

2014-07-07 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
>I am using Delphi XE6 and Firedac and my query is similar to  > >SELECT A.NAME, 'HTTP://WWW.XYZ.COM?URN=' || A.URN || '&ACTION=' || >A.ACTIONFIELD >FROM MYTABLE > >the problem I have is that the returned result doesn't include the &ACTION so >it looks like HTTP://WWW.XYZ.COM?URN=1234=myaction >

Re: [firebird-support] Escaping an ampersand in a select

2014-07-07 Thread 'H. S.' hassansha...@yahoo.com [firebird-support]
Hi Use this one '"&"action' Sent from Yahoo! Mail on Android

[firebird-support] Re: TempCacheLimit in Super Classic

2014-07-07 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
07.07.2014 21:14, Thomas Steinmaurer wrote: >> I would like to know if the TempCacheLimit parameter in SuperClassic is >> like Classic or like SuperServer? So if it's per client connection or >> it's for server process? > > As in Classic, thus per connection. Nope, it's per server process. Dmit

Re: [firebird-support] TempCacheLimit in Super Classic

2014-07-07 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
> I would like to know if the TempCacheLimit parameter in SuperClassic is > like Classic or like SuperServer? So if it's per client connection or > it's for server process? As in Classic, thus per connection. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and S

Re: [firebird-support] Escaping an ampersand in a select

2014-07-07 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 7-7-2014 19:02, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 7-7-2014 17:54, russ...@smxi.com [firebird-support] wrote: >> I am using Delphi XE6 and Firedac and my query is similar to >> >> SELECT A.NAME, 'HTTP://WWW.XYZ.COM?URN=' || A.URN || '&ACTION=' || >> A.ACTIONFIELD

Re: [firebird-support] Escaping an ampersand in a select

2014-07-07 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 7-7-2014 17:54, russ...@smxi.com [firebird-support] wrote: > I am using Delphi XE6 and Firedac and my query is similar to > > SELECT A.NAME, 'HTTP://WWW.XYZ.COM?URN=' || A.URN || '&ACTION=' || > A.ACTIONFIELD > FROM MYTABLE > > the problem I have is that the returned result doesn't include the >

Re: [firebird-support] TempCacheLimit in Super Classic

2014-07-07 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, It's like Classic. Check out optimized configuration files for Firebird here: http://ib-aid.com/en/optimized-firebird-configuration/ Regards, Alexey Kovyazin IBSurgeon Hi, I would like to know if the TempCacheLimit parameter in SuperClassic is like Classic or like SuperServer? So if it's

[firebird-support] TempCacheLimit in Super Classic

2014-07-07 Thread Jaume Llunell Gómez jaumellun...@gmail.com [firebird-support]
Hi, I would like to know if the TempCacheLimit parameter in SuperClassic is like Classic or like SuperServer? So if it's per client connection or it's for server process? And if it's like SuperServer, is there any problem in setting this value to 1 GB if i have this memory free or should it be an

[firebird-support] Escaping an ampersand in a select

2014-07-07 Thread russ...@smxi.com [firebird-support]
I am using Delphi XE6 and Firedac and my query is similar to SELECT A.NAME, 'HTTP://WWW.XYZ.COM?URN=' || A.URN || '&ACTION=' || A.ACTIONFIELD FROM MYTABLE the problem I have is that the returned result doesn't include the &ACTION so it looks like HTTP://WWW.XYZ.COM?URN=1234=myaction

Re: [firebird-support] remove constraint

2014-07-07 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
Hello Wolfgang, ALTER TABLE DROP CONSTRAINT INTEG_485 That should do the trick. Or find the constraint and simply click "Drop" in Database Workbench. ;) With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL

Re: [firebird-support] remove constraint

2014-07-07 Thread Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]
Hi Wolfgang, I think, you should alter table and alter the field definition to not required the check any more. Regards, Thomas Am 07.07.2014 08:22, schrieb Wolfgang Kluge wkl...@kb-labuan.com [firebird-support]: > > > Good afternoon. > > Can anypme give me a hint how I can by code remove a