--- Mark Derricutt <[EMAIL PROTECTED]> wrote:
> On Wed, 11 Aug 1999, Max Renshaw-Fox wrote:
>
> > I assume you're using .dbf files - in which case you can use
> database
> > desktop or dbiDoRestructure which is probably more difficult than
> using SQL
>
> At the moment .db files, moving to an SQL based system later, the
> .dbf
> reference was just cut'n'pasted from the help... must have forgotten
> to
> delete it :)
If you're moving to Informix, their ALTER TABLE command includes a
MODIFY clause, which lets you do (quite reasonable) things like alter
the length of character columns.
I couldn't beleive it wasn't it in the SQL standard!
Cheers,
Kerry S
_______________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com.au address at http://mail.yahoo.com.au
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
