Hi all, I'm using Firebird 1.5 by ODBC using PowerBuilder 8. I need that inside of my application I add user or change user password, for this I will login on...
67086
Paul Beach
paul62beach
Sep 30, 2005 3:50 pm
... Nope, thats not the point, you built classic, even though you are using the local access mechanism for classic is still classic, that means co-operative...
67087
Ann W. Harrison
annwharrison
Sep 30, 2005 3:52 pm
... Actually, that's not quite right. If you set the sweep interval to zero, you control the system-wide complete clean-up. However, garbage collection...
67088
Maurice Ling
beldin79
Sep 30, 2005 4:05 pm
... I have to say that I am generalizing the idea of cross database operations. Yes, we do not have much information in this particular case for cross db...
67089
Nick
upsonn
Sep 30, 2005 4:11 pm
I've tried to help this person but I don't do much with blobs Firebird 1.5.2 & isql. Trying to extract a list of all procedures that contain a given string, ...
67090
Ivan Prenosil
iprenosil
Sep 30, 2005 4:20 pm
... SUBSTRING does not support blobs. Either wait for Firebird 2, or use UDF. Ivan...
67091
Nick
upsonn
Sep 30, 2005 4:22 pm
use the gsec command -- Nick ... Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly I need that inside of my application I add user or change user ...
67092
Nick
upsonn
Sep 30, 2005 4:23 pm
the "for .. select do" syntax only works inside Procedures and Triggers it may be possible to do what you need without using it, please post what the script...
67093
grostoon
Sep 30, 2005 5:06 pm
Fine Pavel, so my test was not that foolish. It at least shows me that FB2 has some good improvements over FB1.5 no ? Thank you, Toon. Pavel Cisar...
67094
josephhirn
Sep 30, 2005 5:14 pm
Basically i need to loop through a set of document_page records using the id and document_id of each record to insert a corresponding record into endorsement...
67095
Emerson Muniz
emersonmuniz
Sep 30, 2005 5:44 pm
Thanks Nick, Now, How I can execute GSEC inside of a Store Procedure? Regards, Emerson Muniz Brazil ... __________________________________ Yahoo! Mail - PC...
67096
Nick
upsonn
Sep 30, 2005 6:35 pm
you can't as shipped, you could write/install a UDF that allows you to execute a program on the server, similar to the C system call then call it as...
67097
Emerson Muniz
emersonmuniz
Sep 30, 2005 6:47 pm
Thanks Nick, I will search a UDF or execute the GSEC by my application. I believe that execute from a Store Procedure will be better. Thank you very much. ...
67098
Ann W. Harrison
annwharrison
Sep 30, 2005 7:02 pm
... The worst performance problem in Firebird and InterBase was garbage collecting an index with lots of duplicates. V2 changed the index structure so all...
67099
Rick Debay
rdebay@...
Sep 30, 2005 9:16 pm
I have three queries that I aggregate with a union. I'd like the results from the first query placed before the second, and the second before the third. I...
67100
dancooperstock
Sep 30, 2005 10:24 pm
Thanks to all of you that have answered my questions about "Is Firebird Rock Solid". I'm going to continue my questions about using embedded Firebird in a new...
67101
ian.billups@...
ianbillups
Sep 30, 2005 10:34 pm
... uncontrollable ... Are there any plans for a feature in FB 2.0 to allow GC to be deferred, for example until the middle of the night? We run FB 1.5.2...
67102
dancooperstock
Sep 30, 2005 10:37 pm
I'm reading the doc on converting from MS SQL and it says that the CASE operator (e.g. case columnname when 1 then "foo" else "bar" end) isn't supported, and...
67103
Alan McDonald
metaalan
Sep 30, 2005 10:55 pm
... could be intersting - let us know what happens Alan...
67104
dancooperstock
Sep 30, 2005 10:58 pm
OK, never mind, I just read in the docs that both versions of the CASE operator were added in version 1.5.0. That's great. However, that still does imply that...
67105
Adam
s3057043
Sep 30, 2005 11:28 pm
... You write stored procedures in Firebird Look for LangRef.pdf at either www.firebirdsq.org or www.ibphoenix.com It is part of the Interbase 6 documentation,...
67106
Adam
s3057043
Sep 30, 2005 11:33 pm
... Is it a big job to convert it to a .sql script, then run it inside iSQL? I am curious as to whether it is related to your interface or whether it is...
67107
Adam
s3057043
Sep 30, 2005 11:44 pm
... Joseph, As Nick said, For / Select syntax is actually inside a language called PSQL. This language is what Firebird uses for stored procedures and ...
67108
Adam
s3057043
Sep 30, 2005 11:49 pm
... Rick, I would treat it as undetermined. There is no safe guaranteed order unless you refer to it in the order by. Obviously there will be no difference now...
67109
Adam
s3057043
Oct 1, 2005 12:12 am
... that FB2 has some good improvements over FB1.5 no ? ... Hello Toon, I have been following this thread with some interest, and I don't think the foolish...
67110
Paul Vinkenoog
neckarelzer
Oct 1, 2005 12:27 am
Hi Dan, ... You're right, it's horribly outdated. But the point is, we're *really* short of docwriters. We have a handful of people who do their best in...
67111
Helen Borrie
helebor
Oct 1, 2005 1:01 am
... You are on the right track regarding the logic of what you have to do. You are on the wrong track thinking that a script can achieve it. A script is ...
67112
dancooperstock
Oct 1, 2005 1:46 am
If I end up getting actively involved with using FireBird, I'll consider helping out. I'm a programmer, but I'm a pretty good writer too. At a minimum, someone...
67113
Helen Borrie
helebor
Oct 1, 2005 2:36 am
... There are some changes in Fb 2 to allow more flexibility in how and when Superserver does garbage collection. SS threads all client processes off a single...
67114
Helen Borrie
helebor
Oct 1, 2005 3:49 am
... There is a separate mail forum for Firebird documenters (firebird-docs, low traffic) that you can join, either as a participant (i.e., ...
