[firebird-support] One SP that can return any kind of value?

2014-01-06 Thread venussoftop
Hi all I have a few SPs (see two examples below), I have a field that defines which field's value is to be returned but as the SP needs a RETURN specified to a type (that what I believe), I wrote separate SPs for each return type, but is it possible to have one SP and unknown RETURN value? Ple

Re: [firebird-support] practice information system

2014-01-06 Thread Helen Borrie
>> I expressed surprise that the software would have received government >> certification if it was set up wrongly from a security perspective. Only >> your supplier/developer can go through this with you and explain what (if >> anything) you need to do. At 06:53 p.m. 7/01/2014, Marc Hakman w

Re: [firebird-support] practice information system

2014-01-06 Thread Marc Hakman
Hi Helen, Am 07.01.2014 um 04:33 schrieb Helen Borrie : > At 10:25 a.m. 7/01/2014, Marc Hakman wrote: > > >> Hi Helen, >> >> if I understand you well, I have a steel armor archive cabinet on wheels >> without a rear wall. > > In the worst-case scenario, yes. But there is far from enough in

[firebird-support] Garbage collection / sweep not happening on super classic

2014-01-06 Thread rmcginty
Using 2.5.2 64 bit on Windows - Super Classic model. We have a large database around 20 gb that we have backup/restored successfully several times now via gbak. After the restore, everything is good, but over time, the transactions awaiting sweep starts to grow and never goes back to zero.

Re: [firebird-support] practice information system

2014-01-06 Thread Helen Borrie
At 10:25 a.m. 7/01/2014, Marc Hakman wrote: >Hi Helen, > >if I understand you well, I have a steel armor archive cabinet on wheels >without a rear wall. In the worst-case scenario, yes. But there is far from enough information to deduce exactly how your vendor has set up your installation.

Re: [firebird-support] How to protect database Firebird in client side

2014-01-06 Thread Saunders, Rich
On 2014-01-06 05:12, rudyhuan...@ymail.com wrote: > I installed on a client machine, the ERP.FDB file and the application. > > Now, I came to know that, one guy in the client place, stole the ERP.FDB and > tried several passwords and did not get it, so, he installed a FIREBIRD on > his com

Re: [firebird-support] practice information system

2014-01-06 Thread Marc Hakman
Hi Helen, if I understand you well, I have a steel armor archive cabinet on wheels without a rear wall. Approved by all security agencies (NSA etc) and several other criminal organizations. And, I even didn’t know. ;) I have contacted them, the supplier / developer (not vendor) and the certifi

[firebird-support] Update information for www.firebirdfaq.org/faq358/

2014-01-06 Thread Nuno B
Hello, The information on http://www.firebirdfaq.org/faq358/ does not apply for current versions. Can anyone tell me how to check the ICU versions of FB2.5.2 on Linux? Thank you.

[firebird-support] COLLATION UNICODE_CI_AI for CHARACTER SET UTF8 is not installed

2014-01-06 Thread Nuno B
Hello, I am using OS Ubuntu 13.10 and yesterday there was a ubuntu update. After this, my firebird gives this message: COLLATION UNICODE_CI_AI for CHARACTER SET UTF8 is not installed in I removed the firebird and reinstalled using the ubuntu ppa. It installed LI-V2.5.2.26540. But i keep having t

[firebird-support] How to protect database Firebird in client side

2014-01-06 Thread rudyhuang10
Hello Team Support, I installed on a client machine, the ERP.FDB file and the application. Now, I came to know that, one guy in the client place, stole the ERP.FDB and tried several passwords and did not get it, so, he installed a FIREBIRD on his computer and copied the ERP.FDB and opened i

Re: [firebird-support] Can a Firebird database be hosted on a hosting site?

2014-01-06 Thread Roberto
Cedriz, Since you know the data for to configurate your DB connection, your application must connect this way. At my company, at Brazil as you, we have Delphi application running this way. We use Delphi 2007, but the compiler version itself has to have nothing to avoid you to connect this way.

[firebird-support] RE: Full Cross Tab but unknown column headers

2014-01-06 Thread venussoftop
Yes I had the SET TERM as I was creating the SP SET TERM ^ ; CREATE PROCEDURE ACTUALIZAR_TABLA_PIVOT( tcTablaPivot VARCHAR( 28), lcInto1; EXECUTE STATEMENT lcActualizar; END END END^ SET TERM ; ^ Yet I ran into the error. What stumps me is that i

[firebird-support] RE: Full Cross Tab but unknown column headers

2014-01-06 Thread venussoftop
Yes, FlameRobin which I use needs the SET TERM^^ ; and SET TERM ; ^^ to make your statement work. That too has the same result now as the SP route you had suggested. I do see that we have come a full circle and have the need to provide fixed column names. But all is not lost, I think I ca