download. Is that what you needed?
Jack
On 6/11/2015 11:35 AM, 'liviusliv...@poczta.onet.pl'
liviusliv...@poczta.onet.pl [firebird-support] wrote:
>
> Hi,
>
> Maybe another wrong direction,
> But download snapshot build of FB2.5
> And extract from there gback file. Do
Hi,
Maybe another wrong direction,
But download snapshot build of FB2.5
And extract from there gback file. Do backup with them and try to restore
Regards,
Karol Bieniaszewski
Wysłane z mojego HTC
- Reply message -
Od: "Tim Ward t...@telensa.com [firebird-support]"
Do:
Temat: Odp: [fi
Hi,
Maybe wrong direction
But set this restored with error database to be a readonly and try to connect
to it
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Jack Mason jackma...@mindspring.com [firebird-support]"
Do:
Temat: [firebird-support] Firebird 2.52 gbak fails to do a res
>>You asked something similar > 2 years ago:
>>http://comments.gmane.org/gmane.comp.db.firebird.user/7145
>>--
>>With regards,
>>Thomas Steinmaurer
>>http://www.upscene.com/
Sorry for off-top but
I'am very interested what jack.mason will say about this :
You have my +1 ;-)
regards,
Karol
W dniu 2015-06-10 14:30:52 użytkownik 'Jojakim Stahl' joja.li...@jojakim.de
[firebird-support] napisał:
>> is there a location where I can download a win64 installer package of a
>> nightly build including the fix, or when will 2.5.5 be released officially?
>>
>http://www.firebirdsql.org/e
Hello Vlad,
is there a location where I can download a win64 installer package of a nightly
build including the fix, or when will 2.5.5 be released officially?
Would need this for automatic installation.
--
Joja
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Ge
Hi,
Maybe first check db with gfix against corruption
Regards,
Karol Bieniaszewski
- Reply message -
Od: "hv...@users.sourceforge.net [firebird-support]"
Do:
Temat: [firebird-support] Re: losing connection with server on a local PC
Data: śr., maj 27, 2015 12:51
---In firebird-support@
Yes, full restore of normall database with indexes, keys ...
and on the same computer os hardware is the same. All 64 bit with 256GB Ram
Regards,
Karol Bieniaszewski
- Reply message -
Od: "'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]"
Do:
Temat: Odp: [firebird-support
>>Possible further enhancements during index re-creation would be to
re-create several indexes in parallel becoming more and more IO bound,
especially with low latency storage. >>>AFAIK InterBase added something
like that in a recent version. >>Potentially Firebird has that on the
roadmap as we
>>Here you change the SQL for each iteration, hence I cannot see how it would
>>be possible to prepare only once. What you could try, is to use a temporary
>>table, change your statement to:
Simple if after "iteration" query look like
SELECT * FROM TABLE WHERE ID=?
SELECT * FROM TABLE WHERE
Hi,
this is simple with "case" or "iif"
this run ok
SELECT CASE WHEN CAST('123.00' AS INTEGER)<>CAST('123.00' AS NUMERIC(18, 3))
THEN CAST('PRECISION LOST' AS INTEGER) ELSE CAST('123.456' AS INTEGER) END FROM
RDB$DATABASE
this run with an error "conversion error from string "PRECISION LOST
Hi,
the real question is in point 4
tables
CREATE TABLE TABLEX
(FIELD_ID INTEGER
);
CREATE TABLE TABLEY
(
ID INTEGER,
AAA INTEGER
);
CREATE TABLE TABLEZ
(
ID INTEGER,
BBB INTEGER
);
few thinks:
1. If i do something like this
SELECT (SELECT P.SUM_AAA FROM MY_PROC_CALC(T.FIELD_ID) P) FROM T
Hi,
Why not merge?
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Kjell Rilbe kjell.ri...@datadia.se [firebird-support]"
Do:
Temat: [firebird-support] Performance diff between insert...select and for
select ... do?
Data: wt., kwi 14, 2015 07:08
Kjell Rilbe kjell.ri...@datadia.se
Hi,
or better for “The SQL may return one or more records with a blank B4Me. In
which case, Natural order can be used for those records, and they are all
considered "First" or rather, "Before everything else”
select CASE WHEN B4ME IS NULL THEN 0 ELSE 1 END, CASE WHEN B4ME IS NULL THEN
ID ELS
Hi,
you must rethink what you try to retrive. What is then sense of returning
somethink in case of cycles?
If you have cycles then you do not get something before..
But if you need something strange then it is simple
ID as integer
select CASE WHEN B4ME IS NULL THEN ID ELSE B4ME+1 END, other_fi
then why here is an error?
SELECT CAST('123456789.23' as numeric) FROM RDB$DATABASE
result should be 123 456 789 is less then 2 147 483 647
i assume this, because this working:
SELECT CAST('12345678.23' as numeric) FROM RDB$DATABASE
SELECT CAST('123456789' as numeric) FROM RDB$DATABASE
PS.
Hi,
i know this kind of cast
SELECT CAST('1.23' AS NUMERIC(10, 2)) FROM RDB$DATABASE
but what are the rules for this (numeric without parenthesis)
[1]
SELECT CAST('1.23' AS NUMERIC) FROM RDB$DATABASE
result is "1"
[2]
SELECT CAST('12345678.23' as numeric) FROM RDB$DATABASE
result is "12345678
Thanks all,
i forgot about another locales like Sunday first day.
I see that supporting official function in FB will be problematic
then i do this in this way
SELECT
EXTRACT(YEAR FROM FLD_DATE),
CASE
WHEN EXTRACT(yearday FROM FLD_DATE)<100 AND EXTRACT(WEEK FROM FLD_DATE)>50
THEN 0
Hi,
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)
SELECT '2014-12-31', EXTRACT(WEEK FROM CAST('2014-12-31' AS DATE)) FROM
RDB$DATABASE
result is "1" but i need weeks in year -in example "53"
you know
This is what i needed
I found this in my customer software and wonder if this have some maining
regards,
Karol Bieniaszewski
.
[Non-text portions of this message have been removed]
>>Hi,
>>is there some difference in meaning between this two
>>SELECT DISTINCT R.RDB$FIELD_ID, R.RDB$RELATION_NAME FROM RDB$RELATIONS R
>>and this
>>SELECT DISTINCT(R.RDB$FIELD_ID), R.RDB$RELATION_NAME FROM RDB$RELATIONS R
Anyone know this?
regards,
Karol Bieniaszewski
Hi,
is there some difference in meaning between this two
SELECT DISTINCT R.RDB$FIELD_ID, R.RDB$RELATION_NAME FROM RDB$RELATIONS R
and this
SELECT DISTINCT(R.RDB$FIELD_ID), R.RDB$RELATION_NAME FROM RDB$RELATIONS R
regards,
Karol Bieniaszewski
to:firebird-support@yahoogroups.com
Sent: Saturday, March 14, 2015 5:03 AM
To: firebird-support@yahoogroups.com
Subject: Re: Odp: [firebird-support] How To Display Null Values At the End For
More Than One Columns Specified in Order By Clause?
Meaning was same.
On Friday, 13 March 20
444[null]asdas555
where do you see that maining is the same?
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Saturday, March 14, 2015 5:03 AM
To: firebird-support@yahoogroups.com
Subject: Re: Odp: [firebird-support] How To Display Nul
bird-support] How To Display Null Values At the End For More
Than One Columns Specified in Order By Clause?
Data: sob., mar 14, 2015 05:03
Meaning was same.
On Friday, 13 March 2015 11:06 PM, "'liviusliv...@poczta.onet.pl'
liviusliv...@poczta.onet.pl [firebird-support]"
wrote
Hi,
Following stackoverflow i see that
this is not what you show us in sample table results
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]"
Do: "firebird-support@yahoogroups.com"
Temat: [firebird-support] How To Display
Hi,
this is not possible to sort by SQL itself - because db sort "records by
columns" not columns itself.
You must write stored proc and inside it fill temp table with values - its
simple
regards,
Karol Bieniaszewski
W dniu 2015-03-12 14:36:50 użytkownik Vishal Tiwari vishuals...@yahoo.
Hi,
do you really do sort in this way?
SELECT
FieldA, FieldB, FieldC
FROM
MyTable
ORDER BY FieldA NULLS LAST, FieldB NULLS LAST, FieldC NULLS LAST
regards,
Karol Bieniaszewski
W dniu 2015-03-12 14:05:10 użytkownik Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] napisał:
T
Hi,
This look for me like wrong design.
Query running minutes are not acceptable from my POV.
I do not know how your system work, but in any stock system i see month work.
Month is closed and data are calculated and stored. And in next month the same
Regards,
Karol Bieniaszewski
- Reply me
Hi,
1. Is this VB exe or web?
2. Save all insert statement parameters to tabbed csv and you will see at what
statment it stop. If this is always at the same statement, then compare it e.g.
in excel withprevious statements.
Regards,
Karol Bieniaszewski
- Reply message -
Od: "SUKHEN DA
Hi,
Yes i know that,
But if he have some permanent connection to this db, then is the chance that
next day when he run some query, some data are already in cache. And with
bigger cache, is then bigger chance to same data in cache.
I use permanent connection on my server, where data are accesed
This is rather small value for superserver with big db
with this setting, Firebird cache is only 16MB of data ;)
Increase this settings. Calc it like buffers*page size
In your settings this is 2048*8192=16MB
But if to this db there is only one connection and it is closed and reopened
you loose y
Hi,
One more questions
What is your cache settings
And do you use blobs?
Regards,
Karol Bieniaszewski
- Reply message -
Od: "'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]"
Do: "firebird-support@yahoogroups.com"
Temat: [firebird-support] Re: Speed issues
Data: niedz., lut
Hi,
What kind of server Superserver or classic or superclassic
And how big is that cache settings?
Regards,
Karol Bieniaszewski
- Reply message -
Od: "zilez2...@yahoo.com [firebird-support]"
Do:
Temat: [firebird-support] Big database optimization
Data: czw., sty 8, 2015 22:22
I am runi
Hi,
Can you provide source code with this insert action / also dfm
I have Xe7 and i can test this
About FB on DC this is one hell with Exchange. And it is much bigger problem if
you have older version of FB then 2.5.3 (may be 2.5.2 fix i do not remember) on
Win2008 with bigger then 4GB RAM
Re
Hi,
Do you use firedac cached updates? I suppose that problem is not Fb. What
happened when you close your app and continue inserting? Db process this data
or still 2GB limit?
Regards,
Karol Bieniaszewski
- Reply message -
Od: "af_12...@yahoo.com [firebird-support]"
Do:
Temat: [fireb
Hi,
this is simple - but i do not know how many values you have
if this is small count then
select
Fields
FROM
TABLE_NAME
ORDER BY CASE WHEN ID=1032 THEN 1 WHEN ID=624 THEN 2 WHEN ID=2841 THEN 3 END
and if this is big numer then add better temp table with order values
regards,
Karol Bienias
Hi,
i work with big csv files and to speed up operations i convert it do external
table format with my tool.
It convert all fields types and work fast
but may be in Firebird 3 are some improvements?
Maybe this step is now unnecessary?
Can we separate csv file on the fly in FB proc? and loop t
Hi,
This is not nescessary until you change only body of procedure. If you change
params then this is another story ...
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Roland Turcan k...@rotursoft.sk [firebird-support]"
Do:
Temat: [firebird-support] How to rebuild all stored proc
Hi,
Performance with bad configured fb server
I use it in many systems from very small to very big db, with small and
moderete client count, and from small to very very high loads without problems
If you need some numbers, then ask
Regards,
Karol Bieniaszewski
- Reply message -
Od: "a
Hi,
Did you run this outside ibexpert?
What is exactly error message and code?
Try it with flamerobin or fbsql.
And then post info.
Regards,
Karol Bieniaszewski
- Reply message -
Od: "caste...@titelive.be [firebird-support]"
Do:
Temat: [firebird-support] numeric value is out of range
Hi,
I see 75 buffers - then i suppose you used default config.
Increase defaultdbcachepages settings in firebird config and try again with
superserver.
I do not see other reason for 30 minutes calc..
Regards,
Karol Bieniaszewski
- Reply message -
Od: "t...@camalot.ca [firebird-support
Hi,
What kind of calculation you do? I can not imagine calc with 45000 to take 30
minutes. I process 10 000 000 triangle calculations in aprox. 2 minutes in my
geo. Database
Regards,
Karol Bieniaszewski
- Reply message -
Od: "t...@camalot.ca [firebird-support]"
Do:
Temat: [firebird-s
Hi,
"execute statement" is your friend.
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support]"
Do:
Temat: [firebird-support] how to have different (conditional) order by clause
with same select
Data: śr., paź 22, 2014 05
Hi,
I do not follow whole discussion but what problem you see in
Select count(field1 ¦¦ '_' ¦¦ field2) from ...
You can include more fields
Regards,
Karol Bieniaszewski
Wysłane z mojego HTC
- Reply message -
Od: "'Softtech Support' stwiz...@att.net [firebird-support]"
Do:
Temat: [fi
Hi,
Yes you must uae cdecl but pass integer as var not pointer, use pansistring not
string (unicode), use iballoc
All is very simple to write in delphi
i wrote many udf,s without problem
Regards,
Karol Bieniaszewski
- Reply message -
Od: "hamacker sirhamac...@gmail.com [firebird-sup
Hi,
i test this on virtual machine with Windows 2008R2 and Xeon E5-2680 v2 and
result was:
Executing statement...
Statement executed (elapsed time: 0.000s).
10899160 fetches, 1051082 marks, 0 reads, 69 writes.
4 inserts, 950001 updates, 0 deletes, 950016 index, 2 seq.
Delta memory: 82968
Hi,
If you use default fb config then i suppose your cache settings is very very
small. Change DefaultDbCachePages to value greater then your db size in pages.
Then restart server and run test again.
You should have fastest response time.
I recommend you also 16k db page size for better index s
Hi,
Error message tell you that you must install client library gds32.dll.
Run Firebird installer on your laptop and in installation process check
something like copy client library gds32.dll to system folder.
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Marcos Herrera marcos.he
Hi,
Your big problem is low RAM with 32bit os an FB. Esspecially your sweep can
take very very long time if some of your index is bigger than avaiable RAM. And
yes upgrade to new server with minimum 16 GB RAM. Your DB is 50GB then the best
will be 64.
Then backup your db an restore with 16k pa
Hi,
First - what error message you get?
Regards,
Karol Bieniaszewski
- Reply message -
Od: "idea...@yahoo.com [firebird-support]"
Do:
Temat: [firebird-support] Select based upon date between two date fields
Data: pon., wrz 15, 2014 20:40
Hello,
I am new to firebird so excuse the possib
Hi,
1. you use old FB version. 2.5.1 is not newest version
2. Please include error message from FB log
Regards,
Karol Bieniaszewski
- Reply message -
Od: "fabianoas...@gmail.com [firebird-support]"
Do:
Temat: SV: [firebird-support] Firebird Embedded corruptions
Data: niedz., wrz 14, 2
Hi,
Better will be if you include error message instead of code only
i think that problem can be with timestamp is your field date or timestamp?
And also is your case statement full? Can contain values like 0101?
Better will be using substring + PAD instead of case statement
Regards,
Karol Bieni
Hi,
Your assumption is wrong that logic is ok. You have problem with one
installation probably because this client have havy load but others not.
Insert can only couse problem with unique constraint or reference to other
tables or trigger on that record
Regards,
Karol Bieniaszewski
- Reply
Hi,
There was two differences.
1. Your query return whole dataset my only missed ent.
2. I add +0 to avoid index usage your query use index in join and that index
can be corrupted
But empty result say somethink different. Try follow Sean questions.
Regards,
Karol Bieniaszewski
Wysłane z mojeg
Hi,
Your query is not good for index error
Try
Select * from zip_code_account z where not exists(select * from account a where
a.account_id + 0 = z.account_id)
This will be slow because it not use index but give you the answer
Regards,
Karol Bieniaszewski
- Reply message -
Od: "'Bob M
Hi,
http://tracker.firebirdsql.org/browse/CORE-742
i do not need to spam tracker then i move discussion to group.
Please disscuss/vote on exception handling mechanism related to udf call.
I can only say that crashing engine becouse udf raise exception is wrong at all.
This mechanism can corrupt
en for any reasons
Data: wt., maj 20, 2014 22:18
It's not resolve problem, because any my application can reconnect
to database.
20.05.2014 23:45,
'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl
[firebird-support] пишет:
Hi,
Delete from mon$attachments excluding curre
Hi,
Delete from mon$attachments excluding current connection
After that you are only logged user
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Markov Dmitri markovdmi...@yahoo.com [firebird-support]"
Do:
Temat: [firebird-support] Re: database became broken for any reasons
Data:
Hi,
If you have problem with shotdown database then unplug lan cable to have sure ;)
Regards,
Karol Bieniaszewski
- Reply message -
Od: "markovdmi...@yahoo.com [firebird-support]"
Do:
Temat: [firebird-support] Re: database became broken for any reasons
Data: pon., maj 19, 2014 19:31
D
at Windows 2008 memory problem are You refering to that needs 2.5.3?
Thanks
Zsazsi
2014-05-13 7:23 GMT+02:00 'liviusliv...@poczta.onet.pl'
liviusliv...@poczta.onet.pl [firebird-support]
:
Hi,
Your database is not big but your settings are low. Chan
Hi,
Your database is not big but your settings are low. Change your FB server to
64bit and increase your dbbuffer or in fbconfig defaultdbcasche setting and use
superserver. Check your database data page size. I always set it to 16KB. Your
database utylize memory in this pattern:
Dbpage size *
"firebird-support@yahoogroups.com"
Temat: Odp: [firebird-support] Bug? Come back
Data: śr., maj 7, 2014 10:26
Kjell Rilbe skriver:
>
> liviusliv...@poczta.onet.pl skriver:
> >
> > Hi,
> >
> > I back with this question. Is this really correct becaus
Hi,
I back with this question. Is this really correct because after discussion with
team i have now doubt.
We have here parenthesis. Any expression in parenthesis should be first
calculated
Then this is not test
NOT NULL - > NULL only
Not ( NULL -> NULL)
Regards,
Karol Bieniaszewski
- R
Hi,
Without details:
i store every point in different record
And have expression index with distance to constant point. Together this is
quite simple
Regards,
Karol Bieniaszewski
- Reply message -
Od: brucedickin...@wp.pl
Do:
Temat: [firebird-support] Re: GIS - CORE-659
Data: pon., ma
Hi,
Thanks you confirm this
I add this as "bug?" with question mark becouse Ingres server return in this
query wrong result and my boss think that i do something wrong in migration
process...
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Ivan Přenosil"
Do:
Temat: [firebird-supp
Hi,
How many page buffers have you in firebird conf or in db itself?
Regards,
Karol Bieniaszewski
- Reply message -
Od: m.djo...@yahoo.com
Do:
Temat: [firebird-support] Is it normal for SWEEPER to take hours to finish?
Data: wt., kwi 29, 2014 13:45
I agree, but for a 500MB database to t
Hi,
But you also misunderstud advice.
Blobs are not stored in table with its other fields. In record exists only blob
id and blob is stored on separate pages. Then moving it to separate table do
nothing.
But i always prefere store big data like document scans outside of database and
in main
Hi,
You must select from somewhere
E.g. use
Select c.valc
,(Select p.val from myproc(123))
From sometable
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Scott Morgan"
Do:
Temat: [firebird-support] Using PSQL as a function?
Data: czw., kwi 17, 2014 16:22
I checked the FB Book but
Hi,
I can not understand your query. What you try to acomplish.
Your query have not relations between tables and you put in "ON" clause some
"where" clause outside of context. What do you think do left join in this
context?
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Gordon Ham
Hi
I think that your app use gds32.dll instead of fbclient.dll. look if it is
present on your computer
Regards,
Karol Bieniaszewski
- Reply message -
Od: masb...@za-management.com
Do:
Temat: [firebird-support] connection problems
Data: wt., kwi 8, 2014 18:55
Hi
there,
first
I'd like
Hi,
I ask because if you include group by, order by or distinct in view definition
and you join with this view parser have not good way to optimize query.
I also add group, order in finall query never i view
Regards,
Karol Bieniaszewski
- Reply message -
Od: kokok_ko...@yahoo.es
Do:
Hi,
Did you use order by or group by in this view?
Regards,
Karol Bieniaszewski
- Reply message -
Od: kokok_ko...@yahoo.es
Do:
Temat: [firebird-support] Reading unnecessary records
Data: pt., kwi 4, 2014 13:36
I use the latest version of FB 2.5.
There is a view for called PERSON. Each r
Hi,
Did you started sweep manually? Or you wait for automatic sweep?
Regards,
Karol Bieniaszewski
- Reply message -
Od: soprano...@yahoo.com.ar
Do:
Temat: [firebird-support] Re: I dont know why sweep is not doing clean
Data: śr., mar 19, 2014 23:00
Thanks for all answers!
I'm still with
Hi,
Yes this is your network cofig problem.
Talk with your network admin. I have no problem with connect between networks
like this
192.168.2.100
255.255.255.0
192.168.2.1
And
10.10.6.110
255.255.255.224
10.10.6.105
Regards,
Karol Bieniaszewski
- Reply message -
Od: dennisktl...@yahoo
Regards
W dniu 10.03.2014 06:13, liviusliv...@poczta.onet.pl pisze:
Hi,
In first query you have no lock. In second you have lock
on selected records. First query can be run by different
users without any lock. After select from second query
user acuire lock on selected records
Hi,
In first query you have no lock. In second you have lock on selected records.
First query can be run by different users without any lock. After select from
second query user acuire lock on selected records
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Łukasz Bączek"
Do:
Tem
Hi,
I don't know IBDAC but if it work as dbexpress you need not only 64 bit
Firebird client but also 64 bit driver
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Freddy Holst Christensen"
Do:
Temat: [firebird-support] 32 or 64-bit
Data: wt., mar 4, 2014 15:23
Hey All
I have in
connections.
Regards,
Karol Bieniaszewski
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Dmitry Yemanov"
Do:
Temat: Odp: [firebird-support] Readcomitted ReadOnly Transaction - Commit or
Rollback?
Data: pt., lut 28, 2014 21:34
01.03.2014 00:14, liviusliv...@poczta.one
>> IIRC, TIP is written only when RC RO txn starts, at this point it
records its state as committed.
Dmitry
Nice, but it is written to disk and maybe it shouldn't?
Regards,
Karol Bieniaszewski
Hi,
This is understandable but
is this really needed to write TIP pages back to disc if readoonly readcommited
transaction start or end?I see no reason for that. It should be written only if
new page is allocated in TIP. But maybe i miss something .
Regards,
Karol Bieniaszewski
- Reply m
Hi,
I think about this. Is this really needed to write TIP pages back to disc if
readoonly readcommited transaction start or end? I see no reason for that. But
maybe i miss something ..
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Dmitry Kuzmenko"
Do:
Temat: Re[2]: [firebird-s
Hi,
Do you have only on test env. 400 transactions per second or it will be also
near number on real env?
I ask because you can reach transaction counter limit in two months.
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Ralf Jansen"
Do:
Temat: [firebird-support] Readcomitted R
Hi,
To debbug trigger use log table in autonomous transaction context avaiable in
fb2.5 or use external table which is outside of transaction management
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Werner"
Do: "firebird-support@yahoogroups.com"
Temat: [firebird-support] Trigger
Hi,
This is because you add filer in where to resultset move your filter
C.itemtype='Debit' from where clause to lefeft join filter and you get what you
want
Regards,
Karol Bieniaszewski
- Reply message -
Od: gorv...@yahoo.com
Do:
Temat: [firebird-support] Left outer join not giving
Hi,
Your design is wrong from security POV
If you need to protect db from copy - put it on server where only admin have
access. Then "noone" can copy your db.
If you put it on client computer you accept that risk at start
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Virna Consta
- Integer?
Data: pt., sty 3, 2014 07:55
03.01.2014 09:14, liviusliv...@poczta.onet.pl wrote:
>
> But what happen if to database is always someone connected? This is 24/7
> software.
Basically, I don't believe in databases working 24/7 for years without
dedicated maintenence hours
Hi Dmitry,
But what happen if to database is always someone connected? This is 24/7
software.
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Dmitry Yemanov"
Do:
Temat: [firebird-support] Re: MON$STATEMENTS - RDB$STATEMENT_ID - Integer?
Data: czw., sty 2, 2014 20:17
31.12.2013 12:
Hi,
Thank you for detailed answer now i know when exactly raise event worning for
user in my monitoring module
Mayby i put it as free software i am still not decide ;-)
Regards,
Karol Bieniaszewski
- Reply message -
Od: "Ann Harrison"
Do: "firebird-support@yahoogroups.com"
Temat: Odp
Hi,
Thanks you very much i see that i misunderstand fetches fetchesield previously.
Now it is clear - for 59732 records it is possible to have 120637 fetches :)
Regards,
Karol Bieniaszewski
- Reply message -
Od: hv...@users.sourceforge.net
Do:
Temat: Odp: [firebird-support] RE: MON$IO_
Hi,
Thank you for response.
My pagesize is 16k and pages cache is set to 65536. And this can not be that.
I see in MON$PAGE_READS small value = 585 but in MON$PAGE_FETCHES value =
120637. Database have 6685 pages what is corelated with real db size = ~104MB
Regards,
Karol Bieniaszewski
- R
Hi,
1. How you generate pk keys
2. Have you the same transaction for master detail
3. How you refresh data - you include in refresh query new ids?
Regards,
Karol Bieniaszewski
- Reply message -
Od: "checkmail"
Do:
Temat: [firebird-support] difficult question
Data: śr., gru 4, 2013 15:4
Hi,
Subqueries uses indexes i "the same way" as primary query.
Show us this subquery and query plan returned by server. Will be good to see
also Firebird version 1.5, 2.1, 2.5?
Regards,
Karol Bieniaszewski
- Reply message -
Od: "hosodaamiya"
Do:
Temat: [firebird-support] Indexes on s
Temat: Odp: Re[3]: [firebird-support] Broken databases
Data: wt., lis 19, 2013 20:32
On 19-11-2013 06:36, liviusliv...@poczta.onet.pl wrote:
> I'am not remember details and i what exact build number this error
> occure but i remember that this was in official release and was fixed in
u can store
duplicates in keyRegards,Karol Bieniaszewski "
I am quite shocked about that kind of error, would you please explain more ? I
want to know how and when it could occur in my existing databases. Thanks
Regards,Tjioe Hian Pin
On Tuesday, November 19, 2013 4:01 AM, &q
[firebird-support] Broken databases
Data: pon., lis 18, 2013 20:48
On 18-11-2013 09:58, liviusliv...@poczta.onet.pl wrote:
> Try "install" current snapshot of Firebird 2.5. Go to firebirsql.org
> downloads on the left you have snapshot builds. After download you must
> stop se
Hi,
Try "install" current snapshot of Firebird 2.5. Go to firebirsql.org downloads
on the left you have snapshot builds. After download you must stop server and
replace files. After replace start FB server. You should have version
2.5.3.26715 or greater
Regards,
Karol Bieniaszewski
- Repl
Hi,
Single quote is for string not number. Why you need it? For external function
it is converted from string to number.
If you declare external function you are limited to 2 arguments internal
function have not this limitation. And i always prefere internal then external.
Gbak have no proble
Hi,
Firebird have documentation like release notes. Read it there is all you need.
Go to firebirdsql.org and download doc to Fb version you have.
Regards,
Karol Bieniaszewski
- Reply message -
Od: "John W. (Jack) Cane"
Do: "Firebird Support"
Temat: [firebird-support] Modify Existing F
Hi,
Try putting parenthesis
substring( input_string from (idx-1) for 1 )
Regards,
KarolBieniaszewski
- Reply message -
Od: "Raith,Daniel"
Do: "firebird-support@yahoogroups.com"
Temat: [firebird-support] for select stored procedure question
Data: czw., paź 10, 2013 22:57
I guess I wa
501 - 600 of 622 matches
Mail list logo