[firebird-support] Re: Using params to choose the order by fields?
> SELECT > MEMBERS.FIRST_NAME, > MEMBERS.SURNAME, > MEMBERS.MEMBERID > FROM > MEMBERS > WHERE > MEMBERS.CLUBID = :CID > ORDER BY > CASE :OBC > WHEN 1 THEN MEMBERS.SURNAME > WHEN 2 THEN MEMBERS.FIRST_NAME > END; > > > The above works, but if I put in 2 fields as below, I get an error. > > ORDER BY CASE :OBC WHEN 1 THEN MEMBERS.SURNAME WHEN 2 THEN MEMBERS.FIRST_NAME END; , CASE :OBC WHEN 1 THEN MEMBERS.FIRST_NAME WHEN 2 THEN MEMBERS.SURNAME END; -- Norbert Saint Georges http://tetrasys.fi ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Firebird-net-provider
Hi Mark, Everything worked up to the last step. After a variety of bounced emails (some with the registration in the subject), I was finally able to post a question on the website. As of today, there are no responses. When I reviewed a variety of databases two years ago, I selected Firebird because I was able to create a database and implement it with my exe (nothing else required). I liked it. Priorities redirected my efforts then. I'm a bit puzzled why others are not interested in implementing Firebird with this approach. It simplifies everything. Nothing else needs to be installed. Just run the exe. Are there any other support options? Thanks! Clyde ` On Sat, Oct 5, 2019 at 11:47 AM Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 5-10-2019 17:03, Clyde Eisenbeis cte...@gmail.com [firebird-support] > wrote: > > Sorry about that. The first email was "You are already subscribed to > > this group." The second email was a rejected message: "Could not > > validate confirmation code". > > > > I never received a confirmation code. > > It is possible that by sending your message on the 1st of October, you > were subscribed after moderator approval. > > Did you receive an email around an hour ago from the > firebird-net-provider list from Jean Lacoste with title 'Dispose error'? > If so, you are subscribed, if not, try unsubscribing and resubscribing. > > To unsubscribe and resubscribe, follow these steps: > > 1. Send an email to: > > firebird-net-provider+unsubscr...@googlegroups.com > > You should receive a mail with subject 'Unsubscribe request for > firebird-net-provider []'. > > 2. Reply to this email (don't use the 'Leave This Group' button in the > mail). > > You should receive an email with subject 'Your unsubscription to > firebird-net-provider was successful.' > > 3. Then send an email to > > firebird-net-provider+subscr...@googlegroups.com > > You should receive mail with subject 'Join request for > firebird-net-provider []' > > 4. Reply to this mail (don't use the 'Join This Group' button in the mail) > > You should receive a mail with subject 'You have joined the group > firebird-net-provi...@googlegroups.com'. > > 5. Then send an email with your question to > firebird-net-provi...@googlegroups.com > > Mark > -- > Mark Rotteveel > >
Re: [firebird-support] Firebird-net-provider
On 2019-10-08 14:18, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > Everything worked up to the last step. After a variety of bounced > emails (some with the registration in the subject), I was > finally able to post a question on the website. As of today, there > are no responses. You posted your question yesterday, you can't expect an instant turnaround for what is essentially a mailing list for users and maintainers of Firebird-net-provider. The help you get is from your peers/volunteers, so people will only answer if 1) they know the answer, 2) find it interesting to answer and 3) have time to answer. In addition, to be rather blunt, your question[1] is not really clear. That is, it is not apparent from that question that you have a problem with using Firebird Embedded from C#, nor what you already tried, what errors you get, etc. You are only repeating the questions that I already answered on this mailing list, and those questions are not directly related to what you really want to know: how to use Firebird Embedded from C#. People on that list who also follow this mailing list will likely skip it as already answered here, and for others it doesn't really invite an answer because it is not a clear question. Reading back, I did say "you should take your question to the Firebird-net-provider Google Group", but I hadn't intended it to literally post the message I was replying to verbatim to the firebird-net-provider list. Present your real problem and ask a direct question about that. Don't go off on tangents. For example, the question you asked earlier on this list (https://groups.yahoo.com/neo/groups/Firebird-support/conversations/messages/134475) would be far better to ask on the firebird-net-provider list (although I would suggest to provide a bit more details about your project, your deployment and where you put Firebird Embedded). > When I reviewed a variety of databases two years ago, I selected > Firebird because I was able to create a database and implement it with > my exe (nothing else required). I liked it. > > Priorities redirected my efforts then. > > I'm a bit puzzled why others are not interested in implementing > Firebird with this approach. It simplifies everything. Nothing else > needs to be installed. Just run the exe. Why do you think others aren't using Firebird this way, because they do. However, for a lot of applications, using Firebird server is far superior to using Firebird Embedded, because multiple applications, on multiple machines can then use the same database. > Are there any other support options? Thanks! See https://firebirdsql.org/en/support/ (which for free support will just point you to these mailing lists). You could also try Stack Overflow, but asking a question like you posted on the firebird-net-provider list will likely just get downvoted and closed as 'unclear what you're asking' or 'too broad'. And there you would be confronted with the same problem: people need to want to answer your question and have time to answer your question (writing a good answer takes a lot of time). And as I'm one of a few people answering Firebird questions there, I'm not sure how helpful that will be. [1]: https://groups.google.com/forum/#!topic/firebird-net-provider/vRSP14OIt3U
Re: [firebird-support] Firebird-net-provider
Good points. I'll re-word it. In addition, I've been spoiled by Stack Overflow => responses are often within minutes after posting the question.. Thanks! On Tue, Oct 8, 2019 at 1:36 PM Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 2019-10-08 14:18, Clyde Eisenbeis cte...@gmail.com [firebird-support] > wrote: > > Everything worked up to the last step. After a variety of bounced > > emails (some with the registration in the subject), I was > > finally able to post a question on the website. As of today, there > > are no responses. > > You posted your question yesterday, you can't expect an instant > turnaround for what is essentially a mailing list for users and > maintainers of Firebird-net-provider. The help you get is from your > peers/volunteers, so people will only answer if 1) they know the answer, > 2) find it interesting to answer and 3) have time to answer. > > In addition, to be rather blunt, your question[1] is not really clear. > That is, it is not apparent from that question that you have a problem > with using Firebird Embedded from C#, nor what you already tried, what > errors you get, etc. You are only repeating the questions that I already > answered on this mailing list, and those questions are not directly > related to what you really want to know: how to use Firebird Embedded > from C#. People on that list who also follow this mailing list will > likely skip it as already answered here, and for others it doesn't > really invite an answer because it is not a clear question. > > Reading back, I did say "you should take your question to the > Firebird-net-provider Google Group", but I hadn't intended it to > literally post the message I was replying to verbatim to the > firebird-net-provider list. > > Present your real problem and ask a direct question about that. Don't go > off on tangents. For example, the question you asked earlier on this > list > ( > https://groups.yahoo.com/neo/groups/Firebird-support/conversations/messages/134475) > > would be far better to ask on the firebird-net-provider list (although I > would suggest to provide a bit more details about your project, your > deployment and where you put Firebird Embedded). > > > When I reviewed a variety of databases two years ago, I selected > > Firebird because I was able to create a database and implement it with > > my exe (nothing else required). I liked it. > > > > Priorities redirected my efforts then. > > > > I'm a bit puzzled why others are not interested in implementing > > Firebird with this approach. It simplifies everything. Nothing else > > needs to be installed. Just run the exe. > > Why do you think others aren't using Firebird this way, because they do. > > However, for a lot of applications, using Firebird server is far > superior to using Firebird Embedded, because multiple applications, on > multiple machines can then use the same database. > > > Are there any other support options? Thanks! > > See https://firebirdsql.org/en/support/ (which for free support will > just point you to these mailing lists). You could also try Stack > Overflow, but asking a question like you posted on the > firebird-net-provider list will likely just get downvoted and closed as > 'unclear what you're asking' or 'too broad'. And there you would be > confronted with the same problem: people need to want to answer your > question and have time to answer your question (writing a good answer > takes a lot of time). And as I'm one of a few people answering Firebird > questions there, I'm not sure how helpful that will be. > > [1]: > https://groups.google.com/forum/#!topic/firebird-net-provider/vRSP14OIt3U > >
[firebird-support] Help with splitting a string in Firebird SQL
Hello All, I could use some help/direction with splitting (or extracting data between certain characters in) an existing string. This is generally a simple task in code using IndexOf, LastIndexOf, etc. but I can't seem to figure out the syntax in Firebird SQL (and it has to be done in SQL unfortunately). The string is stored in one field called "Location" and the results are being split into two columns (which are basically "ADDRESS" and "CITY"). Here is an example of the data: 202 CLARENCE RAY DR CITYNAME So far I've written this SQL (might be a better way to do this): reverse(substring(reverse(i.location) from position(' ', reverse(i.location Which returns: 202 CLARENCE RAY DR And this SQL: right(i.incident_location, position(' ', reverse(i.incident_location))) Which returns: CITYNAME I thought that I had solved the problem... Upon looking through the data for the "Location" field, I noticed that there appears to be intersections as well address information. The intersections format is where I'm encountering the most trouble. Here is an example of the intersection format: - OLD HWY 11 / - OAK GROVE RD CITYNAME I need to convert this data into a format like: OLD HWY 11 AT OAK GROVE RD in one column and CITYNAME in a second column. My right(i.incident_location, position(' ', reverse(i.incident_location))) should be sufficient for the CITYNAME, but I have no idea how to write the syntax to convert the first column. Any help would be greatly appreciated!
[firebird-support] libtommath.so.0 error for newbie
Hello everyone, I need help installing/running Firebird on Manjaro. I am absolute newbie (have no idea what I am doing) in databases and want to learn SQL. I've chosen Firebird because it can be embedded into programs or used as server-client without changes to database itself (I'll figure out later why I need that). Whenever I try to install I get this error: "fbguard: error while loading shared libraries: libtommath.so.0: cannot open shared object file: No such file or directory" This error persist when installing Firebird package downloaded from website as well as using pacman (Manjaro package manager). I have libtommath version 1.1.0-1 installed in my system. Please, does anyone know how to solve this? Thank you Saulius
[firebird-support] Off-Topic: Firebird future
Hello everyone, I've been using FB since version 1 and I have only good comments about the database quality and performance. However, It's true that the development has evolved too slow and we had to wait almost 10 years since the first release to get a real SMP support (I know that's tricky since for Linux and classic was not a problem) and we were far behind the competitors MySQL and PgSQL. In the meantime the great team was improving the database, MySQL and PgSQL have won a lot of user base because they evolved faster adding new features like XML support, JSON, NoSQL engines, etc. into their database core. Some of those features look far away from the Firebird next versions. Also, today I was looking for a Flamerobin updated version but the project seens abandoned. I mean, flamerobin is a really cool tool but nobody is helping its developers to keep it updated. Some of you can blame that everyone should be able to create code for the project, but that's not true, a project needs engagement to develop, knowledge of the language, etc. So it's not easy to add developers (and more difficult if they don't see cool features out of the box). Basically, if you want a management tool updated you need to go to commercial. So, my point is, the current Firebird develepment model is not delivering features as the market requires, there is not a gui management tool once you install the software, all the cool features are commercial. If you install MySQL, after the installation you will get a DBMS with GUI for management, encryption, replication out of the box since many years ago, all drivers for developers if desired, extensive support from Cloud providers, and a lot of features that make it a very functional tool out of the box. Also PgSQL offers many of these features out of the box for free. I know the Firebird model offers to many Companies to sell those missing tools, but to be honest, if your competitors offer the same for free you will go for them. In my last project I used MySQL because it has wide support in the cloud providers, offering Database as a Service, replication, encryption, an integrated GUI out of the box and other features. In the next project I will be using PgSQL for similar reasons. I'm asking myself how much time I'll still be using Firebird if the project evolves slow, there is not GUI officially maintened and the cool features are for the commercial companies. I don't want to start a flame, those are only my personal thoughs regarding the Firebird future. If nothing changes, we could see some users and developers moving to other DBMS for sure... and we have not talked about NoSQL competitors yet... You are the genius, I hope you will figure out how to keep this great project alive. Best regards,
Re: [firebird-support] Scaling Firebird - Azure
Using Azure is a little bit tricky with any database. Since FB doesn't have DBaaS support from any Cloud provider that I know you will need to go only for VM or containers for your deployment. If you google for "firebird performance tuning" you will find some interesting articles:https://firebirdsql.org/en/news/presentations-from-firebird-tour-2017-tuning-linux-and-windows/https://www.firebirdsql.org/en/news/45-ways-to-speed-up-firebird-database/ Regards, ___ I'm free, I use GNU/Linux. Close your Windows, Open your mind. El domingo, 6 de octubre de 2019 17:20:14 GMT-5, Rune Horneland rune.hornel...@kravia.net [firebird-support] escribió: Hi,We are running Firebird 2 in an Azure VM. It can only take so much in terms of concurrent connections.What top-level advice would you give to scale this? We are connecting to it from a .NET core Middleware using Azure VMs.The architecture of the middleware is quite monolithic. We are considering rewriting it with Microservices and Azure functions or similar architecure, but are unsure how we could scale the Firebird DB or connections itself.Multiple casehandlers in our company use it via a Delphi-based Windows application at the other end, with a vendor maintaining the Firebird DB and Windows app development, so we are locked into using Firebird. RUNEHORNELAND CTO
Re: [firebird-support] Scaling Firebird - Azure
Hello, In short words, Azure sucks, its so called Premium SSD is worse than the cheapest consumer grade ssd. Try Google Cloud or Amazon, or Hetzner. Regards, Alexey Kovyazin IBSurgeon пн, 7 окт. 2019 г., 0:20 Rune Horneland rune.hornel...@kravia.net [firebird-support] : > > > Hi, > We are running Firebird 2 in an Azure VM. It can only take so much in > terms of concurrent connections. > What top-level advice would you give to scale this? > > We are connecting to it from a .NET core Middleware using Azure VMs. > The architecture of the middleware is quite monolithic. We are considering > rewriting it with Microservices and Azure functions or similar architecure, > but are unsure how we could scale the Firebird DB or connections itself. > Multiple casehandlers in our company use it via a Delphi-based Windows > application at the other end, with a vendor maintaining the Firebird DB and > Windows app development, so we are locked into using Firebird. > > > *RUNE HORNELAND*CTO > > >