AW: [firebird-support] sql query in firebird
Hello Sean Thanks a lot! Unfortunately the gemini interbase odbc driver works not with this union query. Even not if I create 3 single queries and call this in a union query. Is there an easy way to put them into a stored procedure without duplicates? Then I can get the return values by calling this stored procedure. Thank you. SELECT a.empf_sbnr, b.email FROM tbestellungen a join tsachbearbeiter b on a.empf_sbnr = b.sbnr WHERE a.status = 1 and b.email is not null UNION SELECT b.bauleiter as sbnr, e.email FROM tprojekte b join tsachbearbeiter e on b.bauleiter = e.sbnr JOIN tbestellungen a ON b.kommisionsnr = a.kommisionsnr and b.auftrag = a.auftrag where e.email is not null UNION SELECT c.sbnr, f.email FROM tprojversand c join tsachbearbeiter f on c.sbnr = f.sbnr JOIN tbestellungen a ON c.kommisionsnr = a.kommisionsnr and c.auftrag = a.auftrag where f.email is not null [Non-text portions of this message have been removed]
AW: [firebird-support] sql query in firebird
Hello again, now I have test it with a pass through query and it works! Thanks! Hello Sean Thanks a lot! Unfortunately the gemini interbase odbc driver works not with this union query. Even not if I create 3 single queries and call this in a union query. Is there an easy way to put them into a stored procedure without duplicates? Then I can get the return values by calling this stored procedure. Thank you. SELECT a.empf_sbnr, b.email FROM tbestellungen a join tsachbearbeiter b on a.empf_sbnr = b.sbnr WHERE a.status = 1 and b.email is not null UNION SELECT b.bauleiter as sbnr, e.email FROM tprojekte b join tsachbearbeiter e on b.bauleiter = e.sbnr JOIN tbestellungen a ON b.kommisionsnr = a.kommisionsnr and b.auftrag = a.auftrag where e.email is not null UNION SELECT c.sbnr, f.email FROM tprojversand c join tsachbearbeiter f on c.sbnr = f.sbnr JOIN tbestellungen a ON c.kommisionsnr = a.kommisionsnr and c.auftrag = a.auftrag where f.email is not null [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[firebird-support] Forced Write turning off
We recently had database corruptions and had turned on forced write on our databases on windows environment but we found that after we run our client application gstat was no more showing the forced write status. We are using Delphi and IBO components but not sure what in the application is resetting this status. Has anyone come across this problem or know what could be doing this. thanks
Re: [firebird-support] Forced Write turning off
We recently had database corruptions and had turned on forced write on our databases on windows environment but we found that after we run our client application gstat was no more showing the forced write status. We are using Delphi and IBO components but not sure what in the application is resetting this status. Has anyone come across this problem or know what could be doing this. Yes. What IBO version are you using? AFAIR older IBO versions can switch the TIB_Connection.ForcedWrites property from dpbDefault to something else by accident, e.g. dpbFalse, when you double-click the TIB_Connection component to open the connection editor and switch to the characteristic tab (or even without that) Check out the ForcedWrites property before deploying the application. -- With regards, Thomas Steinmaurer http://www.upscene.com/
[firebird-support] Inconsistency issue in FB 1.56
I backed up a (FB 1.56) database on my server and am trying to restore it on my local machine. I get the following error message in IB Expert: Error Message Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements. action cancelled by trigger (1) to preserve data integrity. could not find column for GRANT. /Error Message ouch... I don't know how to find where this is any suggestions are certainly welcomed. Ed Dressel
[firebird-support] How to migrate to new database Server?
I have a Delphi web Server application using Firebird 1.5 as backend database. I am thinking about updating to new server. Few questions: 1. Could I install Firebird2 64 bits on a database server and access to the database from 32 bits web application on another machine? 2. What is the process to convert Firebird 1.5 database to Firebird 2 database? Your insights are greatly appreciated. jw
[firebird-support] connection rejected after first installation on Mac OS 10.7.5
I installed FirebirdSS-2.5.2-26539-lipo-x86_64.pkg.zip http://sourceforge.net/projects/firebird/files/firebird-MacOS-X_darwin/2.5.2-Release/FirebirdSS-2.5.2-26539-lipo-x86_64.pkg.zip/download I unzipped the package and double clicked on the icon and successfully installed the program. However, when I try to set up a password I get this error: sudo gsec -user sysdba -password masterkey use gsec -? to get help connection rejected by remote interface unable to open database If I do ps aux | grep fb I get nothing. Also: ps aux | grep fbserver also gives me nothing. If I try to start the server with fbserver I get this message: Unable to complete network request to host CYNTHIAs-MacBook-Pro.local I have tried every binary provided on the downloads page, including both 32 and 64 bit, and get the same error. Thanks! Paul [Non-text portions of this message have been removed]
Re: [firebird-support] How to migrate to new database Server?
1. Could I install Firebird2 64 bits on a database server and access to the database from 32 bits web application on another machine? Yes. 2. What is the process to convert Firebird 1.5 database to Firebird 2 database? Make a backup on the old (FB1.5) server. Uninstall the old server. Install the new server. Restore the backup on the new server. Check all of your functionality for new bugs. Upgrading from FB1.5, you need to deal with the fact that the old TIMESTAMPs only used seconds precision while they use miliseconds in FB2. Some language constructs which were valid (though suspect) in FB1.5 no longer work in FB2 (e.g. duplication of columns in INSERT, and I think in UPDATE too). Josef ++ 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/
RE: [firebird-support] Inconsistency issue in FB 1.56
Look at the system tables. Don't know if it works on Fb 1.5, but I'd try something like select * from rdb$user_privileges u where u.rdb$field_name is not null and not exists(select * from rdb$relation_fields rf where u.rdb$relation_name = rf.rdb$relation_name and u.rdb$field_name = rf.rdb$field_name) HTH, Set -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Ed Dressel Sent: 12. februar 2013 22:03 To: firebird-support@yahoogroups.com Subject: [firebird-support] Inconsistency issue in FB 1.56 I backed up a (FB 1.56) database on my server and am trying to restore it on my local machine. I get the following error message in IB Expert: Error Message Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements. action cancelled by trigger (1) to preserve data integrity. could not find column for GRANT. /Error Message ouch... I don't know how to find where this is any suggestions are certainly welcomed. Ed Dressel