Subject RES: [firebird-support] How exclude souce code (Triggers and Stored Procedure) from Firebird ?
Author Gerson Machado - Yahoo
Hans Tks, I was try update RDB$ table com my console, EMS, but i can't.

So... now I try to use isql direct in my server.. but I try like this
SQL> CONNECT -u SYSDBA -p masterkey DBPHARMA40
CON>

see i try several commands but I receive CON> prompt what is wrong

Tks

Gerson



-----Mensagem original-----
De: Gerson Machado - Yahoo [mailto:gersonamach@...]
Enviada em: domingo, 28 de novembro de 2004 18:59
Para: firebird-support@yahoogroups.com
Assunto: RES: [firebird-support] How exclude souce code (Triggers and
Stored Procedure) from Firebird ?


Yes I did but I still see my SP and Trigger...

I unconnect and connect my database... and still see ...

May I reverse from BLR to Source code my stored procedures or triggers ?

Tks

Gerson


-----Mensagem original-----
De: Hans Hoogstraat [mailto:hhoogstraat@...]
Enviada em: domingo, 28 de novembro de 2004 18:48
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] How exclude souce code (Triggers and
Stored Procedure) from Firebird ?


Maybe:

update rdb$procedures set rdb$procedure_source = null

or

update rdb$procedures set rdb$procedure_source = 'Property of Gerson
Machado'

----- Original Message -----
From: "Gerson Machado - Yahoo" <gersonamach@...>
To: <firebird-support@yahoogroups.com>
Sent: Sunday, November 28, 2004 1:25 PM
Subject: [firebird-support] How exclude souce code (Triggers and Stored
Procedure) from Firebird ?


|
| I need exclude all source code from my database.
| May I reverse stored procedure and triggers from database if I have
only
| compiled version (BLR) ?
|
| What I need to do ?
|
| Tks
|
| Gerson
|
|
|
| --
| No virus found in this outgoing message.
| Checked by AVG Anti-Virus.
| Version: 7.0.289 / Virus Database: 265.4.3 - Release Date: 26/11/2004
|
|
|
| [Non-text portions of this message have been removed]
|
|
|
|
|
| Yahoo! Groups Links
|
|
|
|
|
|
|



Yahoo! Groups Sponsor

ADVERTISEMENT
HYPERLINK
"HYPERLINK
"http://us.ard.yahoo.com/SIG=1294uq7kj/M=298184.5639630.6699735.3001176/
"http://us.ard.yahoo.com/SIG=1294uq7kj/M=298184.5639630.6699735.3001176/
D=groups/S=1705115386:HM/EXP=1101761358/A=2434970/R=0/SIG=11edksnhv/*htt
p://www.netflix.com/Default?mqso=60185402"click here
HYPERLINK
"HYPERLINK
"http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
"http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2434970/rand=263655260"


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
HYPERLINK
"HYPERLINK
"http://groups.yahoo.com/group/firebird-support/"http://groups.yahoo.com
/group/firebird-support/"HYPERLINK
"http://groups.yahoo.com"http://groups.yahoo.com
/group/firebird-support/


* To unsubscribe from this group, send an email to:
HYPERLINK
"mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe
"firebird-support-unsubscribe@yahoogroups.com


* Your use of Yahoo! Groups is subject to the HYPERLINK
"HYPERLINK
"http://docs.yahoo.com/info/terms/"http://docs.yahoo.com/info/terms/"Yah
oo! Terms of Service.



--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.289 / Virus Database: 265.4.3 - Release Date: 26/11/2004



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.289 / Virus Database: 265.4.3 - Release Date: 26/11/2004



[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

ADVERTISEMENT
HYPERLINK
"http://us.ard.yahoo.com/SIG=129bjgnue/M=298184.5639630.6699735.3001176/
D=groups/S=1705115386:HM/EXP=1101761924/A=2434971/R=0/SIG=11eeoolb0/*htt
p://www.netflix.com/Default?mqso=60185400"click here
HYPERLINK
"http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2434971/rand=775207953"


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
HYPERLINK
"http://groups.yahoo.com/group/firebird-support/"http://groups.yahoo.com
/group/firebird-support/


* To unsubscribe from this group, send an email to:
HYPERLINK
"mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe
"firebird-support-unsubscribe@yahoogroups.com


* Your use of Yahoo! Groups is subject to the HYPERLINK
"http://docs.yahoo.com/info/terms/"Yahoo! Terms of Service.



--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.289 / Virus Database: 265.4.3 - Release Date: 26/11/2004



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.289 / Virus Database: 265.4.3 - Release Date: 26/11/2004



[Non-text portions of this message have been removed]