firebird.conf?
Also, make sure Firebird user has rwx privileges on the directory.
Regards,
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
the latest snapshot build of FlameRobin. Those are as
stable as stable release, and have some important bug fixes.
If none of this works, please ask further questions on flamerobin-devel
mailing list.
Regards,
--
Milan Babuskov
==
The easiest way to import XML, CSV
hrefofficemanager wrote:
Costs range from $75 to $400+ per month, plus setup fees.
...in the USA.
If you're in Europe, you can get a pretty decent server from Hetzner
from 20 EUR upwards with 10TB of free traffic per month.
Regards,
--
Milan Babuskov
, column 22
FIELD1
Looks like Dialect1 problem. FBCopy only supports Dialect 3 databases.
You can use gfix to switch the dialect to 3 and then do the copy:
http://www.firebirdsql.org/manual/gfix-dialect.html
Regards,
--
Milan Babuskov
==
The easiest way to import
e-mail.
Please let's continue further flamerobin-related discussion on FR
mailing list (I'm cross-posting there as well).
Regards,
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
and select Generate code, and
then Audit log trigger for table
HTH
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
and then Create change trigger for table.
It will display a dialog to select the desired columns and it will
generate to complete trigger code.
HTH
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
the new table to the old name?
The server is FB 2.0.3; I have IBExpert and FlameRobin available.
All explained here:
http://firebirdfaq.org/faq380
Regards,
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http
to compare, leave only those you want.
Next run it with X parameter and supply the text file as input.
More details in FBCopy manual:
http://fbexport.sourceforge.net/fbcopy-manual.html#compare
HTH
--
Milan Babuskov
==
The easiest way to import XML, CSV
of 2 ways to do it ;)
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
. And then I copied the data using FBCopy tool.
To prepare a clean database, you can use something like isql -x to
dump the database schema from 2.5, and then run that script on an empty
database with Firebird 2.1.
Good luck.
--
Milan Babuskov
==
The easiest way
= NULL;
...before the SELECT query.
HTH
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
something like this:
?php
$result= ibase_query(SELECT blob_value FROM table);
$data = ibase_fetch_object($result);
$blob_data = ibase_blob_info($data-BLOB_VALUE);
$blob_hndl = ibase_blob_open($data-BLOB_VALUE);
echo nl2br(ibase_blob_get($blob_hndl, $blob_data[0]));
--
Milan Babuskov
arda wrote:
Maybe the database can store the versions of stored procedures transparently?
AFAICT, this already works that way, at least with Firebird Classic 2.1
on Linux which I mainly use in production.
Which version of Firebird are you using?
--
Milan Babuskov
of the number of developers, as they do
download a couple of copies and that's about it.
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
to restore using 2.5. Does
the restore work on 2.1?
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
solution for that.
Regards,
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
be bad or not?
what should i do?
Any foreign keys, triggers, secondary indexes or check constraints
involving computed fields?
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
Fulvio Senore wrote:
Do you think that this a reasonable solution, or are there better ones?
How about this:
Create ON CONNECT database trigger and read number of connected users
from MON$ATTACHMENTS. If it's larger than what you want, throw an exception.
--
Milan Babuskov
/faq161/
HTH
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
the directory as well at that
point?
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
with --parents switch. Then set up privileges with
chown and chmod.
b) write small Linux UDF that creates directories, register it in some
database (employee.fdb for example) and call it from code:
db.Query(select createDir(/path/on/linux) from rdb$database);
HTH
--
Milan Babuskov
IBPP library which
has it's own logic of finding firebird client library (it searches the
Registry, current directory, program files, etc., you can look into
source code if you're really interested)
--
Milan Babuskov
==
The easiest way to import XML, CSV
and results of all
intermediate operations are integers. So:
integer * integer = ok
integer + integer = ok
integer - integer = ok
integer / integer = could present problems
Since _counting_ is only addition, it is safe to do even with double.
--
Milan Babuskov
Olaf Kluge wrote:
How can I realize:
Fiels_name = 'COLUMNNAME''?
Fiels_name = ''COLUMNNAME'
I have test all combinations from one ' to four.
How about five ' ? ;)
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird
.
Seems that Linux isn't much better in this respect, eh?!
Different religion - different kind of hell ;)
Regards,
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
hamacker wrote:
There is a way to format a datetime inside a query ?
You can find some interesting ideas here, ranging from UDFs to SUBSTRING
tricks:
http://www.firebirdfaq.org/faq314
HTH
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual
than interactively, that is
all the more better.
Which operating system are you using?
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
of MoneyInStr and myMoney. Can you show the DECLARE
VARIABLE statements?
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
Aldo Caruso wrote:
Which are the steps to follow to backup and restore database users and
passwords ?
I usually just stop the server and copy security2.fdb file. Unlike the
databases, it is rarely written to. I mean, how often do you open new
user accounts.
--
Milan Babuskov
for Firebird 1.5, but it all still aplies (you just need to
add ICU library files from classic server tarball).
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
Mags Phangisa wrote:
Is there a way I can import data from a spreadsheet into a table? Any help
will be greatly appreciated.
Save to CSV format and use XMLWizard:
http://www.guacosoft.com/xmlwizard
It can detect and suggest datatypes, table structure, etc.
--
Milan Babuskov
use EXECUTE BLOCK as explained in
http://www.firebirdfaq.org/faq220/
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
on the events of Firebird, or if you have better
ideas on how to do it.
I'm running 100+ systems using events for more than 5 years, some of
them 24/7 and I never lost a single event.
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files
it in application.
If you have multiple applications accessing the database this really
depends whether you need separate logging for each client or not.
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com
there are UDF libraries (rfunc for example) that provide
date format functions. So you could write something like:
DateToStr(current_timestamp, '%d%m%Y%h%M%S')
Still using Firebird 1.5.3 (Hope to convert down the road)
In that case, use DateToStr or CASE.
--
Milan Babuskov
one which has similar performance and feature set?
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
Vander Clock Stephane wrote:
Thanks to my paranoia, i was thinking like everyone that
Update or insert
OR
Insert
Well, it is called UPDATE OR INSERT, and not INSERT OR UPDATE. As
you can see, update comes first.
--
Milan Babuskov
==
The easiest way
of transaction-less storage (MyISAM) which saves you
from having to backup/restore periodically to reset transaction counters
Note that 1. and 2. are related, MyISAM is much faster than Firebird
just because it has no transaction overhead.
--
Milan Babuskov
==
The easiest
, but it's open
source, so you can modify it to fit your needs.
I also wrote a simple data-pump in PHP, let me know if your're
interested, I can put it for download as well.
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http
trskopo wrote:
Suppose I have a sql statement :
select * from table
Is that possible to return only a few rows from that statement (not the whole
result), just like MySQL?
http://www.firebirdfaq.org/faq111
HTH
--
Milan Babuskov
==
The easiest way
,ma.mon$remote_pid
FROM MON$ATTACHMENTS MA
WHERE ma.MON$ATTACHMENT_ID CURRENT_CONNECTION
Those are only connected users. He wants to get a list of all user
accounts on the server.
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files
Marco Aurelio Castro wrote:
What is the query that I inform the name of the Foreign Key and it
returns the names of the tables and fields related to this foreign key?
You need to join system tables RDB$RELATION_CONSTRAINTS, RDB$INDICES and
RDB$INDEX_SEGMENTS.
Regards,
--
Milan Babuskov
.
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
Vander Clock Stephane wrote:
juste one question, i thing both are the same but with is the best to
store UTF8 code point ?
ASCII or ISO8859_1 ?
If you really do not care about collations, then OCTETS.
Stuff like UPPER, ORDER BY, etc. would not work properly anyway, so why
bother.
--
Milan
have to lose non-ASCII characters.
If it's a binary blob (subtype 0) you can also try to dump the contents
to a file (using FBExport or your code) and then import it back into a
new subtype 1 blob.
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual
message?
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
at the Luxembourg
conference was that keeping blobs in separate tables was (could be?)
a good thing
I fail to see any reason why?
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
STKCODE, COUNT(STKCODE) as COUNT1
from COUNT_SHEETS_DETAIL
where code STARTING WITH 'TPL'
GROUP BY STKCODE
)
order by 2
HTH
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
HTML table showing both old and new values.
Otherwise, do the inner join on key columns and use IS DISTINCT FROM on
all non-key columns.
HTH
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
Vary, i.e. the above is my opinion,
things may be different in your particular case.
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
using different
databases at the same time.
Beside that, this could pose a problem for some filesystems if you
stored them all in a single directory. I suggest you desing a hierarchy
of subdirectories in such way that you do not have more than 100
database files in each.
--
Milan Babuskov
Nando wrote:
ISC ERROR CODE:335544348
no current record for fetch operation.
Use LEFT JOIN:
http://www.firebirdfaq.org/faq144
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
Easiest way to do it with gbak:
gbak -m database.fdb empty-backup.fbk
gbak -c empty-backup.fbk empty-database.fdb
If you already have a backup, you can use -m to only restore metadata.
gbak -c -m some-backup.fbk empty-database.fdb
--
Milan Babuskov
==
The easiest
column.
A useful tool to help you determine the structure is XMLWizard. It will
suggest the table(s), columns and datatypes you should use:
http://www.guacosoft.com/xmlwizard
HTH
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files
is only used if column is not specified in INSERT. If you run
insert into t1 (field1, field2) values ('abc', NULL);
You would still have NULL in the field. Therefore, it might be best to
use COALESCE even if you have default set.
HTH
--
Milan Babuskov
. For example, if your field is normally char(3), you can
increase it to char(4) and set '' as default. Restrict the data
entry in application to only allow 3 characters.
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http
:
http://www.firebirdfaq.org/faq137
HTH
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
, in PHP it would be a parameter in ibase_prepare() function,
and in C++ using IBPP library, it would be a parameter in
TransactionFactory constructor.
What programming language / data access layer are you using?
--
Milan Babuskov
==
The easiest way to import XML
$DATABASE
WHERE NOT EXISTS (SELECT 1 FROM T1 WHERE name = 'Z');
HTH
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
or x.RDB$SYSTEM_FLAG = 0)
You can write a similar one for procedures.
Regards,
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
lock managers running under different Linux user accounts.
Try adding localhost: to ISQL as well and it should work fine.
HTH
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
localhost:/opt/unb/archive/tmp/110831130601.fdb
Under which user account are you running gbak?
--
Milan Babuskov
==
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==
63 matches
Mail list logo