[firebird-support] Problems after FB3 upgrade

2016-09-05 Thread Tony Christiansen t...@adegroup.com.au [firebird-support]
Hi My client needed a server rebuild after a ransomware attack so I took the opportunity to upgrade from FB2.5 to FB3. My client application is Delphi using IBX components. Now they are experiencing repeated crashes with an array of exceptions - the most common being "Error writing data to

Re: [firebird-support] Substring and negative numbers

2016-09-05 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Hello Jeremy, Tuesday, September 6, 2016, 3:55:52 AM, you wrote: > This simple query: > SELECT left(c.addr_5, CHAR_LENGTH(c.addr_5)-3) as trimmed > FROM vecusts c > > Produces this error The list can't take attachments or embeds so you need to copy the error message in text. > > Pressing OK I

[firebird-support] RE: Substring and negative numbers

2016-09-05 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
Jeremy, > This simple query: > > SELECT left(c.addr_5, CHAR_LENGTH(c.addr_5)-3) as trimmed > FROM vecusts c > > > Produces this error No error was provided/included. Sean

[firebird-support] Substring and negative numbers

2016-09-05 Thread 'Jeremy Poppleton' jeremy.popple...@csy.co.uk [firebird-support]
This simple query: SELECT left(c.addr_5, CHAR_LENGTH(c.addr_5)-3) as trimmed FROM vecusts c Produces this error Pressing OK I then get correct values in the trimmed column. Can anyone assist or tell me what I am doing wrong? Many thanks [Non-text