Skip to search.

Breaking News Visit Yahoo! News for the latest.

×Close this window

firebird-support · Support for Users of Firebird Releases

The Yahoo! Groups Product Blog

Check it out!

Group Information

? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Messages

Advanced
Messages Help
Messages 121755 - 121784 of 121784   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand Author Sort by Date ^
121755 Allstars
bpaz2001 Send Email
May 16, 2013
5:25 pm
Ok so i have this query, I want the customset.info to show a blank value for a part number. but when i set the customfieldid to 51 the record does not show...
121756 Allstars
bpaz2001 Send Email
May 16, 2013
7:04 pm
Sorry guys, But i was able to resolve the issue. I had to take the line customfieldid = 51 and join in with customset.recordid = part.id and customfieldid =...
121757 kp1780w7 Send Email May 16, 2013
7:34 pm
Hi, I experiencing a performance problem on some windows machines that i tracked down to gds_prepare using Intel's vtune. On some machines a sample program...
121758 Svein Erling Tysvær
svein_erling Send Email
May 17, 2013
8:17 am
... Hi Haris! I've no clue about your actual question, but am curious as to what your query looks like and what size of tables and result sets we're talking...
121759 Ann Harrison
annwharrison Send Email
May 17, 2013
2:27 pm
... Firebird actually doesn't sort whole rows, it sorts only the rows requested in the query - so select * is your enemy here as well. If it were to sort ...
121760 haris_p_sw Send Email May 17, 2013
6:33 pm
... Hi Set, Thanks for your reply. Here is my query which is a join between three tables. prdInCatTab holds the keys to product and prdCategory and it's a...
121761 homerjones1941 Send Email May 17, 2013
6:35 pm
Using GBAK via IBExpert, I get the following message. I don't know how to fix it (or find it). Overflow occurred during data type conversion. conversion error...
121762 haris_p_sw Send Email May 17, 2013
6:44 pm
... Hi Ann, Thanks for your reply. I just posted an answer to Set: http://tech.groups.yahoo.com/group/firebird-support/message/121760 You can see there that I...
121763 Marcus Bajohr
marcus.bajohr@... Send Email
May 17, 2013
6:54 pm
Hej, are there any anormal entries in the firebird log? ... [Non-text portions of this message have been removed]...
121764 homerjones1941 Send Email May 17, 2013
7:44 pm
The most recent is pretty old, and doesn't seem to be related. HOMER-TOSHIBA (Server) Wed Feb 20 11:15:26 2013 INET/inet_error: read errno = 10054...
121765 Leyne, Sean
seanchk_98 Send Email
May 17, 2013
7:54 pm
... I don't know myself, perhaps postgres applies a simple compression to the intermediate sort files to minimize disk space usage. The fact that your query...
121766 Leyne, Sean
seanchk_98 Send Email
May 17, 2013
7:56 pm
... Run Gbak with verbose, it will identify the table which has the problem. Did you alter the data type/domain of any columns of the problem table? Sean...
121767 homerjones1941 Send Email May 17, 2013
8:13 pm
I now have more information. The problem is with only one Time field in only one record. I isolated it by executing the following query, which produced the...
121768 Alexandre Benson Smith
thoriblist Send Email
May 17, 2013
8:16 pm
... There are blobs in any of the tables ? Since you are using select *, any blobs will be returned. IIRC there is a memory consumition above the expected when...
121769 homerjones1941 Send Email May 17, 2013
8:25 pm
I ran verbose and found the table. But, being a novice, I did alter the data type. It had been a date field, and I changed it to a Time field. I thought...
121770 Ted Miglautsch
lyotchik Send Email
May 17, 2013
8:30 pm
Change it back and you should be fine....
121771 fabianoaspro Send Email May 17, 2013
8:34 pm
Simple: do not touch system tables unless you know exactly what you are doing! This will avoid problems at all. There are no problems associated with reading...
121772 homerjones1941 Send Email May 17, 2013
8:35 pm
I'll try that. I'm worried about those users who have entered time values in that field after I changed from Date to Time. I'll test it and see. Thanks for...
121773 homerjones1941 Send Email May 17, 2013
8:42 pm
The application is in beta, and I suspect there may be other times when a change of domains is needed. Is there a way to do that without touching system...
121774 fabianoaspro Send Email May 17, 2013
8:46 pm
When we need to change a field type we create a new field with the new type, move the old data to the new field and then drop the old field. Then You can...
121775 Ted Miglautsch
lyotchik Send Email
May 17, 2013
9:24 pm
I frequently make changes to system tables and started using Interbase and then Firebird because I could do that. Mostly I extent the size of char and varchar...
121776 Alexandre Benson Smith
thoriblist Send Email
May 17, 2013
10:16 pm
... The correct way of doing this is using a DDL command ALTER TABLE In future versions of FB directly system table updates will be denied. see you !...
121777 haris_p_sw Send Email May 18, 2013
6:53 am
... Hi Set, Thanks for your reply. Yes, there are blobs and quite large varchar fields(160). I have already tested that if I select only some columns then the...
121778 haris_p_sw Send Email May 18, 2013
7:36 am
... Hi Sean, Thanks for your reply. Yes. I know that select * doesn't help and I agree with you that the key here is the total size of the dataset to be...
121779 Alfonso Presa
alfonsopresa Send Email
May 18, 2013
8:14 am
HI, I'm doing a batch insert/updateon 2 tableswith around 1.2 millions records. After some time performance decreace drastically. I'm using that DB for Web...
121780 Mark Rotteveel
mark@... Send Email
May 18, 2013
8:18 am
... Although you specifically answer his question about why Firebird loads rows into memory, the problem described could also be a bug or a suboptimal...
121781 Thomas Steinmaurer
iblogmanager Send Email
May 18, 2013
10:57 am
... Run gstat -h against the database when things are getting slow. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services...
121782 homerjones1941 Send Email May 18, 2013
7:58 pm
Problem fixed. The solution was to change the domain from Time to varchar. Then, get rid of any values with a date format, leaving only valid time values. Then...
121783 Ann Harrison
annwharrison Send Email
May 18, 2013
10:56 pm
... Unless things have changed, blobs in a dataset are returned as eight byte blob ids, then fetched on reference, so the contents of blobs should not be in...
121784 stoneoldrock Send Email 8:13 am
Hi, all (and Vlad) I was here to ask help about BLOB, and it helped a lot. Now I have developed a function which can load multiple (different) files into...
Messages 121755 - 121784 of 121784   Oldest  |  < Older  |  Newer >  |  Newest
Add to My Yahoo!      XML What's This?

Copyright © 2010 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines NEW - Help