--- In firebird-support@yahoogroups.com, Ann Harrison wrote:
On Mon, Jan 28, 2013 at 2:21 PM, Jeff wrote:
High/Low is a technique of generating primary keys client side in contrast
to generating keys server side with fb generators. Here is a link to a
discussion that probably
Ann, thanks for your answer. Thanks also goes to all others who have shared
their knowledge. Please see inline.
--- In firebird-support@yahoogroups.com, Ann Harrison wrote:
On Fri, Jan 25, 2013 at 4:21 PM, Jeff wrote:
(Using FB 1.5)
OK, that's scary right there. Firebird 1.5
Hi all,
(Using FB 1.5)
Do inserts in FB benefit from ordered or sequential PK?
Please allow me to clarify. I intend to use High/Low for table PKs. With this
approach, it is very possible that PKs will not be in sequential order as they
are inserted into the db. Will this be an issue in FB?
I
The following simple query produces the results below:
SELECT SCHEDULE.DATE_TIME, TEAMS.TEAM FROM SCHEDULE
LEFT JOIN TEAMS ON SCHEDULE.HOME_TEAMID=TEAMS.PRIMARYKEY
***QUERY RESULTS (Showing 'Home Team' Column)***
12/01/2012 TeamA
12/21/2012 TeamB
12/25/2012 TeamC
How do I include the
--- In firebird-support@yahoogroups.com, Leyne, Sean Sean@... wrote:
Use tables aliases to include multiple references to a single table.
SELECT
SCHEDULE.DATE_TIME, HomeTeam.TEAM, AwayTeam.Team
FROM SCHEDULE
LEFT JOIN TEAMS HomeTeam ON HomeTeam.PRIMARYKEY = SCHEDULE.HOME_TEAMID
i'm evaluating firebird embedded for use in small workgroup setting.
i'm a little confused by documentation.
The embedded server in the Windows library, fbembed.dll, now uses
Superclassic, not Superserver as previously,
thus unifying its model with that of local connection to Superclassic on