On 27/09/2016 04:22, trsk...@yahoo.com [firebird-support] wrote:
Is it possible to insert image into FB database directly via sql
stament using isql or flamerobin?
Hi, yes it is possible with FlameRobin.
1. Insert a new record in the normal way (for example, right click on
the table, s
On 29/08/2016 00:28, 'Leyne, Sean' s...@broadviewsoftware.com
[firebird-support] wrote:
What’s performance like?
So far I have only tested with a very limited set of data (approx. 30
records) so haven't noticed any performance issues. FlameRobin reports
sub 0.01s times!
The maximum number o
Sean,
Have a look at my reply to your second question, about using CTE, that
will be part of your answer for this problem as well.
FYI: LIST() doesn't observe ORDER BY...
Thanks to your hint and example CTE I was able to get my query fully
working as follows. Sorry, there are a couple of na
Hi Sean,
Look at using Common Table Expressions (CTE)
Here is a rough sample based on your details
Thank you for the pointer to CTE and the example.
I have only looked at CTE briefly once before (for representing tree
structures), so it will take me some time to do some reading and to
dis
Hi Sean, thank you for your answer.
Some questions before I can give a suggestion:
> TEST_IDJFI_IDF_NAMEN1_NAMEN2_NAME MODECHARACTERIST
> ICPROPERTY
> 11FLOW_1NODE_ANODE_BMODE_1 HIGH FLOW> 10
litres /
> sec
> 11FLOW_1NODE_ANODE
I am modeling some abstract flow tests.
A 'flow instance' is defined as some sort of flow from Node A to Node B.
This is simply modeled with 3 tables as follows (I have left out the
alter table add constraints for brevity):
CREATE TABLE FLOW
(
ID integer NOT NULL PRIMARY KEY,
NAME varchar
On 30/03/2016 20:42, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> But it defines __GNUC__ that cause inttypes.h to be included and
> _INTPTR_T_DEFINED defined.
Thank you for your help, it got me away from a red herring.
I had missed that _WIN64 is defined by _cygwin.h, so
I have been having a problem with unexpected status returns from calls
to isc_dsql_prepare etc.
I think the problem is due to the definition of ISC_STATUS.
In ibase.h it is defined like this:
typedef intptr_t ISC_STATUS;
Where intptr_t is defined like this:
#if defined(_WIN64)
typedef __int64
On 12/09/2015 12:22, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
I just tried with a Firebird 2.5.4 installed in Program Files on Windows
10 and it works (I tried with command prompts with and without admin
privileges) with simply gsec -user sysdba -password masterkey
I have U
Dixon, many thanks for your help.
On 11/09/2015 20:21, 'E. D. Epperson Jr' dixonepper...@gmail.com
[firebird-support] wrote:
At work and don't have Windows 10 or FirebirdSql here, so I can't test
my theory. But I suspect its permissions related.
There is a new feature on the properties dialog
I am trying to install a Firebird server on a reasonably clean Windows
10 machine, but I am running into the gsec "cannot attach to password
database" issue.
Details are:
Edition: Windows 10 Pro (64-bit system, x64 based processor)
Firebird: SuperServer - both 32-bit and 64-bit versions attempt
Once again thank you. I am very sorry it has taken me so long to reply.
On 20/05/15 21:19, Andrea Raimondi andrea.raimo...@gmail.com
[firebird-support] wrote:
1) Re the separate database: nobody said you shouild do it from your
own. I'd do it in the client, once the original data has been ins
On 20/05/15 21:15, Alexandre Benson Smith ibl...@thorsoftware.com.br
[firebird-support] wrote:
In this way wouldn't the SP have the same problem that was mentioned
by Louis, namely that only the index from the first table in the
query would be used?
I did not read it in full details...
B
Thank you for your reply!
On 20/05/15 11:12, Andrea Raimondi andrea.raimo...@gmail.com
[firebird-support] wrote:
On the other hand, having all fields in all tables means you do not
have to do a join, which means you can have a richer and
more complete overview of something directly on your main
Thank you for your response.
On 20/05/15 11:25, Alan J Davies alan.dav...@aldis-systems.co.uk
[firebird-support] wrote:
Another way of doing what you want would be to use SPs instead of Views.
Then if you "select * from SP" and hide it as below, no-one can see what
you are doing with the data.
Thank you for this very useful response.
On 20/05/2015 08:17, 'Louis van Alphen' lo...@nucleo.co.za
[firebird-support] wrote:
Yes FB is a RDBMS and not OO DB. In a previous project I used
‘inheritance’ where I put common fields in a ‘base’ table and other
fields in a ‘derived’ table and then
I am creating a database that consists of 30 - 40 tables.
Each table stores a specific set of data which has a specific set of
attributes. There are also attributes common to all tables for example:
* UID (from generator)
* Name
* Description
* DateTime Created (audit field)
* DateTime Mo
On 23/01/2015 10:25, michael.vilhelm...@microcom.dk [firebird-support]
wrote:
Hi
I am looking for a function which are able to add values from a table
as records are fetched.
Something like this:
ValueCalculated value
11
23
36
410
515
The calculated value is just the sum of all prev
On 09/06/14 17:42, Olivier Mascia o...@integral.be [firebird-support] wrote:
> gfix -write async test.fdb -user sysdba -password secret
It, of course, has a tremendous impact on such tests. Though,
everybody should carefully consider wether the risks of data
corruption are acceptable (or not
On 09/06/14 19:11, Frank Schlottmann-Gödde fr...@schlottmann-goedde.de
[firebird-support] wrote:
> So the only mystery (for me!) remaining is why the UDF is so much faster
> when it is writing 4096 bytes at time with forced writes on?
Usually it is faster to let the server do the dirty work, bu
On 09/06/14 09:25, Olivier Mascia o...@tipgroup.com [firebird-support] wrote:
I am seeing 45 seconds for a 13Mb file using C++ / IBPP and 48
seconds using PHP.
Exactly the same code, database structure and hardware on Windows
inserts a 13Mb BLOB in just 2.4 seconds!
That just means the c
On 07/06/14 14:42, Frank Schlottmann-Gödde fr...@schlottmann-goedde.de
[firebird-support] wrote:
This is probably the cause of the exception:
> declare external function f_insertblob cstring (20), blob returns int by
> value entry_point 'insertblob' module_name 'test_udf.so';
should be
DECLA
On 06/06/14 11:04, Frank Schlottmann-Gödde fr...@schlottmann-goedde.de
[firebird-support] wrote:
Ok, this is what I get for a 13MB file on an Intel NUC (Celeron),
database and home are on an USB Drive, so no real good hardware.
SQL> set stat;
SQL> set time;
SQL> select b_loadfromfile('/home/
Yes, of course, but I never felt the need to time the operations, we
are using a udf s.th. like:
void EXPORT fn_b_load ( char* s , BLOB b )
{
unsigned char *buffer;
if ( b->blob_handle )
{
int buffsize = 4096;
FILE *file;
unsigned char *fname = intern_recode(s);
file= fopen ( fname, "rb" );
if
On 02/06/2014 12:06, Frank Schlottmann-Gödde fr...@schlottmann-goedde.de
[firebird-support] wrote:
> I am sorry to bump this, but has anyone else got experience of using
> blobs on Linux?
Yes, of course, but I never felt the need to time the operations, we
are using a udf ... to load documents
I am sorry to bump this, but has anyone else got experience of using
blobs on Linux?
I am using Firebird embedded (2.5.2) on Linux (Ubuntu 14.04) via IBPP
with a completely default firebird.conf.
My hardware is a Dell Optiplex 755, Intel Core 2 Duo @ 2.33GHz with
4Gb RAM and a 2Tb Western Di
I am using Firebird embedded (2.5.2) on Linux (Ubuntu 14.04) via IBPP with a
completely default firebird.conf.
My hardware is a Dell Optiplex 755, Intel Core 2 Duo @ 2.33GHz with 4Gb RAM
and a 2Tb Western Digital WD20EARX-32P hard disk.
When I use IBPP to write a blob (actually a music MP
> 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.
http://stackoverflow.com/questions/8213/generate-insert-sql-statemen
28 matches
Mail list logo
