Re: [firebird-support] Re: Performance of Stored Procedures versus execute blocks

2014-05-22 Thread Steve Wiser st...@specializedbusinesssoftware.com [firebird-support]
On Thu, May 22, 2014 at 1:33 AM, Lafras Henning laf...@xietel.com[firebird-support] firebird-support@yahoogroups.com wrote: Hi Steve, Do you think the performance gains were mostly due to the elimination of the sub procedure, or mostly due the pure speed of the C functions? During testing

Re: [firebird-support] Updating Firebird

2014-05-22 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Thank you. Em 20/05/2014 15:32, 'H. S.' hassansha...@yahoo.com [firebird-support] escreveu: Hi 1 backup your database 2 uninstall old version 3 install last version 4 restor your database Sent from Yahoo! Mail on Android

Re: [firebird-support] Updating Firebird

2014-05-22 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Thank you for the answers. What libraries should I update? Hugo Em 20/05/2014 16:45, Helen Borrie hele...@iinet.net.au [firebird-support] escreveu: At 06:26 a.m. 21/05/2014, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: Hello. I want to update Firebird from 2.5.2.26539 to

[firebird-support] Table/field Alias - relname in SQLDA

2014-05-22 Thread acgomes2...@yahoo.com.br [firebird-support]
I have the SQL: select CADPRO.CLIENTE_PRO, CADPRO.FORNECEDOR_PRO, CADGRU.NOME_GRU, SUBGRUPO.NOME_SUBGRU, COLECAO.NOME_COL, MARCA.DESCRICAO_MARCA, NCM.NCM_NCM, NCM.EX_NCM, NCM.DESCRICAO_NCM,

[firebird-support] loading data from a .csv file?

2014-05-22 Thread Alan Shank li...@notoriousshankbrothers.com [firebird-support]
Is there some way to load data into a table in Firebird, like LOAD DATA INFILE... in Mysql? I have comma-delimited files from Mysql that I want to load into Firebird tables. I have Firebird2.5-super on Ubuntu 14.04, 64-bit. Thanks, Alan Shank Woodland, CA

Re: [firebird-support] Updating Firebird

2014-05-22 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
At 02:21 a.m. 23/05/2014, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: Thank you for the answers. Don't forget to update the client libraries. What libraries should I update? fbclient.dll on your Windows clients - the 64-bit version for your 64-bit apps, the 32-bit version for your

Re: [firebird-support] loading data from a .csv file?

2014-05-22 Thread Lester Caine les...@lsces.co.uk [firebird-support]
I process mine through php ;) Although I have dropped mysql data as simple insert data. It would perhaps be nice as an option in flamerobin Sent from my android device so the quoting is crap! -Original Message- From: Alan Shank li...@notoriousshankbrothers.com [firebird-support]

Re: [firebird-support] loading data from a .csv file?

2014-05-22 Thread miker...@gmail.com [firebird-support]
Is there some way to load data into a table in Firebird, like LOAD DATA INFILE... in Mysql? I have comma-delimited files from Mysql that I want to load into Firebird tables. There are some very useful tips here.

Re: [firebird-support] Updating Firebird

2014-05-22 Thread 'H. S.' hassansha...@yahoo.com [firebird-support]
Hi Nothing. Easy you must uninstall old version and when install new version.it is automaticly install last libraries. But if you use udf lib must be copy that into udf folder in firebird directory. Sent from Yahoo! Mail on Android

Re: [firebird-support] Table/field Alias - relname in SQLDA

2014-05-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 22-5-2014 19:15, acgomes2...@yahoo.com.br [firebird-support] wrote: I have the SQL: select CADPRO.CLIENTE_PRO, CADPRO.FORNECEDOR_PRO, ... FORNECEDOR.NOME_CLI NOME_FORNECEDOR, CLIENTE.NOME_CLINOME_CLIENTE, .. from CADPRO inner join CADCLI as FORNECEDOR on

Re: [firebird-support] loading data from a .csv file?

2014-05-22 Thread Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]
To import csv, I usually use B_LOADFROMFILE from rfunc UDF library (http://rfunc.sourceforge.net/) with some recursive query to split lines and fields. If you need hints on this, I'll provide an example. If you can modify the format of the data to import, you might consider external tables.

[firebird-support] port requirements for Firebird Services API - IBAnalyst

2014-05-22 Thread Office Manager office...@href.com [firebird-support]
Hi Firebird users and experts... Which ports need to be open for the Firebird Services API and which settings in firebird.conf control them? In general, I can connect to the database just fine. I wanted to follow up on the recent article (

Re: [firebird-support] port requirements for Firebird Services API - IBAnalyst

2014-05-22 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Ann, Unfortunately, we did not receive your email to supp...@ib-aid.com or to ibanal...@ib-aid.com. Services API works through the same port (3050 by default), as all connections. Regarding IBAnalyst connection - most likely you don't have correct version of client library in path, and

RES: [firebird-support] Table/field Alias - relname in SQLDA

2014-05-22 Thread Antônio Cristóvão Gomes acgomes2...@yahoo.com.br [firebird-support]
then why not include Alias ​​Table in XSQLVAR? this function should be used to retrieve the table alias? function isc_dsql_sql_info(user_status: PISCStatus; stmt_handle: PIscStmtHandle; item_length: Smallint; items: PISCSChar; buffer_length: Smallint; buffer: PISCSChar):

Re: [firebird-support] port requirements for Firebird Services API - IBAnalyst

2014-05-22 Thread Office Manager office...@href.com [firebird-support]
Hi Alexey, Thank you for the quick reply. I copied that support@ address from http://ib-aid.com/en/articles/ibanalyst-how-to-get-statistics-from-interbase-firebird-database-in-right-way/ at the very bottom. I just tried putting fbclient.dll (32-bit) into the same directory as the