2. "mixed sort orders?"
Apparently not

Johan van Zyl
JVZ Systems CC
Somerset West
-----Original Message-----
From: lesdean79 [mailto:LesDean79@...]
Sent: 06 August 2004 10:59
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Newbie: A few questions...


Hi All,

Just beginning to work with FireBird. So far looks really cool. Some
questions I have run into, which you guys and gals may be able to
help me out with:

1. Can you rename a table with SQL syntax in FireBird?
(Obviously, one can create a new table, copy data across, and then
drop the old table, but is there a 'Alter table RENAME oldtablename
to newtablename'?)

2. Does FireBird support Multi-component keys with mixed sort orders?
For example 1 key, 2 fields, 1 ascending, and 1 descending?

3. What is the maximum key size in FireBird, and is it affected by
the Database Page Size?

Thanks in advance.
--
--------------------------
Lesley Dean
CapeSoft
www.capesoft.com




Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.734 / Virus Database: 488 - Release Date: 2004/08/04


[Non-text portions of this message have been removed]