Gustavo,
I first got the full definition by searching using Google, however since
then, I have bought
Helen Borrie's Firebird book from the IBPhoenix site and have learned quite
a lot more about
what DDL commands are available.

I didn't previously know that you could alter alter the position of a field
within the table structure
using the alter command and this has been a useful find.

I recommend this book as a source of much useful information, it is really
the only complete
reference to Firebird available to the best of my knowledge.

Graeme



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Gustavo
Sent: Wednesday, 29 June 2005 12:32 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Upgrade table structure


Hello:

I agree that updating RDB$... tables may not be a good idea. But I didn't
knew the DDL statement Graeme mentioned to alter a field definition.

> ALTER TABLE <TABLE> ALTER <FIELD> TYPE <NEWFIELDTYPE>
> This is the syntax for changing a field type.

Can you tell me where can I find the complete syntax for this statement?
I didn't find it in the documentation of InterBase 5 or in
"Firebird_v15.108_ReleaseNotes.pdf". Perhaps I have to get documentation
more up to date. By the way, can anyone tell me which is the most recent
InterBase version which documentation is applicable to FireBird and which is
the link to download it?

Gustavo


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



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




_____

YAHOO! GROUPS LINKS



* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


_____




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