Re: [firebird-support] Preparing for upgrade from 1.56 to 3 or 4

out new passwords might be a real no-go. That's one of the main reasons we're delaying the upgrade from 2.5 to 3 at our customers' sites. Any suggestions much appreciated. thanks Tomasz -- __--======--__ __--== Tomasz Tyrakowski==--__ __--==

Re: [firebird-support] Does GRANT... TO PUBLIC has no more effect anymore?

convenient than having to execute dozens of grants after adding each new user; I know it has some downsides, but that's not the point here). Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Working with SQL (might be using loop)

, I can't think of a simple query doing that. 2 is an easy one, a simple iif and substring should suffice, e.g.: select iif(substring(AFIELD from 1 for 1) in ('0','1'), '-', '+') || AFIELD from SOMETABLE regards Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Prevent overlaping dates in concurent environment

e has to be a more elegant solution. Tomasz -- __--==========--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Prevent overlaping dates in concurent environment

s, the problem itself doesn't seem very artificial (I can imagine many situations when this kind of constraint would be useful) and it would be strange if there was no systematic solution. In fact what is needed here is a check that gets executed on commit ;) cheers Tomasz -- __--=

Re: [firebird-support] Prevent overlaping dates in concurent environment

t; = '8-SEP-2018'). > > At trigger 'MEETINGS_BI' line: 9, col: 7. OK, what I didn't get was that you intended to put _all_ subsequent dates from within an interval to the auxiliary table. Well, that way it should work. And I wouldn't be too worried about the size of the table, unless the intervals would be hundreds of years long. Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Prevent overlaping dates in concurent environment

e read committed), I don't have more ideas at the moment. have a good one Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Cannot create new database: "Can not access lock files directory /tmp/firebird/"

Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Cannot create new database: "Can not access lock files directory /tmp/firebird/"

is way you access the FB server via the network stack and the request gets handled by the FB inet server, running with "firebird" account priviledges. good luck Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

[firebird-support] Multiple copies of the same post

s, though. cheers Tomasz -- __--======--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Multiple copies of the same post

On 09.08.2018 at 14:28, James Woodard woody-...@gt.rr.com [firebird-support] wrote: > I've been getting the same thing. It's not all posts but a lot of them > get duplicated. I've just discovered I've been getting duplicates from one more list (IBObjects), which is also hosted on yahoogroups. So

Re: [firebird-support] How to store a string in Firebird which includes #0's in it?

On 08.08.2018 o 11:49, 'River~~' river14ap...@gmail.com [firebird-support] wrote: > [...] > So to go back to the original point I disputed, I personally intend to go > on referring to the byte terminating a C string as being x00 not as the > more pedantically correct chr(0). > [...] To be precis

Re: [firebird-support] install.sh not working in Ubuntu 18.04?

#x27;t remind you to install one if it's not). cheers Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Segmentation fault while trying to restore Firebird 2.1 database on Linux

On 04.07.2018 at 10:26, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > I am trying to restore Firebird 2.1 database on Linux but I am receiving > error message: > > > Command '/opt/firebird02/bin/gbak –c –v –p 4096 –user SYSDBA –pass > masterkey /backup/BIG_DATABASE /backup/BIG_DATA

Re: [firebird-support] How can I correctly write this WHERE

or Firebird to use indices to your advantage. If nothing of the above helps, send your query execution plan (plus the record counts of the tables involved and index defs). cheers Tomasz -- __--======--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] How can I correctly write this WHERE

Message: isc_dsql_prepare failed > > SQL Message : -104 > Invalid token > > Engine Code: 335544569 > Engine Message : > Dynamic SQL Error > SQL error code = -104 > Token unknown - line 35, column 29 > < > > > This is the < in the THEN clause >

Re: [firebird-support] Strange behaviour with char '#'

ug in the client code. Try it with isql (I've tried both isql and flamerobin). If it works, check your client code. regards Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__

Re: [firebird-support] Issue with GBAK and upgrading old DB (1.5 -> 3.x)

st (make a side copy of the DB and give it a shot). regards Tomasz -- __--==========--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Creating a conditional "order by" statement

ondition, Amount1, Amount2) as SORTCOL, ID, Amount1, Amount2, ... from Table2 order by 1 If there are more than two possible candidates for the ordering column, you can switch from iif to case - when - end. have a good one Tomasz -- __--======--__ __--== Tomasz Tyrakows

Re: [firebird-support] "Invalid Cursor State"

know why :) have a good one Tomasz -- __--==========--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] why I not get first row in procedure

alyze in detail, but just a suggestion. You basically have something like this in your procedure: for select ... do for select ... do suspend If the outer select doesn't return any rows, the inn

Re: [firebird-support] Automatic Firing of Query.

when your app is doing nothing, or just that it's an excess query not originating from your code? Sorry I can't be more specific, but maybe my remarks will point you in the right direction. regards Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--

Re: [firebird-support] permissions nbackup

> Absolutely right. My point was having root should is not crucial. It should read: having root is not crucial Typing and having dinner at the same time is not healthy for your stomach and for your readers. Apologies. Tomasz ---

Re: [firebird-support] permissions nbackup

On 14.08.2017 at 18:03, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > If you have sysdba permissions, you can do nbackup via services. > Security database is small enough for gbak too. Absolutely right. My point was having root should is not crucial. regards Tomasz

Re: [firebird-support] permissions nbackup

On 14.08.2017 at 17:41, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 14.08.2017 17:21, Nick Upson n...@telensa.com [firebird-support] wrote: >> if I do nbackup . it fails, telling me I cannot access the security2.fdb >> (as a normal >> user) > > Why can't you use su

Re: [firebird-support] permissions nbackup

On 14.08.2017 at 17:21, Nick Upson n...@telensa.com [firebird-support] wrote: > if I do nbackup . it fails, telling me I cannot access the > security2.fdb (as a normal user) According to nbackup manual https://www.firebirdsql.org/manual/nbackup-functions-params.html for backing up (-B) you n

Re: [firebird-support] permissions nbackup

On 14.08.2017 at 15:51, Nick Upson n...@telensa.com [firebird-support] wrote: > I'm looking at using nbackup but the file permissions on security2.fdb mean > only firebird or root can do so, is that the way it is supposed to be? Definitely. You wouldn't like any third party to access the password

Re: [firebird-support] Changing collation

On 29.06.2017 at 19:15, Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support] wrote: > On 28.06.2017 at 22:58, Ann Harrison aharri...@ibphoenix.com > [firebird-support] wrote: > [...] > Or is 3 strictly bound > to PXW_PLK and always means PXW_PLK, regardless of the c

Re: [firebird-support] Changing collation

On 28.06.2017 at 22:58, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > Not if you have indexes, a declared primary key, or a declared unique > constraint. The index keys are a transformation of the value into a format > that produces the desired ordering through binary compariso

Re: [firebird-support] Changing collation

On 27.06.2017 at 19:39, Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support] wrote: > Is it possible to change the collation of a varchar column in place > (without making a temporary column, copying data, dropping the original > column, making it anew and copying the data bac

[firebird-support] Changing collation

Hi, Is it possible to change the collation of a varchar column in place (without making a temporary column, copying data, dropping the original column, making it anew and copying the data back)? Would setting RDB$RELATION_FIELDS.RDB$COLLATION do the trick (and is it safe to do)? I've got sever

Re: [firebird-support] Re: UDF and server crashes on linux

uses list on linux. Keep in mind that superserver and superclassic flavors of FB are multithreaded, so your UDF is in fact being loaded into a multithreaded process, even if the UDF doesn't do any multithreading itself. have a good one Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Immediate Detection of Disconnected Clients on Classic

#x27;m used to that ;) Just wanted to point out there's no magic in TCP and if you partition the network and no control packets can be exchanged, there's no way you can detect what really happened. So let's not blame Firebird for keeping open connections to dead clients for some ti

Re: [firebird-support] Immediate Detection of Disconnected Clients on Classic

uot;immediately" when there is no data exchange between the server and the client (it would require some kind of heartbeat increasing traffic and would be based on timeouts, which are tricky), otherwise byzantine network partitions wouldn't be so nasty. hope this helps cheers Tomasz --

Re: [firebird-support] Re: Which connection causes object in use - is there a way to find that out?

On 25.10.2016 o 10:20, hv...@users.sourceforge.net [firebird-support] wrote: >> From time to time, when I try to alter a stored procedure in a >> production database, I get "object in use" error. > Run DDL statement in wait transaction. Better to set some timeout to not > wait too much, but not

[firebird-support] Which connection causes object in use - is there a way to find that out?

Hi, From time to time, when I try to alter a stored procedure in a production database, I get "object in use" error. I was wandering, is there a way to find the connections (users) that prevent a particular procedure from being altered? Querying MON$STATEMENTS is a no-go, no statement currentl

Re: [firebird-support] Character sets and collations of columns

On 30.08.2016 o 08:14, Stefan Heymann li...@stefanheymann.de [firebird-support] wrote: >> One of the legacy databases I happen to maintain has character sets and >> collations messed up. [...] > > For a database that is messed up like this, I'd go the clean way and > use a pump. That would also gi

Re: [firebird-support] Character sets and collations of columns

the encoding of the columns (which might be incorrect) and the encoding used by the client. The actual data, when I display it via Flame Robin or isql seems to be OK, it's the sorting or uppercasing that goes weird. Thanks for the suggestions anyway. regards Tomasz -- __--===

[firebird-support] Character sets and collations of columns

ted tables and over 60GB of size, so if there is another way, I would be grateful to hear about it first. Thanks in advance and sorry for this lengthy story. regards Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] SQL Error Code -104: What is wrong with this rather simply SQL?

On 06.04.2016 o 22:03, 'stwizard' stwiz...@att.net [firebird-support] wrote: > SELECT DISTINCT P.AREA_CODE, P.PHONE_NO, > >(SELECT COUNT(*) > > FROM PHONE P2 > > WHERE P2.PHONE_ID = P.PHONE_ID) AS CNT > >FROM PHONE P > > WHERE P.AREA_CODE IS NOT NULL > > GROUP BY 1,

Re: [firebird-support] Re: Gbaked and restored database larger than the original?

thanks for this suggestion anyway, it's worth remebmering that changing the type doesn't affect the data that's already there. regards Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Gbaked and restored database larger than the original?

W dniu 2015-07-08 o 14:18, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Another reason could be restoring with a different page size than the > original database. Both databases have 8k pages. Tomasz -- __--==--__ __--== Tomasz Tyra

Re: [firebird-support] Gbaked and restored database larger than the original?

On 2015-07-08 o 14:14, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] wrote: > Take a look here: http://www.firebirdfaq.org/faq361/ Yes, I've come across this on another occasion, but it doesn't seem to apply to my case (I didn't switch to a different version of F

[firebird-support] Gbaked and restored database larger than the original?

Hi, Just for my cursiosity and for a better understanding of Firebird: what can be a possible reason for a gbaked and restored (to a different file) database being _larger_ than the original one? I've got a db of size 104521728 bytes. I do gbak -B -T database.fdb database.gbk, then gbak -C data

Re: [firebird-support] Firebird 2.5.x slow queries problem

ng more specific, I don't use IBExpert and I'm not familiar with its internals, but there's a lot of people on this list who can give you better hints, just wait a while. regards Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Query to update multiple records in same Table

for: update ANALOG a set a.NAME=(select NAME from ANALOG where TAG_NO=a.TAG_NO-1238) where a.TAG_NO >= 3671; (3671 = 2433 + 1238) Eventually you can further filter the rows being updated by adding more terms to the "where" clause. regards Tomasz > >

Re: [firebird-support] working days between two dates

there an easy way to get the workings days between to > dates? Or should I do an UDF for that? > > > Thanks!! > -- __--==========--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: AW: [firebird-support] Cannot transliterate character between character sets.

ide a better explanation than the one Mark has. good luck Tomasz -- __--======--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Cannot transliterate character between character sets.

e record once you find the value of its key? AFAIR, FlameRobin allows you to retrieve data in chunks (300-records long by default). Using this feature, you can quickly find the 300-record range and then a 9-step binary search should give you the exact record. regards Tomasz -- __--====

Re: [firebird-support] Problem when group by a sub-query

oup by cobrador; regards Tomasz -- __--======--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Unlocking a database with active connections

7;t ask how I got myself a 5-gig delta file ;) regards Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

[firebird-support] Unlocking a database with active connections

in advance. regards Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Can non-sysdba really alter users?

again guys for your help. The cause of all trouble was the lack of the "OR CURRENT_ROLE = 'RDB$ADMIN'" condition in the original view definition. regards Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Can non-sysdba really alter users?

s Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Can non-sysdba really alter users?

id one (i.e. one which allows privileged users to alter other users) and maybe I'll come up with an idea how to write the upgrade script myself. regards Tomasz -- __--======--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Can non-sysdba really alter users?

24a354c4f514f59 71653550417572706147 78704a7569637650383d regards Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Can non-sysdba really alter users?

f intriguing, isn't it? regards Tomasz -- __--==========--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Can non-sysdba really alter users?

another job >> ;) ). >> > > You can pump the data to another database shell without touching or knowing > the passwords > Alan > > -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Can non-sysdba really alter users?

d that and succeeded, please post some hints. And thank you Thomas for finding this news post - your googling seems better than mine ;) regards Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Can non-sysdba really alter users?

er). regards Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

[firebird-support] Can non-sysdba really alter users?

attempts to change U1 fail, though. Is there anything I'm missing? Should I somehow tell Firebird that, when connecting as U1, I'd like to assume admin role not only in test.fdb, but also in the security database? Any help appreciated. regards Tomasz -- __--===

Re: [firebird-support] Howto compile Firebird C-API examples

e. cheers Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Generators, what could cause resetting generator values to some earlier version

ed to me so many times - I thought I "discovered a bug" in an RDB or a compiler, and in most cases it was just another ordinary bug in the code). Sorry I couldn't be more helpful. regards Tomasz -- __--======--__ __--== Tomasz Tyrakowski==--__

Re: [firebird-support] Generators, what could cause resetting generator values to some earlier version

month ago. The values of generators are stored per database, so corrupted security DB shouldn't do any harm to them. regards Tomasz -- __--======--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Moving primary key to another column

On 2012-08-06 14:33, Tomasz Tyrakowski wrote: > 3. create the new primary key column (alter table MyTable add NewKey not > null) It should have been alter table MyTable add NewKey integer not null Forgot the column type. Sorry for that.

Re: [firebird-support] Moving primary key to another column

(NewKey) ) No extra table required. regards Tomasz -- __--======--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__ ++

Re: [firebird-support] output from SQL

be easily implemented with two stored procedures and a table. regards Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Re: How to limit the number of concurrent users to a database

re is only one connection and this connection is itself, the program > runs a cleanup routine setting IN_USE of all records (except its own) to 0. > On all systems this happens at least once a day, i.e. there are no 24/7 > systems out there. -- __--======--__ __--=

Re: [firebird-support] How to limit the number of concurrent users to a database

onnect to a database in single mode). thanks Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.so

[firebird-support] Database shut down question

role (of course, only when the role had been granted). Tested on FB CS 2.5.0.26074, 32-bit Linux. Is this intentional? In a way, it even makes sense. If so, I'd suggest stating it clearly in the manual. regards Tomasz -- __--==--__ __--==

Re: [firebird-support] Help needed wit a Select ... Group By

e this: select Gender_Name, Race_Name, Fop_Name, TheYear, count(*) from ( Select Gender_Name, Race_Name, Fop_Name, extract(YEAR from Register_RegDate) as TheYear from V_Register_Fop ) group by Gender_Name, Race_Name, Fop_Name, TheYear I hope this helps. Regards Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Re: UDF memory allocation for result string in Linux

mpiling from x86_64 to x86. A general hint: install 32-bit Firebird in a different location, use -L/firebird-32-location/lib and -m32 when compiling for x86, and -L/firebird-64-location/lib when compiling for x86_64. regards Tomasz -- __--==--__ __--== Tomas

Re: [firebird-support] UDF memory allocation for result string in Linux

rebird/include -L/opt/firebird/lib \ -oUDF3s.so UDF3s.c -lib_util -lstdc++ -lm -lc (I'm not sure whether libstdc++ is necessary, sometimes it is). regards Tomasz -- __--======--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Not Exists cost

>> SELECT * >> FROM A_TABLE at >> WHERE >> at.VALUE1 = 'Y' AND >> NOT EXISTS ( >>SELECT 1 >>FROM B_TABLE bt >>WHERE bt.VALUE2 = 'X'); > > The query PLAN would tell you for certain, but I would expect the answer to > be: > half of A_TABLE rows times all of B_TABLE rows. If there'

Re: [firebird-support] Assign Double Precision value to a varchar field in Stored Procedure

, it proves your conclusion wrong. But please, use a tool as generic as possible (I'd suggest isql), i.e. one that won't round your -0.0199868556 and -0.0199868554 to -2E-6 ;) regards Tomasz -- __--======--__ __--== Tomasz Tyrakow

Re: [firebird-support] order by using parameter of stored procedure

re (it won't use indices, so it's only suitable for reasonably small number of records). Otherwise, I'd opt for EXECUTE STATEMENT, as Helen suggested. regards Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM

Re: [firebird-support] Backup and restore of users

an't be accessed by a > regular/direct database connection anymore. Accessing is only possible > via the Services Manager. Thus, you need to use the -se switch when > backing up the security database. At least on Windows. Can't test your > above gbak call under Linux right now.

Re: [firebird-support] Backup and restore of users

Unlike the > databases, it is rarely written to. I mean, how often do you open new > user accounts. > -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Precision in stored procedures

ipt or damage to > your system. RxStrategies, Inc. does not guarantee that the integrity of this > communication has been maintained nor that this communication is free from > viruses, interceptions or interference. > > > -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Firebird 2.5.0 Generator gone wild

as you describe. regards Tomasz -- __--======--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] About trigger

that their is no possibilities to do so but in case > > -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] stored procedure with list of values as input parameter

ter? > I need to retrieve result for query looking like > > select field1, field2 from table1 where field3 in (1, 2, 3, 4); > > is there a way to give list of values as input parameter? but sometimes > there could be just one value for input. so it should w

Re: [firebird-support] Create Users Error Firebird

Error. > SQL error code = -104. > Token unknown - line 5, column 3. > CREATE. > > " > where is my mistakes? > > -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Versioning Question

and the type of servers (Classic or SuperServer) you plan to install (e.g. Classic on Linux will probably require reconfiguration of inetd). regards Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Fwd: trigger that calls procedure

looper = 1; >leave; > end > /* do what you want with the vars */ > /* re-initialise the vars */ >end > > end > > end > > Don't take this as an absolute template for what you want to do, it's just to > give you the idea for designing the flow that you need. > > ./heLen > > > > > > > -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Re: why failed to insert into a table from a storeprocedure?

sert into t2 (..) >select .. from t1 > , can the t1 be a store procedure ? > > > > > --- In firebird-support@yahoogroups.com, Tomasz Tyrakowski > wrote: >> >> Hi, >> >> At the first glance, it should work as expected. >> If you run by

Re: [firebird-support] why failed to insert into a table from a storeprocedure?

t; > test2 is a store procedure defined in the same database. it fetchs records > from some tables and an other store procedure. > > but nothing have done without any error. if execute alone the store procedure > test2, lots of records can be founded. > > why? > >

Re: [firebird-support] DDL updates in 2.5

to disconnect my client tool (Flamerobin) and other applications. It > seems the DDL changes are in som kind of trasaction control. > It is however NOT sufficient to commit the active transaction and start a new. > > Thanks, > > Martin > > > -- __--==

Re: [firebird-support] DUP key on restore

t; FROM MyTable > GROUP BY 1 > HAVING count(*)> 1 > > cannot use the index and will find such duplicates. > > HTH, > Set > -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] DUP key on restore

gt; > [Non-text portions of this message have been removed] > > -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Re: selecting a field by name (using a var)

e statement :loc_sql into :out_fecha; >suspend; > end > > It's OK? or it can be improved? Thanks again > > -sergio > > -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Performance in Firebird 2.5

> > Phone : +91 80 3097 1570 > > Mobile : +91 99808 37446 > > www.sonata-software.com > > > > Please don't print this email unless you really need to. This will > preserve trees on our planet. > > > > > > [Non-text porti

Re: [firebird-support] Firebird 2.5 crashing after calling UDF

s down and does not accept anymore connections. > > We are coming to the end of our tether with this. > > Kind Regards, > > Robert. > > > -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Firebird Program loses network connection

/tcp_keepalive_*. On Windows, follow instrutions of this article: ># http://support.microsoft.com/default.aspx?kbid=140325 > >As Ann would say, good luck! > >Cheers, >Norm. > >-- >Norman Dunbar >Dunbar IT Consultants Ltd > >Registered address: >Thorpe House >61 Richardshaw Lane >Pudsey >West Yorkshire >United Kingdom >LS28 7EL > >Company Number: 05132767 > > >. > > > > [Non-text portions of this message have been removed] > > -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Firebird Program loses network connection

> tried Firebird 2.5.1 as well but no go. > > Also suspected something is not right with the program but running the same > test at my own office with lower end computer and much heavier transaction > will not have any problem. I pretty much given up and not sure what so

Re: [firebird-support] Re: How to update this table? EXPERIMENTAL RESULTS - Email found in subject

d > some ER frameworks) instead of EXISTS() you would find that a very different > story. > > > Sean > > -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

[firebird-support] Re: How to update this table? EXPERIMENTAL RESULTS

post, but I wanted to share the results so that some other people don't have to reinvent the wheel. regards Tomasz -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Re: How to update this table?

er (if this were a very large table) than SELECT * in the sub-select? > > In other words, I'm unclear how the rows from the sub-select are > 'materialised' prior to joining to TableA and whether * is needed return > TB.LINE so as to test for TA.LINE = TB.LINE or not (if that makes sense!). > > e.g. > UPDATE TableA TA > SET TA.USED = 'T' > WHERE EXISTS(SELECT 1 FROM TableB TB WHERE TA.LINE = TB.LINE) > > Thanks, > Tom > > -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] Query result not displayed

ways > the same result > > > > Does anyone have an idea to resolve this problem. > > > > Best regard. > > > > [Non-text portions of this message have been removed] > > -- __--==--__ __--== Tomasz Tyrakowski==--__ __--==SOL-SYSTEM==--__ __--== http://www.sol-system.pl ==--__ __--==--__

Re: [firebird-support] SQL user management in FB 2.5

DB you're working on anyway - it's the dialect that matters. thanks again Tomasz On 2011-10-03 22:30, Helen Borrie wrote: > At 08:32 AM 4/10/2011, Tomasz Tyrakowski wrote: >> Hi guys, >> >> Have you managed to make the statement >> >> alter user IS grant ad

  1   2   >