generators
Hi! it's me again with silly questions...
Should I create one generator per table? Now I have a generator for tables
with (more or less) fixed data, and other for the tables that has mov | | 7 | 97 | 3/15/2008 7:18:38 PM |
Database Components in Multi-threaded App
Hello all,
I am currently changing a multi-threaded app that I have that processes alot of data and assembles an XML with it. The new version will add the resulting data to a Database Ta | | 4 | 117 | 3/14/2008 10:50:51 AM |
Interbase license for webserver
Hello
I am just wondering if the information I got from a swiss reseller is
right. Do I really have to buy a server with "unlimited users" (for more
than USD 5000.- !) to | | 13 | 67 | 3/13/2008 1:46:21 AM |
Transactions and performance
If I am doing a bulk insert, I keep one transaction open until the
inserts are complete. I was wondering if there any performance reasons
to commit occasionally. E.g., say I am inserting 1-m | | 6 | 64 | 3/12/2008 9:06:30 PM |
money fields
Hi, probably this is a stupid question, but...
I allways set the fields that represent money as NUMERIC(14,2)
Is that OK? or there's a better way? Should I use DECIMAL?
Thanks!
-sergio | | 9 | 62 | 3/12/2008 11:43:11 AM |
Select sample
Hello, I have an article's table and a Price List Table. The later just has
a different percents, for instance:
List #1 = 10%
List #2 = 15%
List #3 = 20%
The article' | | 2 | 60 | 3/11/2008 5:46:41 PM |
IB2007 Incremental Backup problem
We are trying to test the incremental backup feature of InterBase 2007, but
we seem to have hit a snag. This is the command that we are using to create
the online dump:
gbak -d -v | | 13 | 48 | 3/10/2008 7:44:21 PM |
Interbase and Vista
Did I hear/read wrong...I thought I read posts stating that IB2007
would be able to connect to a database using direct I/O...eg, no host
name. But I am not able to connect in this manner.
| | 8 | 89 | 3/10/2008 12:16:05 AM |
IB2007 journals and archiving question
Is it possible to produce "corrupt" journal files by using cached writes to
the journal files or by maybe a network connection loss while archiving the
journals over a network? If | | 4 | 55 | 3/7/2008 4:48:10 PM |
Unable to complete network request
Hi,
I have a Win 2003 server running Interbase dual processor server license and
an application connecting to 127.0.0.1:\. . . .\data.gdb. The reason for
not using a local connection | | 1 | 83 | 3/7/2008 4:04:57 PM |
should I avoid the "or" operator in order to improve performance?
Hello, this is thing I use very often, but now just I wander if it's the
best way to do it. Many times I need to select, lets say "the selected
customer *or* all customers" For tha | | 1 | 55 | 3/7/2008 1:41:57 PM |
InterBase 2007 Client Licence
Hi,
How are the client licences on InterBase 2007 counted?
Is it one licence per client PC regardless of how many database connections
the PC makes or is it one licence per proc | | 15 | 51 | 3/6/2008 9:49:55 PM |
New InterBase SKUS!
We have new InterBase SKUs which are available for sale today and will
be on our shop site tomorrow. These SKUS make it simpler to purchase
InterBase licenses and also significantly cheaper | | 0 | 57 | 3/5/2008 8:04:25 PM |
Blackfish vv Interbase
I've been using Desktop Interbase for 10 years of more, but am having
trouble getting deployment licenses for the latest (and only) Vista
compliant version.
Should I be changing to | | 5 | 70 | 3/4/2008 10:00:18 PM |
Interbase Server Data Execution Prevention on Server 2003 R2
Today when I logged in as a domain admin, I received a couple of notices that Windows Server 2003 R2 was locking down the Interbase Server threads due to Data Execution Prevention.
Is th | | 1 | 71 | 3/4/2008 4:48:36 PM |
Union Question
I have a union that goes something like this:
select A, B from table1
union all
select X, Y from table2
but in my case, I need to cast col Y to a null in the second select, s | | 1 | 70 | 3/4/2008 7:36:53 AM |
ARCHIVE_RESTORE
Using IB2007 developer edition on windows vista business edition i get the
following error from gbak
unknown win32 error (2) from gbak : unable to connect to labene-server
when | | 1 | 58 | 3/3/2008 4:45:53 PM |
Page size / page buffers... performance
02/28/2008
Using IB 7.5
Windows 2003 server
Memory 1gb
I vaguely remember a reference to an article about optimal settings for both
the page size and page buffers.
I | | 9 | 99 | 2/29/2008 4:40:33 PM |
Licensing Question
We have a server with dual quad core processors and are trying to figure out
how many Interbase licenses we need in order to take full advantage of this
hardware.
I tried contacting | | 9 | 71 | 2/27/2008 4:40:55 PM |
Greek Characters in IB7.5
Hi
Got a blob field in an InterBase 7.5 database with no default character set and trying to paste the following via InterBase Console:
??? ?? ?????? ????????? ??? SONY. ?? VAIO | | 4 | 57 | 2/27/2008 1:00:25 PM |
Product is not registered error
Hi everyone,
We recently upgraded our test server from IB 7.1 to IB 7.5, but now are experiencing the following error as recorded in Interbase.log.
"Product is not regis | | 7 | 78 | 2/26/2008 9:10:10 PM |
Storing a hash value
I need to store a 20 byte SHA1 hash in a record. Is it safe to save this as
a string, i.e. casting each byte with Char(digest[i]) and storing in a 20
character string? Obviously, this looks | | 1 | 52 | 2/25/2008 9:47:47 PM |
Best hardware for interbase
SGVsbG8sDQoNCndoYXQgaXMgdGhlIGJlc3QgaGFyZHdhcmUgZm9yIGEgZ29vZCBpbnRlcmJhc2Ug
aW5zdGFsbGF0aW9uIChmb3IgYW4gaW50ZW5zaXZlIHdlYiBzZXJ2ZXIgZGF0YWJhc2UpDQoNCnRo
YW5rcyBieSBhZHZhbmNlDQpzdGVwaGFuZQ== | | 1 | 51 | 2/20/2008 1:59:42 PM |
Deployment Licence
Hi,
As a developer I have build an application using IB6 and during deployment
IB too is bundled along. Now due to incompatibility with Vista I need to
purchase IB2007.
Will all m | | 2 | 49 | 2/19/2008 4:13:50 PM |
MAX THREADS Advice
Hi Everyone,
Can someone please help me with some advice on the MAX_THREADS setting?
I have an application at a site that runs on IB 7.5. There are a maximum of 20 users at this | | 11 | 56 | 2/19/2008 3:21:40 PM |
Accessing Firebird from delphi. Newbie question
Hi,
I need to access a Firebird db with Delphi. I never used any relational
db with Delphi, so I'm not sure what technology should I use, ado, dbexpress,
ado, etc...
| | 3 | 70 | 2/19/2008 10:10:33 AM |
is possible to get dedlock here?
Hi
i have trigger like this
CREATE TRIGGER TEST FOR TESTING1
ACTIVE AFTER INSERT POSITION 0
AS
DECLARE VARIABLE VAR_KOD VARCHAR(3);
BEGIN
VAR_KOD = NEW.KOD; | | 4 | 50 | 2/19/2008 8:52:14 AM |
Interbase 7.1 client with IB 7.5 and 2007
Guys,
We have a customer using our application and initially started with
Interbase 7.1, upgraded to IB 7.5 two years ago and recently to IB 2007.
We just found out that they never h | | 7 | 88 | 2/16/2008 2:10:29 PM |
Other ways to solve a slow solution
Hi !
I have a data intensive app developed under D7 with IB 7.5 server, runing on
Windows Server 2003 as a service.
The initial version was a standalone app, but few month ago I try | | 6 | 62 | 2/15/2008 3:09:10 PM |
long-running transactions
Dear all,
I've got an IBServer v7.5 running on a linux machine which grows and
grows in memory (it raises 1.5Gb sometimes!!) and don't know why. The DB
is about 2Gb and the average | | 17 | 99 | 2/14/2008 12:06:56 PM |
parameters in TSQLDataSet
I am having an exception thrown when trying to prepare the parameters for a
query. The exception is:
Token Unknown - line 1, char 12 ?
the query is:
TSQLDataSet* addUser | | 4 | 73 | 2/13/2008 11:28:40 PM |
Supported Versions of Interbase
Hi everyone,
Can I get some help in clarifying whether Interbase Version 7.1 is still supported? Which of the following articles is correct?
http://support.codegear.com/article | | 5 | 54 | 2/13/2008 5:13:14 PM |
Insert statement help
Basic question for most, but rocket science for me while I'm trying
to further wean myself off of table components:
I have a Table with a trigger that generates my primary key.
I | | 22 | 78 | 2/13/2008 11:44:27 AM |
ibserver.exe: terminated abnormally (-1)
ib 7.5.1
Just termined with no error message?
Mikael
ITLDB01 (Server) Fri Feb 08 11:41:55 2008
INET/inet_error: read errno = 10054 client host = ITLWEB01 conn | | 1 | 297 | 2/8/2008 1:54:32 PM |
RDB$USERS -> RDB$UID purpose
I would like to create a table that contains additional information not
already defined in the RDB$USERS table, such as the users email address. I
thought to create a 1-to-1 relationship, fo | | 3 | 52 | 2/5/2008 8:48:21 PM |
ERangeError
Hello,
I'm having serious troubles with my app. I can't debug anymore. Here is the
code:
DataModule.WeekReportQuery.Close;
DataModule.WeekReportQuery.ParamByName('START_T | | 6 | 74 | 2/5/2008 2:19:23 PM |
granting permissions to old users on new tables
Hi,
I have currently set up different interbase users for each of our different
systems. All the correct permissions have been set for all my tables, and
the stored procs. Everythin | | 11 | 53 | 2/5/2008 12:38:27 PM |
Strange issue with global temporary tables
To speed things up a bit for a report I'm using a temporary table. But the
first time I insert into it and read from it I get nothing back. The second
time (after committing and restarting t | | 5 | 71 | 2/4/2008 5:51:47 PM |
Install IB2007
I cannot install Interbase2007 on a SuSE 10 (public dist) computer. The
GUI comes up but selecting the Install does not work. The computer
accesses the CDROM for a while but never asks any o | | 2 | 55 | 2/4/2008 5:08:38 PM |
Access violation at address 4054A501 in module 'gds32.dll'. Read of address 00000000
IB 7.5.1
When my "NT-service" start I sometimes get this error.
If I ignore the error and continue working all is fine.
So what is this?
Access violation at addres | | 7 | 81 | 2/4/2008 6:54:24 AM |
Interbase 2007 developper edition
Can coesist Interbase 7.5 client and Interbase 2007 developer editon on the
same computer? Now I have my laptop with Interbase 7.5 client installed
because I use a program write with delphi | | 1 | 56 | 2/2/2008 9:57:57 PM |
Upgrade from 5.5
I need to convert our servers from SCO Unix to Linux.
We have been running programs written in C++ and compiled with the SCO
C++ compiler. First we need to try compiling the programs on | | 7 | 70 | 2/2/2008 11:18:38 AM |
Copying records
I'm adding some basic auditing to our application (IB 6 based) and basically
want to copy the old contents of a record to a second table in a before
update trigger. The second table will ha | | 1 | 44 | 2/1/2008 9:34:59 PM |
Calculate record size
Hi!
I want to calculate a record size before I actuallu create the table.
I'm sure there's some docs about that, but I'm totally blind this morning
and I can't see where.
| | 9 | 61 | 2/1/2008 8:40:18 PM |
Need help with design
Hi!
I have to take an actual medical paper form into a program.
The actual form have about 200 fields to be filled. I thought of doing some
1:1 tables to split the data across m | | 3 | 60 | 2/1/2008 7:29:32 PM |
interbase 5.6 and windows vista
Does Interbase 5.6 run on windows vista?
Thanks in advance.
| | 5 | 105 | 2/1/2008 2:33:38 PM |
tuning questions
dear all,
[I'm very sorry for the lenght of the text but it's a bit long to explain]
during the last 5 months we are experiencing very strange troubles with
ibserver in one of m | | 4 | 58 | 1/31/2008 11:59:40 AM |
Performance monitor killed IB 7.5.1
I klicked on the "Tables & Views........
Database: F:\PROJEKT\INFOCOM\FIBWWD\DATABAS\FIBWWD.GDB
internal gds software consistency check (missing pointer page in
DPM_data_p | | 6 | 47 | 1/29/2008 11:45:51 PM |
Lock conflicts/IB hangs
Environment: IB 7.5.1
Delphi 2006/DBExpress
I have a system with a very have load. I have made a "NT-service" with
several thread. (configurable)
Ea | | 9 | 66 | 1/29/2008 4:41:56 PM |
Closing a connection
Hi,
I have a client running IB 7.5, who is asking about the best way to close a connection to Interbase. Currently, they are shutting down the service, which is causing the interbase.log | | 7 | 85 | 1/29/2008 3:57:33 AM |