You seem to not be solving a problem but only looking to improve something.
What are you trying to improve?
I say you are just looking for trouble by changing something that is not a
problem.
What are you seeing that makes you think your goal has not already been met?
On Mon, Jul 15, 2013 at 12:38 PM, trskopo trsk...@yahoo.com wrote:
Hi all,
I have a 16GB RAM and since my database file is small size, it can
completely runs on RAM.
The problem is I can not set FB SuperClasic
On Mon, Jul 15, 2013 at 12:54 PM, trskopo trsk...@yahoo.com wrote:
Simple, i still have a lot of free RAM.
As Sean pointed out, that suggests you may not have achieved your goal but
does not definitely indicate that you haven't.
Better indication would be file I/O that you would not expect.
The problem is that you have asked to summarize the data by grouping on
product description but you have also asked for a product code. The server
does not know if there is a one-to-one relationship between product
description and product code. Therefore, it does not know what product code
to use
On Mon, Jun 3, 2013 at 8:01 PM, cornievs corni...@gmail.com wrote:
I know I can the get difference with DATEDIFF, but I need the result as a
TimeStamp.
That does not make much sense. A timestamp is a point in time. A time
period is a duration of time, not a point in time. The appropriate type
The collation being used should be case insensitive. Test 4 results show it
is not, so all is not well.
Or am I reading this wrong?
On Wed, May 22, 2013 at 10:27 AM, liviusliv...@poczta.onet.pl
liviusliv...@poczta.onet.pl wrote:
In test 4you compare lower letter f with upper letter F then
You obtain the data from the MON$ATTACHMENTS table using a simple SELECT
query. Refreshing the query that reads the MON$ATTACHMENTS table is done by
comiting the transaction within which the query was issued and then
repeating the whole SELECT operation again.This will ensure you see the
latest
I would also strongly advise against this design. It is a design for
failure. Not immediate failure but eventual failure.
On Wed, Apr 17, 2013 at 8:12 AM, chris.waldmann
christian.waldm...@rte-ag.ch wrote:
As a senior software and database developer, this is my experience:
If anything can go
I agree.
Over the years I've used and built dozens of utility programs that use the
error code return value to reflect various status values unrelated to the
basic utility operation. Typically 0 means no problems, positive values
mean basic ops problem (serious operating errors), negative values
On Thu, Apr 4, 2013 at 10:19 PM, Helen Borrie hele...@iinet.net.au wrote:
How do you plan to work a Delphi application with an embedded database and
database server on MacOSX?
The last few versions of Delphi can create native MacOSX executable apps.
[Non-text portions of this message have
Wolfgang-
The same idea should work with FIBPlus components. The class that
represents a field in a table or query should have a Clear method you can
call to set the field to NULL. Every DB component set I have seen has this.
[Non-text portions of this message have been removed]
What OS is hosting this setup? I suspect Windows 7.
On 12/7/12 2:36 AM, Venus Software Operations wrote:
Does it mean that a single user can login using various roles that may
have been setup?
Yes. If a user has been granted several roles then any one of those
roles can be used by that user when connecting to the database. The user
can also have
On 12/6/12 2:29 AM, Venus Software Operations wrote:
Thanks Andre your suggestions are appreciated.
I have created the role and provided the privileges to this role. Now it
should be a matter to transfering this role and it's privileges (which I
am presently working on in the utility) to
On 10/24/12 5:54 PM, cornievs wrote:
I have query which extract the sales per day from a table
Select EXTRACT(YEAR from DT) as YEARNO, EXTRACT(YEARDAY from DT) AS DAYNO,
SUM(DUE) from CLIENT_INVOICES group by YEARNO, WEEKNO.
It works 100%, but only returns the dates with sales, I need it to
On 10/24/12 6:25 PM, Alexandre Benson Smith wrote:
Em 24/10/2012 20:21, Doug Chamberlin escreveu:
On 10/24/12 5:54 PM, cornievs wrote:
I have query which extract the sales per day from a table
Select EXTRACT(YEAR from DT) as YEARNO, EXTRACT(YEARDAY from DT) AS DAYNO,
SUM(DUE) from
On 9/23/12 9:22 PM, red_october2009 wrote:
I used UDFs for years until FB2x came along. I view UDFs as a stop gap
non-standard solution until a built-in standard solution can be implemented.
I would much rather dump all my UDFs and use FB functions instead.
Of course, that is one reason for
On 9/21/12 3:12 PM, HECTOR RIOS wrote:
I´m trying to save some sql parsing in a Delphi application by using
temporary result sets. Is there such thing in Firebird?
For example: some user makes a query with some filters and then wants to make
another query over results from previous query.
Thanks for posting the summary, Tomasz. Excellent job of sleuthing!
I'm glad you figured it out in the end.
Doug C.
On 6/28/12 1:14 AM, jwcane2003 wrote:
Looking for a safe and reliable import process from csv data to firebird db.
Any pointers or other info appreciated.
Database Workbench does a good job. I use the CSV import all the time.
Also check out www.cvsexpress.com
On 6/21/12 3:39 PM, Rick Debay wrote:
Correct. There is no row, but we are getting data in the non-existing
row.
So how do I file a bug report on this?
Go to the Firebird main web site
http://www.firebirdsql.org
Select Development.
Look for the Tracker in the upper right corner of the
I think I would challenge whether adding a necessary entity (to satisfy
the FK requirement) needs to be in the same transaction as the overall
dataset processing.
If an Employee, for instance, can be added by any of several ETL
processes, does it really matter if one is added outside the main
On 6/7/12 3:57 PM, Michael Ludwig wrote:
Doug Chamberlin schrieb am 07.06.2012 um 14:07 (-0400):
I think I would challenge whether adding a necessary entity (to
satisfy the FK requirement) needs to be in the same transaction
as the overall dataset processing.
Another possibility might
On 3/15/12 6:36 AM, marc wrote:
My IT person is away on spring break and I am having trouble
getting a my network to access the FDB from another computer.
I am getting an error similar to : can not open FDB
All permissions are have been given. The database opens fine on the
server. Any
Top posting is when your reply is above the quoted message you are
replying to. This message from me uses top posting. In your message in
response to Thomas, which is quoted below, you used bottom posting.
Bottom posting is strongly preferred by many people because it is more
organized to add your
On 2/29/12 2:50 PM, todderamaa wrote:
Maybe with the possibility of corruption, I should tell him to exclude
the database files from backup entirely and only backup the gbk files
that are created in the evening.
This is the usual way to backup Firebird databases in situations like
your clients
On 2/29/12 3:30 PM, todderamaa wrote:
--- In firebird-support@yahoogroups.com, Doug Chamberlin
chamberlin.doug@... wrote:
On 2/29/12 2:50 PM, todderamaa wrote:
Maybe with the possibility of corruption, I should tell him to exclude
the database files from backup entirely and only backup
On 2/29/12 3:28 PM, todderamaa wrote:
But with this latest issue, we needed the database file and not the
backup. The restore of the backup failed, because we had a stored
procedure that was selectable that didn't include a 'suspend'
statement. I think this must be something that was allowed
On 2/29/12 3:47 PM, Leyne, Sean wrote:
The NBackup functionality allows a database file to be quiesced (with
changes written to a delta file) to allow for OS level backups to be
performed (thru Lock and Unlock options).
But doesn't that just move the potential conflict to the delta file,
On 12/18/11 6:50 AM, ehaerim wrote:
Two possible structures.
[1] (Symbol, Date, Blob) = Symbol primary and Date is secondary key
[2] (Symbol_Date, Blob) = Symbol_Date is single primary key
Relational databases nearly always work best when each individual data
item (column) is stored
On 12/18/11 1:10 PM, Ann Harrison wrote:
Doug, I was with you up to the last line.
Go with [2].
Oops! I meant to say [1]!
On 11/4/11 5:47 AM, Mark Rotteveel wrote:
Hi Helen, OSX Lion is OSX 10.7. So that matches the requirement.
Yes, the OP's
(OSX Lion Server 10.27.2,
was a typo. It should have been
(OSX Lion Server 10.7.2,
On 10/27/11 11:11 AM, dsaunders1971 wrote:
I have a question about why Firebird writes / or changes so much data in the
database file when you run a simple select query.
Two things come immediately to mind:
1) Everything gets read and written to the file system in blocks. So
even if you just
33 matches
Mail list logo
