Den 2014-05-18 21:23 skrev Alan Shank li...@notoriousshankbrothers.com
[firebird-support] såhär:
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
russ...@smxi.com [firebird-support] skrev:
We have a large database that runs a full nbackup every night and an
hourly incremental backup. Is the full backup meant to clear the delta
file? this doesn't seem to get any smaller.
Also if I restore a gbak backup, what should I do with the delta
Hi,
I'm writing a utility that will need to do two things for each record in
an external table and for this purpose I use a for select ... do
construct in an execute block. I do it this way because external tables
can't be indexed and I will scan the entire external table anyway.
The two
Mark Rotteveel m...@lawinegevaar.nl [firebird-support] skrev:
On 13-2-2015 14:55, Kjell Rilbe kjell.ri...@datadia.se
[firebird-support] wrote:
I'm writing a utility that will need to do two things for each record in
an external table and for this purpose I use a for select ... do
=?utf-8?B?U3ZlaW4gRXJsaW5nIFR5c3bDpnI=?=
svein.erling.tysv...@kreftregisteret.no [firebird-support] skrev:
is possible to get week of the year within year?
I see that built in functions only support ISO-8601 (or i do not know
some parameter)
Actually, Karol, “week within year” is not the
Kjell Rilbe kjell.ri...@datadia.se [firebird-support] skrev:
Hi,
I'm writing a utility that will need to do two things for each record in
an external table and for this purpose I use a for select ... do
construct in an execute block. I do it this way because external tables
can't be indexed
'=?utf-8?B?bGl2aXVzbGl2aXVzQHBvY3p0YS5vbmV0LnBs?='
liviusliv...@poczta.onet.pl [firebird-support] skrev:
Why not merge?
Yes, indeed. Might have been worth a shot, but I suspect it would have
been no more than marginally better. Even merge does have to do an index
lookup for each record to
'=?utf-8?B?bGl2aXVzbGl2aXVzQHBvY3p0YS5vbmV0LnBs?='
liviusliv...@poczta.onet.pl [firebird-support] skrev:
Why not merge?
Yes, indeed. Might have been worth a shot, but I suspect it would have
been no more than marginally better. Even merge does have to do an index
lookup for each record to
Hi,
I'm trying to create an external table to import a list of id numbers
like this:
create table "ExLöpnr" external file 'D:\Löpnr.txt' (
"Löpnr" char(7) character set win1252,
"CRLF" char(2) character set win1252
);
But when I try to select from it, Firebird creates a new empty file