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 newes
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 ol
:
>
>
> 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?
>
>
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 record
>
>
> 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-s
This finds all records:
``
"SELECT * FROM " + stTableName
``
This does not work:
``
"SELECT * FROM " + stTableName + " FETCH 10 ROWS"
``
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:
>
>
>
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:
> >
> &g
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 '='?
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
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:
> >
> >
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.
>
>
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
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,
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
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
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]
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 E
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:
>
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?
>
> Thi
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:
> >
> &g
winegevaar.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:
ird-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
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...@
; 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
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 p
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 [firebir
?
---
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 p
hat 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 Fir
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
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]
>
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",
n 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 ..
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
34 matches
Mail list logo