Evening Kevin,
Sadly, not-text parts of your message were removed, so we can't see "what you
got". Sorry.
Cheers,
Norm.
On 1 January 2020 19:23:06 GMT+00:00, "Kevin Stanton
kevin.stan...@rdb-solutions.com [firebird-support]"
wrote:
>Greetings!
>
>I’m hoping someone can help me out here. FB
I haven't set up Firebird on a raspberry pi yet, but I will one day.
I would use a powered usb drive or SSD rather than the SD card just because I'd
want the data protected as much as possible.
It's not as bad as it used to be, admittedly, but SD cards still "wear" and
definitely corrupt eventu
I've been doing that for years! I have, for example, an alias 'employee' and
another 'employee.fdb' - if I remember correctly, it was originally used as an
example when the aliases file was installed - many years ago. I just followed
suit.
Cheers,
Norm.
--
Sent from my Android device with K-9
etting sweep interval to zero disables this automatic sweep. However,
are you aware that when a transaction visits a table, it clears out
'garbage' left behind by other previous transactions?
Also, when you backup the database, your garbage is/can be collected too.
HTH
Cheer
If I may be permitted to stick my oar in here
Oracle databases allow timestamp with timezone data types, as well as simple
timezone data types. Every database I've come across in my day job, I'm an
Oracle contract DBA, uses either date (aka date and time) or simple timezone
data types.
I would suggest that the best way to prevent anyone getting hold of your
database and opening it with a separate security database is to have good
security & physical protection on your server, limited access to the server
room (if appropriate) and so on. Normal security precautions in other wor
Maybe a silly question, but is there a firewall that needs a port opening,
between your host server for the database, and the clients?
Cheers,
Norm.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
PS. http://www.firebirdfaq.org/faq59/ might also apply.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG
Company Number: 05132767
n32 on Windows 7. The following
> command line is used for taking the backup.
>
> gbak -t -v -b -user SYSDBA -password masterkey accounts.fdb
J:\accounts.fbk
>
> 'J:\' is flash drive here.
Was your backup to the flash drive successful? Or did it run out of space?
ee | grep -i "next transaction"
Next transaction785
The above fbstat is what gstat is called in Linux Mint. Your
installation might well still be called gstat.
HTH
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
/reference_manuals/user_manuals/Firebird-gsec.pdf
These manuals are in English.
HTH
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG
Company Number: 05132767
read from the cache.
I'd say that your slow response is down to cache filling, physical reads
and possibly, a bit of garbage collection too.
HTH
Cheers,
Norm.
PS. If I got any of the above wrong, I shall be corrected! ;-)
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG
Company Number: 05132767
re the
database is located and run fbstat -h database_name from there.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG
Company Number: 05132767
nd
what is it on the server where you are trying to create a test database.
Thanks.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG
Company Number: 05132767
It seems as if you are attempting to downgrade a database - at least,
that's what my Google-fu turns up - but I don't have a very high
Google-fu rating! ;-)
There's a tracker on this very matter at
http://tracker.firebirdsql.org/browse/CORE-2949.
Cheers,
Norm.
--
Norman D
new names, after being backed up successfully, are not accepted by older
>FB versions due to their system triggers expecting the name in the old
>format (SQL$tablename).
>
>I don't know about any solution other than migrating via a script.
Might be helpful?
Cheers,
Norm.
--
I use PhpMyadmin to do it. I
don't know about doing a backup via cron.
Does this help?
http://www.noupe.com/how-tos/10-ways-to-automatically-manually-backup-mysql-database.html
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pu
it. I have to set all my mysql databases up with
localhost.* and hubble.* (my server name) in order to get any login to
work. Makes no sense at all. Weird.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Ki
ormat at http://it-ebooks.info/book/153/.
HTH
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
e that the
next value generated will be 667:
set generator seq_pk_whatever to 666;
HTH
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
Ordered the Firebird Book - 2nd Edition 3 volume set on Thursday,
delivered yesterday.
Helen, it's huge! And I can imagine it would be a lot bigger if they had
used a normal sized font. I need stronger reading glasses now! ;-)
So far, I thoroughly recommend it.
Cheers,
Norm
--
N
On 30/05/13 20:53, Norman Dunbar wrote:
>> Norm, this isn't correct. Aliases.conf doesn't belong in a client-only
>> install at all. The paths in aliases.conf are strictly file system paths
>> that are local to the Firebird host machine. No hostnames in aliases.c
nfortunately I changed Linux distros a while back and haven't used it
since. I sit corrected though. Apologies to Walter for misleading
information. :-(
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
ons (or client software) not to work properly, and you
have to reinstall it into a path that doesn't have the parenthesis (and
sometimes spaces too cause problems).
HTH
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
allation? And have you installed the corresponding "bit" size of
Firebird?
Thanks.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
e never done one!) will need to have the server
name as well:
employee = win7_server:employee
employee.fdb = win7_server:employee
In this case, your local employee aliases connect to the server and use
the server's employee alias. The above (colon separator) assumes TCP
protocol.
Cheers,
Norm
on.co.uk button on the we site, perhaps.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
.
>
> And the result of query contains only - 3, 4, 6 and 9 type of page.
>
> How can I get the real numbers??
>
> Best regards, Tomas
Unfortunately, you can't! This thread might help explain.
http://sourceforge.net/mailarchive/message.php?msg_id=27114737
Cheers,
Norm
ing them - but that deepens on
whether or not the data they created needs to be retained after they
have left the company - business rules will dictate this).
HTH
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
anuals/user_manuals/html/gbak-recipies.html#gbak-recipies-remote-ssh
HTH.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
ould
go in to the soundex table looking for the J500 and from that, pull out
the artist PK id (1) and joing on that to the Atrist table to get my
match/matches.
Hope this makes sense.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
g/file/documentation/reference_manuals/reference_material/Firebird-Internals.pdf
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
e! She
may be right! ;-)
Anyway, please be aware the the above document is a work in (slow)
progress, and is not yet complete.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
usage. Something like 90% is static so I'm hoping this will
> give me some improved performance on queries against the static data.
Basically, yes. But the amount of space left free is subject to what Ann
said when she told me off originally, in this thread! ;-)
Cheers,
Norm.
--
ng (or accumulating) could become very large - see above.
The Italian Lira (as it was) for example, could soon fill a CURRENCY
type. The Euro, might take a bit longer! And a DECIMAL is limited to 18
digits.
Have fun.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
T
On 02/05/13 11:07, Norman Dunbar wrote:
> Start FlameRobin and comment to the database with the appropriate user.
Which should, of corse, read:
Start FlameRobin and connect to the database with the appropriate user.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe Ho
TIONs for that client.
You should note that the primary key of the BALANCE table is actually
the primary key of the CLIENT table. This is not a problem. The
client_id is unique and allows the balance for that client to be easily
found, once you have found the client's id.
HTH
cleared, then a
trigger would update the BALANCE table for that client.
You might have a PENDING_PAYMENTS_BALANCE on the BALANCE table to total
up the payments that have been made, but have not yet been cleared for
that particular client. It all depends on what your requirements are.
HTH
C
27;ve added a note that the use of "gfix -use full | reserve
database_name" cane be used to undo the flag in the header (or reset it)
according to the needs of the particular database.
Phew!
Sorry for the foul up.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered
t page of the database.
Thanks for that, I'll do some more updating.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
n 1.10
of the manual. My cache hasn't cleared yet, and I still get 1.9.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
On 01/05/13 15:53, Norman Dunbar wrote:
> I'll reword the manual. ASAP.
The gbak manual has been updated to enhance the description of the
-use_all_space switch and should be available when your cache is
refreshed or expires.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consult
ach page for future updates.
I'll reword the manual. ASAP.
After the restore is completed, and as far as I am aware, the normal
80-20% usage continues on new pages.
HTH
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Puds
Ahem ...
On 11/04/13 13:26, Norman Dunbar wrote:
> I've updated the gbak manual to reflect the use of -g[arbage_collect]
> and -se[rvice] to speed up backups and restores, by adding a couple of
> sections explaing their use.
Obviously, I didn't include -g[arbage_collect] in
used instead of either '-replace' or '-recreate
overwrite' - which no-one had noticed!
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
pdf version.
If you get an older version that document 0.5 then the cache needs to be
flushed.
It's still not fully complete, but it's a lot further down the line than
before.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richar
On 09/04/13 14:50, Norman Dunbar wrote:
> PS. I'll update the docs to clarify this.
I've updated the docs for gfix to reflect the fact that prior to 2.1RC1
error exits were zero, regardless, but since 2.1RC1, success returns
zero while errors return 1.
A new pdf is avail
On 09/04/13 14:35, Norman Dunbar wrote:
> I'll check and get back tou you to see if there's anything in the
> release notes from 2.0 onwards that may have changed this.
I've checked all the release notes and it seems the error reporting
problem was raised as CORE-1548 on t
ersion 2, are zero".
I haven't tested gfix 2.5 yet, but at least as far as 2.0 it's almost
always zero, even in the event of a problem.
I'll check and get back tou you to see if there's anything in the
release notes from 2.0 onwards that may have changed this.
On 17/01/13 08:59, Norman Dunbar wrote:
> I'm doing some more documentation work on the isql manual. The current
> version mentions a copy command in isql which "copies a table structure
> to another table, or database".
Answering self!
After a brief look at the is
rd, after all, you wouldn't necessarily want to define those
ever so slightly insecure variables just to use a copy command? I wouldn't!
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdo
y gut feeling was right, it is shelling out. This is a nuisance then,
as it means that people on systems where the isql app has been renamed,
cannot use the copy command. H.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
bird 2.5"
Firebird/linux AMD64 (remote server), version "LI-V2.5.1.26351 Firebird
2.5/tcp (hubble)/P12"
Firebird/linux AMD64 (remote interface), version "LI-V2.5.1.26351
Firebird 2.5/tcp (hubble)/P12"
on disk structure version 11.2
Cheers,
Norm.
--
Norman Dunbar
Dunbar
(or Windows) is not
supported. From work, I know that there are a few differences between
Windows 2000 and 2008 which affects some of the products I have to use
(Oracle for example).
HTH
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardsh
t though, if the output file exists, it will be appended to, not
overwritten.
HTH
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
ding "set numwidth a 5" command. I
eventually remembered that that is in Oracle - set numwidth 5.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
Sorry typo,
Set width LFN 10;
select long_field_name LFN from test; // => display 10 chars
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
On 08/06/12 10:29, ehaerim wrote:
> Is it also possible the latter case print 10 chars only?
Yes:
Set width LFN 10;
select long_field_name LFN from test; // => display 30 char
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardsha
On 01/06/12 16:38, Michael Ludwig wrote:
> Follow-up on a recent thread and some pointers to GBAK docs:
>
> Re: Copy of the current db not updating generators
> http://tech.groups.yahoo.com/group/firebird-support/message/118211
>
> Norman Dunbar schrieb am 31.05.2012 um 17:04 (+
I'll take a look and fix as necessary, thanks again.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
rge database at least.
There will be other generator pages if there are more than 508 generators.
The above is on a 4K database page size.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28
k your other person to take a look? Hopefully,
preventing any future problems.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
'm just thinking out loud here!)
Did you find anything of use on the thread I pointed you at in my
original reply?
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
7;t arrived yet though. Typical!
Thanks for putting me right anyway.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
.yahoo.com/group/firebird-support/message/91656 which
discusses this error message - although the thread title is for a
different query, someone hijacked the original thread.
HTH
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
key, field 1)
ID_NMBR INTEGER (primary key, field 2)
I assume that there are other columns not mentioned.
Now it's far easier to write a statement to extract wrongly stored
names. Assuming it was needed of course!
As Ann often says, good luck!
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consul
On 24/04/12 09:29, Kjell Rilbe wrote:
> SQL Server UNIQUE allows only a single null.
Interesting. That's one for the "Learn something new every day"
department! It does tend to imply that SQL Server is treating NULL (a
lack of a value) as a value in this case?
Cheers,
Morning Ann,
On 21/04/12 18:05, Ann Harrison wrote:
> Firebird is moving away from active
> system tables (which is good and overdue)
Could I ask you what you mean by the above please? Thanks.
Or, just point me at some docs of course!
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultan
gsec will work.
4. Do (3) above, but add it to your .bashrc file and ehn you next login,
gsec will work.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
rflow occurred during data type conversion.
You are comparing a number with a string. The database engine tried to
convert the string to a number, it failed. because of the commas. Always
compare like with like.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
t - prepare the statements as few times as
possible (ie once) and use it as many times as possible, and you save
resources, improve performance and make the user's life a whole lot better.
Agree to disagree?
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
eeds in the
driving table by the time it hits the nested loop?
> Good luck (and we all need it)
Indeed we do. There's no right way and plenty of wrong ways to do
something in databases. I'm just a DBA not a designer. I can see how
difficult it is for the designers.
Cheers,
Norm.
-
nd uses these to pick the best execution plan.
Granted the stats have to be kept "reasonably" up to date or performance
suffers, but it's a good way of avoiding dynamic scans to check cardinality?
Just a thought.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registe
the same statement hundreds of times, even though they should
do it only once.
See
http://qdosmsq.dunbar-it.co.uk/blog/2009/02/it-must-be-efficient-im-using-bind-variables/
for details. :-)
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Ric
it in between. Any index updates are applied from REDO after
the initial build has finished.
Anyway, I think we are staying too far from the topic now, best we
quieten down (or go private) before Helen sees what we are up to! ;-)
Cheers,
Norm.
--
Norman Dunbar
Dunbar I
verything that the database is designed to do efficiently and at great
speed using the resources of a big server is done at the client using a
small Java application - and screws the network while it is pulling all
that data over to "join" in the application.
Just my £0.02.
Cheers
ndably. Please
feel free to "give me grief" anytime.
> With respect,
And indeed, I return your respect.
> Michael
Cheers,
Norm.
PS. Hope you got your roles sorted out.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
Wes
lots more documentation, but never enough, at
http://www.firebirdsql.org/en/reference-manuals/ if you need anything else.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
must put your validation and constrai9nts checking as close to the
data, where it belongs, that means you do it in the database. You can
still do checks and similar validation in the application - for ease of
user use, but the main location has to be protecting the data.
HTH
Cheers,
Norm.
Note to self: next time, be brief!
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
d's read consistency doesn't seem to do this, you get to see all
the rows in the table even the ones being inserted by the command.
Best avoided!
By the way, I've not tried this in Firebird 2.5 as I don't want to have
to kill off my session to stop it running away!
HTH
s/my_employee.fdb
The result will be the same either way.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
ot;/dev/sda1" as the Filesystem, then it's on your NTFS file
system.
HTH
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
Afternoon Olaf,
> one qestion. How can I save pictures into the firebird database? It is
> possible to create a windows-file (*.jpg) with a stored procedure into the
> filesystem?
This link might help a little, maybe. http://www.firebirdfaq.org/faq122/
Cheers,
Norm.
--
Norman Dunb
ing the copy, and moving it to the original location
and filename(s) - no editing of aliases.conf is required.
HTH
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
connections.
The links I gave in my previous reply might give you a clue as to where
to look for the setting.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
OS's, modify contents of /proc/sys/net/ipv4
# /tcp_keepalive_*. On Windows, follow instrutions of this article:
# http://support.microsoft.com/default.aspx?kbid=140325
As Ann would say, good luck!
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/fbcache.html
There's a downloadable pdf at:
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/Firebird-Cache.pdf
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Regist
manuals/user_manuals/html/nbackup.html
and also at
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/Firebird-nbackup.pdf.
There may be something in the above that answers your query.
HTH
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered add
ntation/reference_manuals/reference_material/html/fbint-page-5.html
might help explain the difficulties - think Run Length Encoding and
NULLs etc.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
Oracle, it is not necessarily true that a group by implies the
same order by. It used to - up to version 9i if I remember correctly -
but not any longer.
Just an observation.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pu
a warehouse systems do advocate de-normalisation, but that's
different from normal running of an RDBMS. (Plus, denormalisation has
been proven to reduce response times.)
Of course, I might have misunderstood your original posting. In which
case, apologies.
Cheers,
Norm.
--
Norman Dunba
s is a huge amount to have
simply been "lucky" that it hasn't happened before. Sorry. :-(
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
blespace " to the
create table statement, and it will be created in the correct place.
I have no idea how easy/hard/sane it would be to add this sort of thing
to Firebird of course! ;-)
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richa
94 matches
Mail list logo