Thanks Johan.
--
--------------------------
Lesley Dean
CapeSoft
www.capesoft.com

--- In firebird-support@yahoogroups.com, "Johan van Zyl"
<johan@j...> wrote:

> 2. "mixed sort orders?"
> Apparently not
>
> Johan van Zyl
> JVZ Systems CC
> Somerset West
> -----Original Message-----
> From: lesdean79 [mailto:LesDean79@h...]
> 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]