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,
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
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
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
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_A
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
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
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
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
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...
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
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
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 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
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
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
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, but
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
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
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
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
24 matches
Mail list logo
