Re: [firebird-support] How do I limit an SQL search list to 10 records?
Good clarification. Any downside to using an auto increment number? ``` fiKeyID INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY ``` On Fri, Dec 13, 2019 at 12:15 PM Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 13/12/2019 19:07, Clyde Eisenbeis cte...@gmail.com [firebird-support] > wrote: > > Is a field I create, or is it part of all records? > > It is a field you create. Which is why I wrote "Where is the > table in question, and is a suitable column (eg a timestamp) > to determine what the newest record is." > > You might be able to use the pseudo-column RDB$RECORD_VERSION, but that > is not necessarily in the right order of recency, because the value is > the transaction-number that wrote the last version of the record. This > means that updates to a record will also make it 'recent' and a record > written by a long-running transaction might not show up as 'recent' (or > at least as older than it may actually be). > > Mark > -- > Mark Rotteveel > >
Re: [firebird-support] How do I limit an SQL search list to 10 records?
Is a field I create, or is it part of all records? On Fri, Dec 13, 2019 at 12:04 PM Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 13/12/2019 16:48, Clyde Eisenbeis cte...@gmail.com [firebird-support] > wrote: > > One table contains history. The old history is never replaced. New > > history is added. What is relevant is the most recent history. Is there > > a way to find the newest records without the KeyID? > > Yes, you do > > SELECT * > FROM > ORDER BY DESC > FETCH NEXT 10 ROWS ONLY > > Where is the table in question, and is a suitable > column (eg a timestamp) to determine what the newest record is. > > If you want that result in ascending order of time, then you need to add > another order by: > > SELECT * > FROM ( > SELECT * > FROM > ORDER BY DESC > FETCH NEXT 10 ROWS ONLY > ) a > ORDER BY ASC > > Or you can use ROW_NUMBER, although that is probably less efficient: > > SELECT * > FROM ( > SELECT .*, > ROW_NUMBER OVER (ORDER BY DESC) AS ROWNR > FROM > ) a > ORDER BY ASC > WHERE ROWNR < 10 > > Mark > -- > Mark Rotteveel > >
Re: [firebird-support] How do I limit an SQL search list to 10 records?
One table contains history. The old history is never replaced. New history is added. What is relevant is the most recent history. Is there a way to find the newest records without the KeyID? On Fri, Dec 13, 2019 at 8:58 AM Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 2019-12-13 12:48, Clyde Eisenbeis cte...@gmail.com [firebird-support] > wrote: > > I added the KeyID so I could sort from newest to oldest. Was it > > necessary to add this KeyID, or is there another way to find the > > newest records without the KeyID? > > That depends on what you're trying to achieve, what data you have and > what results you want. > > Mark > >
Re: [firebird-support] How do I limit an SQL search list to 10 records?
I added the KeyID so I could sort from newest to oldest. Was it necessary to add this KeyID, or is there another way to find the newest records without the KeyID? On Fri, Dec 13, 2019 at 2:05 AM Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 2019-12-13 08:14, Kjell Rilbe kjell.ri...@marknadsinformation.se > [firebird-support] wrote: > > Den 2019-12-12 kl. 22:36, skrev Clyde Eisenbeis cte...@gmail.com > > [firebird-support]: > >> Marcin, Minor tweak => works! I also added DESC to retrieve the > >> newest records using the field key name (number is an auto increment). > >> ` > >> "SELECT FIRST " + stNumOfRecordsToRetrieve + " * FROM " + stTableName > >> + " ORDER BY " + fstKeyID + " DESC"; > >> ` > >> It's interesting that the newest records are found first (DESC), then > >> the number of records retrieved are from those DESC record results.. > > > > > > Yes, the "subset clause" is applied last of all, so specified ordering > > will be respected. > > > > Unless I'm mistaken, FIRST N is Firebird specific. The SQL standard > > syntax for this is: > > > > SELECT * > > FROM T > > ORDER BY YOUR_KEY DESC > > ROWS N; > > > > where N would be the number of rows to retrieve. You also have: > > > > SELECT * > > FROM T > > ORDER BY YOUR_KEY DESC > > ROWS N TO M; > > > > which will retrieve records N, N+1, N+2, ..., M. Useful for pagination > > and not supported, as far as I know, by the Firebird specific syntax. > > The SQL standard (SQL:2008 and higher) clause is [FETCH][1] which was > added in Firebird 3. ROWS is also a Firebird specific invention, or it > might have been something that was in a SQL standard draft, but never > made it in a final standard. > > The SQL Standard OFFSET/FETCH combination is IMHO better, though the > same result can be achieved with the non-standard FIRST and SKIP. > > [1]: > > https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/bk02ch09s06.html#rnfb30-dml-offsetfetch > >
Re: [firebird-support] How do I limit an SQL search list to 10 records?
Marcin, Minor tweak => works! I also added DESC to retrieve the newest records using the field key name (number is an auto increment). ` "SELECT FIRST " + stNumOfRecordsToRetrieve + " * FROM " + stTableName + " ORDER BY " + fstKeyID + " DESC"; ` It's interesting that the newest records are found first (DESC), then the number of records retrieved are from those DESC record results. ` On Thu, Dec 12, 2019 at 1:29 PM 'Marcin Bury' marcin.b...@studio-delfi.pl [firebird-support] wrote: > > > Hi > > SELECT FIRST 10 * FROM A_TABLE > > Should work > > Cheers > Marcin > > > ------ Wiadomość oryginalna -- > Od: "Clyde Eisenbeis cte...@gmail.com [firebird-support]" < > firebird-support@yahoogroups.com> > Do: firebird-support@yahoogroups.com > Data: 12.12.2019 19:59:44 > Temat: [firebird-support] How do I limit an SQL search list to 10 records? > > This finds all records: > `` > "SELECT * FROM " + stTableName > `` > This does not work: > > `` > "SELECT * FROM " + stTableName + " FETCH 10 ROWS" > `` > > >
[firebird-support] How do I limit an SQL search list to 10 records?
This finds all records: `` "SELECT * FROM " + stTableName `` This does not work: `` "SELECT * FROM " + stTableName + " FETCH 10 ROWS" ``
Re: [firebird-support] What key word specifies a search for an entire word?
Mark, You're right. My brain was asleep. I've been using OR. Had never tried AND. Karol, Thanks for clarifying. On Sat, Nov 30, 2019 at 5:10 AM Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > >>Not sure what pattern is. > > > > Pattern replace unknown leter(s) sumbols are „%” multiple letters, „_” > single letter > > e.g. > > ‘Ne%flix’ will find Neflix, Netflix, Netflix …. > > > > >>I prefer the word LIKE. Is easier to avoid errors vs. using '='. Are > there advantages to using '='? > > > > If you use like with param Firebird cannot use index on field firstName or > e.g. expression index Upper(firstName) > > > > As your param have unknown value. It can be ‘Netflix’ or ‘%Netflix’, or > whatever > > But if you use „=” it simply can use index if such exists. > > > > Regards, > > Karol Bieniaszewski. > > >
Re: [firebird-support] What key word specifies a search for an entire word?
The fstName is the column title, not the value. I'm using embedded Firebird. On Fri, Nov 29, 2019 at 3:48 PM Richard Damon rich...@damon-family.org [firebird-support] wrote: > > > On 11/29/19 4:32 PM, Clyde Eisenbeis cte...@gmail.com [firebird-support] > wrote: > > > > Not sure what pattern is. If I am searching for two words I use OR or > > AND. > > > > "SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE lower( > > @p0 ) AND lower(fstName) LIKE lower( @p1 ) " > > > > I prefer the word LIKE. Is easier to avoid errors vs. using '='. Are > > there advantages to using '='? > > > LIKE, because it is designed as a partial match, can't use a normal > index, so often ends up doing a table scan. > > = since it only matches the full field, can easily use an index, and if > an appropriate index is available, can avoid scanning the whole table. > > Also, in your above sample, fstName needs to match BOTH p0 and p1, which > isn't usual unless you are looking for the presence of both of two > strings in any order. > > -- > Richard Damon > > >
Re: [firebird-support] What key word specifies a search for an entire word?
Not sure what pattern is. If I am searching for two words I use OR or AND. "SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE lower( @p0 ) AND lower(fstName) LIKE lower( @p1 ) " I prefer the word LIKE. Is easier to avoid errors vs. using '='. Are there advantages to using '='? ``` On Fri, Nov 29, 2019 at 12:40 PM Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Do you use pattern or simple string? > > If it is simple string then better is using „=” instead of like. > > > > "SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) = lower( @p0 )" > > > > Regards, > > Karol Bieniaszewski > > >
Re: [firebird-support] What key word specifies a search for an entire word?
Changing this
"SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE lower('%'
|| @p0 || '%')"
to this
"SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE lower( @p0
)"
works!
On Fri, Nov 29, 2019 at 12:53 AM Kjell Rilbe
kjell.ri...@marknadsinformation.se [firebird-support] <
firebird-support@yahoogroups.com> wrote:
>
>
> Den 2019-11-28 kl. 17:30, skrev cte...@gmail.com [firebird-support]:
> > I have this:
> >
> > "SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE
> > lower('%' || @p0 || '%')"
> >
> > Assume fstName includes "Richard" and "Rich". If I search for "Rich"
> > it finds both names.
> >
> > What do I modify so it finds only "Rich"?
>
>
> I usually solve that kind of problem like this:
>
> SELECT fstName, fiKeyID FROM Members WHERE ' ' || lower(fstName) || ' '
> LIKE lower('% ' || @p0 || ' %')
>
> Note that I add a leading and a trailing space to the searched string,
> and also to the sought string (inside the % wildcards). This will ensure
> that it finds the sought string only if it's surrounded by spaces, and
> will also find it at the beginning and at the end of the searched
> string, since we added spaces there.
>
> The downside is that no index can be used for this search, but that's
> probably true with other approaches too.
>
> An alternative could be:
>
> SELECT fstName, fiKeyID FROM Members
>
> WHERE lower(fstName) LIKE lower(@p0 || ' %') -- At the start? Note space
> before %
> OR lower(fstName) LIKE lower('% ' || @p0) -- At the end? Note space
> after %
> OR lower(fstName) LIKE lower('% ' || @p0 || ' %') -- In the middle?
> Note spaces inside %
>
> Regards,
> Kjell
>
>
> [Non-text portions of this message have been removed]
>
>
>
Re: [firebird-support] What key word specifies a search for an entire word?
This works:
"SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE lower( @p0
)"
On Thu, Nov 28, 2019 at 11:09 AM Richard Damon rich...@damon-family.org
[firebird-support] wrote:
>
>
> On 11/28/19 11:30 AM, cte...@gmail.com [firebird-support] wrote:
> >
> > I have this:
> >
> > "SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE
> > lower('%' || @p0 || '%')"
> >
> > Assume fstName includes "Richard" and "Rich". If I search for "Rich"
> > it finds both names.
> >
> > What do I modify so it finds only "Rich"?
>
> if you only want the case that fstName is exactly Rich, then don't use
> like but use equals (=)
>
> If you want Rich as part of the string but not Richard, what is allowed
> before/after Rich that makes it a 'word'?
>
> --
> Richard Damon
>
>
>
Re: [firebird-support] What is the optimum pageSize?
This is very useful info!!! On Fri, Nov 15, 2019 at 5:13 AM Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 15.11.2019 11:58, jerz...@o2.pl [firebird-support] wrote: > > What is the max record size in FB3 (in bytes)? > > I search for this information without success. > >https://firebirdsql.org/en/firebird-technical-specifications/ > > > -- >WBR, SD. > > > > > > > ++ > > 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 > > > >
Re: [firebird-support] Re: What is the optimum pageSize?
Thanks for clarifying! This is very useful info, especially the ibexpert.net site. Is there a Firebird site that provides details such as CHAR and VARCHAR max sizes, pageSize size options, etc.? ``` On Thu, Nov 14, 2019 at 5:07 PM Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 14.11.2019 23:47, blackfalconsoftw...@outlook.com [firebird-support] > wrote: > > Doesn't the page size definition as per a database depend on one designs > their database > > tables and how such tables will be used? > >Cases when pages of smaller size have a speed advantage are very > special and most of > database developers won't ever hit them. In common case small pages cause > slowdown. > > > -- >WBR, SD. > > > > > > > ++ > > 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 > > > >
Re: [firebird-support] What is the optimum pageSize?
What is the max page size for Firebird 3? Also, could you clarify a page? Does each record consume a page, or are could there be multiple records on a page? ` On Thu, Nov 14, 2019 at 8:09 AM Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 14.11.2019 13:41, cte...@gmail.com [firebird-support] wrote: > > Assume I have two fields => "stFixed CHAR(10)" and "stVar VARCHAR(8191) > CHARACTER SET > > UTF8" --- what is the optimum pageSize? > >Optimum page size doesn't depend on data but on application usage. > >I can repeat once again: make page size as big as your Firebird version > allow you. > > > -- >WBR, SD. > > > > > > > ++ > > 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 > > > >
Re: [firebird-support] Re: What are the trade-offs of CHAR vs. VARCHAR?
For a minor clarification. In the electronics world, we specify the sequence of multiple bytes with the word "Endian". Assume the hex number is 0x1A2B. For Big Endian, the 0x1A is first. For Little Endian, the 0x2B is first. The previous comments indicate that Firebird is Litle Endian. (For serial communication we also specify the bit order, LSB or MSB, which is transparent to most folks). On Thu, Nov 14, 2019 at 2:39 PM Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 14.11.2019 20:29, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] > wrote: > > And that part of the documentation is unfortunately wrong (although I'm > > not sure why the language reference even cares to describe such an > > implementation detail). > >This documentation is actively corrected and it is better to read > latest versions > directly from source: > > https://github.com/sim1984/langref25 > https://github.com/sim1984/langref30 > >Google Translate at least won't add anything strange from the blue sky. > > -- >WBR, SD. > > > > > > > ++ > > 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 > > > >
Re: [firebird-support] What are the trade-offs of CHAR vs. VARCHAR?
Thanks for the useful responses! Assume I have two fields => "stFixed CHAR(10)" and "stVar VARCHAR(8191) CHARACTER SET UTF8" --- what is the optimum pageSize? ``` On Wed, Nov 13, 2019 at 6:17 AM Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > > > > > > On Nov 12, 2019, at 10:44 PM, Richard Damon rich...@damon-family.org > [firebird-support] wrote: > > > >> On 11/12/19 12:38 PM, cte...@gmail.com [firebird-support] wrote: > >> > >> > >> What are the trade-offs of CHAR vs. VARCHAR? I know that VARCHAR > >> consumes less space. Anything thing else (are VARCHAR searches slower)? > >> > > In some implementations of SQL (I don't know if firebird is one of > > them), a row without any variable length items (like VARCHAR) and thus > > of fixed length could be stored in a somewhat optimized way making its > > access somewhat faster because all the records were the same size. > > In Firebird all records are compressed on disk. > > > > VARCHAR also doesn't always take less space, as very short CHAR fields > > can be smaller than the overhead of a VARCHAR, and if the CHAR field is > > storing a value that is always the same length (like maybe a hash code) > > the overhead of VARCHAR is just wasted. > > > > -- > > Richard Damon > > > > > > > > > > Posted by: Richard Damon > > > > > > ++ > > > > 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 > > > > > > > >
Re: [firebird-support] What are the trade-offs of CHAR vs. VARCHAR?
As I understand, the FbConnection.CreateDatabase max pageSize for VARCHAR is 8191. Does the page size change to less than 8191 if the VARCHAR is less? What is the max pageSize for CHAR? On Tue, Nov 12, 2019 at 1:15 PM Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 12.11.2019 18:38, cte...@gmail.com [firebird-support] wrote: > >I know that VARCHAR consumes less space. > >It doesn't. CHAR has no advantages over VARCHAR in most usages. Only > very little cases > need fixed length data (and usually it is binary data). > > > -- >WBR, SD. > > > > > > > ++ > > 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 > > > >
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 > >
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
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. `` On Sat, Oct 5, 2019 at 8:46 AM Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 4-10-2019 23:22, Clyde Eisenbeis cte...@gmail.com [firebird-support] > wrote: > > Attached are my latest email messages from firebird-net-provider. I never > > received a confirmation code. Now what? > > This list doesn't support attachments. So it is still not clear to me if > you sent an empty message to > firebird-net-provider+subscr...@googlegroups.com or just tried to mail > to firebird-net-provi...@googlegroups.com > > In any case, I see an email of yours dated the 1st of October has > appeared on the firebird-net-provider list yesterday (which might > indicate it was waiting for moderator approval). Given your question is > only "Is there a group for Firebird Embedded?", there is a chance you > won't get a reply there. > > In any case, there is no list specifically for Firebird Embedded. And if > you have a problem with C# and Firebird Embedded or need help using it > from C#, you really need to ask a more specific question with more > details on the firebird-net-provider list (not here). > > Mark > -- > Mark Rotteveel > >
Re: [firebird-support] Firebird-net-provider
I'll try again. I did not receive an approval email. ` On Fri, Oct 4, 2019 at 12:03 PM Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 4-10-2019 15:39, Clyde Eisenbeis cte...@gmail.com [firebird-support] > wrote: > > > > > > Yesterday, I sent an email to > <mailto:firebird-net-provi...@googlegroups.com>> =>"I'm wondering if I > > subscribed correctly?" > > > > I have not received a response. Any suggestions? I would like to start > > code writing for a Firebird database. > > Did you subscribe first by sending an email to > firebird-net-provider+subscr...@googlegroups.com and responding to the > confirmation mail? > > It is also possible that your mail is waiting for approval (I'm not sure > if moderator approval is applied for new subscribers). > > Mark > > > On Thu, Oct 3, 2019 at 11:40 AM Mark Rotteveel m...@lawinegevaar.nl > > <mailto:m...@lawinegevaar.nl> [firebird-support] > > > <mailto:firebird-support@yahoogroups.com>> wrote: > > > > __ > > > > On 3-10-2019 18:32, Mark Rotteveel m...@lawinegevaar.nl > > <mailto:m...@lawinegevaar.nl> > > [firebird-support] wrote: > > > On 3-10-2019 14:14, Clyde Eisenbeis cte...@gmail.com > > <mailto:cte...@gmail.com> [firebird-support] > > > wrote: > > >> I've been to > > >> https://groups.google.com/forum/#!forum/firebird-net-provider. > > Is there > > >> a login for that group? ... I don't see a post option. Or is > > there an > > >> email adr for the group? Thanks! > > > > > > If you are logged in to Google/Gmail, there should be a button "Join > > > group" at the top. Alternatively, you can subscribe by sending an > > email > > > to firebird-net-provider+subscr...@googlegroups.com > > <mailto:firebird-net-provider%2bsubscr...@googlegroups.com> (but I > > believe then > > > you'll still need to login on Google/Gmail). > > > > Correction: you can confirm your subscription by replying to the > > confirmation email. In that case you don't need to login to > > Google/Gmail. > > > > Mark > > -- > > Mark Rotteveel > > > > > > > > > > -- > Mark Rotteveel > >
[firebird-support] Firebird-net-provider
Yesterday, I sent an email to => "I'm wondering if I subscribed correctly?" I have not received a response. Any suggestions? I would like to start code writing for a Firebird database. On Thu, Oct 3, 2019 at 11:40 AM Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 3-10-2019 18:32, Mark Rotteveel m...@lawinegevaar.nl > [firebird-support] wrote: > > On 3-10-2019 14:14, Clyde Eisenbeis cte...@gmail.com [firebird-support] > > wrote: > >> I've been to > >> https://groups.google.com/forum/#!forum/firebird-net-provider. Is > there > >> a login for that group? ... I don't see a post option. Or is there an > >> email adr for the group? Thanks! > > > > If you are logged in to Google/Gmail, there should be a button "Join > > group" at the top. Alternatively, you can subscribe by sending an email > > to firebird-net-provider+subscr...@googlegroups.com (but I believe then > > you'll still need to login on Google/Gmail). > > Correction: you can confirm your subscription by replying to the > confirmation email. In that case you don't need to login to Google/Gmail. > > Mark > -- > Mark Rotteveel > >
[firebird-support] Firebird-net-provider
I've been to https://groups.google.com/forum/#!forum/firebird-net-provider. Is there a login for that group? ... I don't see a post option. Or is there an email adr for the group? Thanks! Clyde From: Mark Rotteveel m...@lawinegevaar.nl [firebird-support] < firebird-support@yahoogroups.com> Date: Wed, Oct 2, 2019 at 9:45 AM Subject: Re: [firebird-support] Basic Re-Start To: On 2019-10-01 20:15, Clyde Eisenbeis cte...@gmail.com [firebird-support] > wrote: > > Thanks for clarifying. Is there a more current Embedded_fb3.pdf doc? > > I don't see fbclient.dll file mentioned in that doc (although > > fbclient.dll is in Firebird 3.zip). > > > > Referencing fbclient.dll to Visual Studio is easy. Do I need any > > other files (such as plugins)? Is there any compiling or > > installation necessary? > > > > Typically, I reference a dll in Visual Studio, and Visual Studio > > includes it when a program is compiled. > > You need to reference the FirebirdSql.Data.Client library (Firebird > ADO.net provider, https://firebirdsql.org/en/net-provider/), which will > load fbclient if you set it to server type embedded. But really, you > should take your question to the Firebird-net-provider Google Group, > because you're more likely to get a more specific answer there about > using Firebird from .net. > > Mark > >
Re: [firebird-support] Basic Re-Start
Thanks for clarifying. Is there a more current Embedded_fb3.pdf doc? I don't see fbclient.dll file mentioned in that doc (although fbclient.dll is in Firebird 3.zip). Referencing fbclient.dll to Visual Studio is easy. Do I need any other files (such as plugins)? Is there any compiling or installation necessary? Typically, I reference a dll in Visual Studio, and Visual Studio includes it when a program is compiled. ~~ On Tue, Oct 1, 2019 at 12:51 PM Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 2019-10-01 19:15, Clyde Eisenbeis cte...@gmail.com [firebird-support] > wrote: > > I downloaded both Firebird 2.5.zip and Firebird 3.zip. I cannot find > > the file (fbembed.dll) described in Embedded_fb3.pdf. > > Please read that PDF again, it mentions fbembed.dll only once, and in > the past tense to describe the situation of previous Firebird versions. > That is because with Firebird 3, there is no separate DLL anymore, it is > accessible through fbclient.dll if you have the right additional plugin > DLLs relative to that fbclient.dll, which is described in that PDF. > > The fbembed.dll only exists in Firebird 2.5 and earlier, and you need to > download the embedded zipkit for that. This embedded zipkit is available > from the downloadpage for 2.5: > https://www.firebirdsql.org/en/firebird-2-5/ > > For Firebird 3, you can use the normal zipkit from the downloadpage for > 3.0: https://www.firebirdsql.org/en/firebird-3-0/ > > See also: > https://www.lawinegevaar.nl/firebird/jaybird_embedded_example.html (for > Java, but the description of the folder layout can be applied for C# as > well) > > If I recall correctly, the Firebird ADO.net provider by default tries to > load fbembed.dll and I don't recall if it also tries fbclient.dll. When > using Firebird 3 embedded, you may need to explicitly set the client > library to fbclient.dll (it has a connection property for this). > > > Is there an email adr for Firebird Embedded developers? > > There are no separate developers for Firebird Embedded: it is the same > engine that is used by Firebird server. You have this mailing list, or > the firebird-net-provider list for C# specific questions. There is also > the firebird-devel mailing list, but that is primarily focused on > development of Firebird itself and not intended for support questions. > > Mark > >
Re: [firebird-support] Basic Re-Start
I downloaded both Firebird 2.5.zip and Firebird 3.zip. I cannot find the file (fbembed.dll) described in Embedded_fb3.pdf. Is there an email adr for Firebird Embedded developers? On Mon, Sep 30, 2019 at 9:16 AM 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support] wrote: > > > > 30.09.2019 14:27, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > > > What the the link for downloading Embedded Firebird? > > > >None. Read Firebird 3 Release Notes. > > Or read this... > https://www.ibphoenix.com/files/Embedded_fb3.pdf > > Regards > Paul > > > > > > > ++ > > 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 > > >
Re: [firebird-support] Basic Re-Start
Embedded Firebird sounds exactly what I'd use! What the the link for downloading Embedded Firebird? On Sat, Sep 28, 2019 at 10:23 AM 'Karel Rys' ka...@rysovo.cz [firebird-support] wrote: > > > It is possible to use "embedded Firebird", which does not need running > server. > > Karel Rys > > >>> "Richard Damon rich...@damon-family.org [firebird-support]" > 28.9.2019 16:15 >>> > > On 9/28/19 8:52 AM, Clyde Eisenbeis cte...@gmail.com > [firebird-support] > wrote: > > > > I'll be using Firebird on my personal laptop. My program (that uses > > that database) will be used often > > every day. > > > > I'm puzzled by some of the questions as I have assumed Firebird is a > > dormant database file that my program accesses. It sounds like > > Firebird is a program that needs to run to work. > > > Firebird is a Database Client/Server application. You program is > linked > to the client side, which talks to the server side (and the server > side > works the actually database file). This is the way many Database > systems > work, and has advantages in that the server side has the ability to > enforce certain sharing and access rules on the database. It does mean > you need to start the 'server' app to access the database. > > There are other database systems where the client library directly > accesses the database file(s), SQLite works that way, Microsoft Access > can work that way, the ancient xBase worked that way. These databases > can be converted into a Client/Server system by wrapping them with a > Client/Server wrapper layer, but tend not to provide a lot of access > control, since if the user application is directly accessing the file, > there isn't much the database system can do to 'protect' itself.. > > -- > Richard Damon > > [Non-text portions of this message have been removed] > > >
Re: [firebird-support] Basic Re-Start
Thanks for the prompt response! ... and explanation! Based on my specific case, what radio buttons should I select? On Sat, Sep 28, 2019 at 9:16 AM Richard Damon rich...@damon-family.org [firebird-support] wrote: > > > On 9/28/19 8:52 AM, Clyde Eisenbeis cte...@gmail.com [firebird-support] > wrote: > > > > I'll be using Firebird on my personal laptop. My program (that uses > > that database) will be used often > > every day. > > > > I'm puzzled by some of the questions as I have assumed Firebird is a > > dormant database file that my program accesses. It sounds like > > Firebird is a program that needs to run to work. > > > Firebird is a Database Client/Server application. You program is linked > to the client side, which talks to the server side (and the server side > works the actually database file). This is the way many Database systems > work, and has advantages in that the server side has the ability to > enforce certain sharing and access rules on the database. It does mean > you need to start the 'server' app to access the database. > > There are other database systems where the client library directly > accesses the database file(s), SQLite works that way, Microsoft Access > can work that way, the ancient xBase worked that way. These databases > can be converted into a Client/Server system by wrapping them with a > Client/Server wrapper layer, but tend not to provide a lot of access > control, since if the user application is directly accessing the file, > there isn't much the database system can do to 'protect' itself.. > > -- > Richard Damon > > >
Re: [firebird-support] Basic Re-Start
I'll be using Firebird on my personal laptop. My program (that uses that database) will be used often every day. I'm puzzled by some of the questions as I have assumed Firebird is a dormant database file that my program accesses. It sounds like Firebird is a program that needs to run to work. --- 1) I downloaded and started installing Firebird-3.0.4.33054_0_x64.exe. I don't know the answer to some questions: a) Run Firebird in SuperServer mode? b) Run Firebird as an Ap or as a Service? c) Start Firebird every time I boot up? d) Copy Firebird client library to directory? --- 2) I cannot find my post either. Clyde ~~ On Sat, Sep 28, 2019 at 4:50 AM Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 28-9-2019 00:58, Clyde Eisenbeis cte...@gmail.com [firebird-support] > wrote: > > I posted on > > https://groups.google.com/forum/#!forum/firebird-net-provider ... have > > not had a reply. > > I don't see a post by you in that group nor in my mailbox (as I'm > subscribed to it by mail as well). Maybe it is held for approval? > > Mark > -- > Mark Rotteveel > >
Re: [firebird-support] Basic Re-Start
I posted on https://groups.google.com/forum/#!forum/firebird-net-provider
have not had a reply.
I used Firebird about two years ago (for about a month). I have now
decided to convert my database to Firebird.
I decided to start over => installed Visual Studio 2019 on a new laptop.
What are the steps to install the latest version of Firebird?
Thanks!
~~~
On Thu, Sep 19, 2019 at 1:08 PM Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
>
>
> On 19-9-2019 16:12, Clyde Eisenbeis cte...@gmail.com [firebird-support]
> wrote:
> > I used Firebird about two years ago (for about a month). I have now
> > decided to convert my database to Firebird.
> >
> > I added
> \packages\FirebirdSql.Data.FirebirdClient.5.8.1\lib\net40-client\FirebirdSql.Data.FirebirdClient.dll
> > to my Visual Studio (2013) References.
> >
> > My code compiles fine. When I run FbConnection.CreateDatabase() I get
> > an Exception => {"Unable to load DLL 'fb3embedded\\fbclient.dll': The
> > specified module could not be found. (Exception from HRESULT:
> > 0x8007007E)"}
> >
> > I don't recall the steps I missed. Please advise. Thanks!
>
> Your URL reference fb3embedded\\fbclient.dll, but that DDL is not found
> (or possibly it is 32 bit and your code runs 64 bit or vice versa).
>
> BTW: If you want to connect to a Firebird server instead of using
> Firebird Embedded, you don't need this, and it would mean that you
> specified the wrong server type.
>
> Also, your question is more suitable for the firebird-net-provider list,
> at https://groups.google.com/forum/#!forum/firebird-net-provider
>
> Mark
> --
> Mark Rotteveel
>
>
[firebird-support] Basic Re-Start
I used Firebird about two years ago (for about a month). I have now
decided to convert my database to Firebird.
I added
\packages\FirebirdSql.Data.FirebirdClient.5.8.1\lib\net40-client\FirebirdSql.Data.FirebirdClient.dll
to my Visual Studio (2013) References.
My code compiles fine. When I run FbConnection.CreateDatabase() I get
an Exception => {"Unable to load DLL 'fb3embedded\\fbclient.dll': The
specified module could not be found. (Exception from HRESULT:
0x8007007E)"}
I don't recall the steps I missed. Please advise. Thanks!
Clyde
-
Clyde Eisenbeis
cte...@gmail.com
641-691-0110
-
Re: [firebird-support] Basic Start
Mark, Thanks for the info! I was unaware of this group. Clyde On Wed, Mar 15, 2017 at 7:27 AM, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] <firebird-support@yahoogroups.com> wrote: > > > On 2017-03-14 18:32, Clyde Eisenbeis cte...@gmail.com [firebird-support] > wrote: > > > I've recently written code using SQLite (C# .NET, using > > System.Data.SQLite) ... decided to try Firebird. > > > > > > To install Firebird: Visual Studio 2013 -> File -> New -> Project, > > etc. -- then Tools -> Library Package Manager -> Manage NuGet > > Packages -> search "firebird" -> Firebird ADO.NET Data provider -> > > Install (button). > > > > > > Resulted in a) References -> FirebirdSql.Data.FirebirdClient, and b) > > FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's. > > > > > > 1) Was the the correct procedure? > > > > > > 2) Can I create a Firebird database file? ... as I did with SQLite ... > > System.Data.SQLite.SQLiteConnection.CreateFile(stPathFilename) where > > the filename ends with .sqlite. > > Your question would be more on-topic on the firebird-net-provider > mailing list. You can subscribe by sending an email with subject > "subscribe" to firebird-net-provider-requ...@lists.sourceforge.net > > Mark > > >
Re: [firebird-support] Basic Start
Slavek,
Here is what I'm attempting:
int pageSize = 4096;
bool forcedWrites = true;
bool overwrite = false;
var connectionString = new FbConnectionStringBuilder
{
Database = stPathFilename,
ServerType = FbServerType.Embedded,
UserID = "SYSDBA",
Password = "masterkey",
ClientLibrary = "fbclient.dll"
}.ToString();
FbConnection.CreateDatabase(connectionString, pageSize, forcedWrites,
overwrite);
This code throughs a exception ... complains about fbclient.dll. I'm not
sure what to use for Client Library.
On Tue, Mar 14, 2017 at 4:42 PM, Slavomir Skopalik skopa...@elektlabs.cz
[firebird-support] wrote:
>
>
> Yes, look here:
>
> public static void CreateDatabase(string connectionString, int
> pageSize = 4096, bool forcedWrites = true, bool overwrite = false)
> {
> CreateDatabaseImpl(connectionString, pageSize,
> forcedWrites, overwrite);
> }
>
> As connection string you can use file name.
> Look for example
> here:http://stackoverflow.com/questions/41980813/firebird-net-provider-and-embedded-server-3/41981523
>
> Slavek
>
>
>
> 2) Can I create a Firebird database file? ... as I did with SQLite ...
> System.Data.SQLite.SQLiteConnection.CreateFile(stPathFilename) where
> the filename ends with .sqlite.
>
>
>
>
>
Re: [firebird-support] Basic Start
Thanks for the prompt response! I've read through portions of the Quick Start Guide ... information overload. It's difficult to read all of the options, many of which are not applicable. 1) I decided to try using NuGet ... which provided me with a Firebird installation ... which I think is correct. Does this look ok to you? 2) In the "Working with database" section of the Guide, is "how to create a database". The only relevant section I find is "Creating a database using isql". When I open a Command Prompt, and enter isql, isql is not recognized. On Tue, Mar 14, 2017 at 3:07 PM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> wrote: > 14.03.2017 18:32, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: >> 2) Can I create a Firebird database file? ... as I did with SQLite ... > >No. Firebird is a client-server DBMS, closer to Oracle than file-server > like SQLite. >Read Firebird Quick Start Guide. > > > -- >WBR, SD. > > > > > > > ++ > > 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 > > >
[firebird-support] Basic Start
I've recently written code using SQLite (C# .NET, using System.Data.SQLite) ... decided to try Firebird. To install Firebird: Visual Studio 2013 -> File -> New -> Project, etc. -- then Tools -> Library Package Manager -> Manage NuGet Packages -> search "firebird" -> Firebird ADO.NET Data provider -> Install (button). Resulted in a) References -> FirebirdSql.Data.FirebirdClient, and b) FirebirdSql.Data.FirebirdClient.5.8.0 subdir ... with Firebird .dll's. 1) Was the the correct procedure? 2) Can I create a Firebird database file? ... as I did with SQLite ... System.Data.SQLite.SQLiteConnection.CreateFile(stPathFilename) where the filename ends with .sqlite.
