Re: [firebird-support] help with stored procedure: SYNTAX error
On Fri, Jun 8, 2012 at 7:37 AM, ktadimeti tadimetikes...@yahoo.com wrote:
**
Dear List
Please help me understand where I am going wrong with creating the
following procedure:
SET TERM ^ ;
CREATE PROCEDURE TestProc
( CatName CHAR(15) )
AS
BEGIN
select cast('Now' as time) as TIME from rdb$database;
END^
SET TERM ; ^
Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 7, column 57
;
Firebird 2.5.1 on Windows (SuperClassic)
Many thanks
Hi there,
Your stored procedure does nothing. If you want to return a time you could
try the following:
SET TERM ^ ;
create or alter procedure TEST_TIME
returns (
the_time time)
as
begin
the_time = Current_Time;
end^
SET TERM ; ^
[Non-text portions of this message have been removed]
Re: [firebird-support] Firebird backup automatically
On Tue, Jan 3, 2012 at 4:58 AM, Mahesh Pratihari mahesh.pratih...@sonata-software.com wrote: ** Hi, Could you please let me know how to take the backup in firebird automatically like sql server maintenance plan. Thanks, Mahesh Pratihari Sonata Software Limited Phone : +91 80 3097 1527 Mobile : +91 99808 37446 www.sonata-software.com http://www.sonata-software.com Please don't print this email unless you really need to. This will preserve trees on our planet. Mahesh, If your server is a Windows computer I have written a Firebird backup manager program that needs some testing. You can email me at tcla...@cybersea.biz if you would like to try the program. It schedules backups using gbak and takes care of naming the backup files as well as zipping them up. It also sends an email on completion. It will backup multiple databases as well. Let me know? Thomas Clarke Cyber Sea Incorporated #6 Kingston Terrace Flint Hall St. Michael Barbados BB11070 voice: (246) 234-9692 email: tcla...@cybersea.biz web: http://cybersea.biz [Non-text portions of this message have been removed]
[firebird-support] Firebird database comparison tool.
Hello to all on the list. I am in the process of writing an application to update a program I have written that is coming out on the market shortly. The update will be delivered via the Internet. It is broken down into two major parts, i) update the exe file based on version numbers and ii) update the Firebird database structure. It is the second part that got me thinking, I can use a difference script to update the database structure. But I would like to write a program that would compare the structure of the application database and a reference database and update the application database based on the differences. I see that Clever components have a Delphi VCL component that does just this but I wonder how easy or hard would it be to write a program to do just this. The application depends heavily on stored procedures for the business logic. One of the complexities will be the source for stored procedures and triggers is encrypted so that prying eyes cannot easily see the coding logic (I know this is not fool proof but good enough). During the comparison process these can be decrypted and then encrypted again later on. How would I go about writing a program to update a database from a reference database. 1. For domains I could query the rdb$domains table. 2. Similarly tor triggers and stored procedures I could do a similar thing. 3. But what about tables, columns, constraints and domains? Any ideas as to the best way to go about this? I think this would also be a good project to open source. I am thinking I would write the application in Delphi but once the algorithm is figured out it could be ported to any language that can connect to a Firebird database. Any thoughts are welcome. Thomas Clarke Cyber Sea Incorporated #6 Kingston Terrace Flint Hall St. Michael Barbados BB11070 voice: (246) 234-9692 email: tcla...@cybersea.biz web: http://cybersea.biz [Non-text portions of this message have been removed]
[firebird-support] Firebird database comparison tool.
Hello to all on the list. I am in the process of writing an application to update a program I have written that is coming out on the market shortly. The update will be delivered via the Internet. It is broken down into two major parts, i) update the exe file based on version numbers and ii) update the Firebird database structure. It is the second part that got me thinking, I can use a difference script to update the database structure. But I would like to write a program that would compare the structure of the application database and a reference database and update the application database based on the differences. I see that Clever components have a Delphi VCL component that does just this but I wonder how easy or hard would it be to write a program to do just this. The application depends heavily on stored procedures for the business logic. One of the complexities will be the source for stored procedures and triggers is encrypted so that prying eyes cannot easily see the coding logic (I know this is not fool proof but good enough). During the comparison process these can be decrypted and then encrypted again later on. How would I go about writing a program to update a database from a reference database. 1. For domains I could query the rdb$domains table. 2. Similarly tor triggers and stored procedures I could do a similar thing. 3. But what about tables, columns, constraints and domains? 4. Views, UDF's etc. Any ideas as to the best way to go about this? I think this would also be a good project to open source. I am thinking I would write the application in Delphi but once the algorithm is figured out it could be ported to any language that can connect to a Firebird database. Any thoughts are welcome. Thomas Clarke Cyber Sea Incorporated #6 Kingston Terrace Flint Hall St. Michael Barbados BB11070 voice: (246) 234-9692 email: tcla...@cybersea.biz web: http://cybersea.biz [Non-text portions of this message have been removed]
Re: [firebird-support] SQLSTATE 28000
Raymond, To connect through isql the command is: connect ''h:\KKR.FDB' user 'sysdba' password 'masterkey'; You have left out the user name and password. Thomas. On Sat, Oct 8, 2011 at 9:07 AM, raym...@ymail.com raym...@ymail.com wrote: ** Hello, This is my first time trying to use Firebird. I am required by a client to write an application that extract data from Firebird. Here is what I have done so far: 1. I copied the .FDB file from my client's live application 2. Installed Firebird 3. Tried to access the database using ISQL: connect 'h:\KKR.FDB'; And it returned: Statement failed, SQLSTATE = 28000 Your user name and password are not defined. Ask your database administrator to set up a Firebird login. What am I missing? Any help would be great. Thanks. Raymond -- Thomas Clarke Cyber Sea Incorporated #6 Kingston Terrace Flint Hall St. Michael Barbados BB11070 voice: (246) 234-9692 email: tcla...@cybersea.biz web: http://cybersea.biz [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) * To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
