RE: [DUG]: Paradox SQL

[Steve Aish]

Mark,   Knowing nothing about Paradox - but have had the same issue with Interbase 5.  You create a temp column length 4, copy all items from original column to the temp column, drop the original column and recreate it with length 5 and copy all items from the temp column back to the newly created column that is now length 5 and delete the temporary column.  You now have the original column with all the info in it and it is length 5.   This is assuming you can create and drop columns programatically...   Steve -----Original Message----- From: Mark Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 November 2001 9:52 a.m. To: Multiple recipients of list delphi Subject: [DUG]: Paradox SQL Hi   I want to increase the size of a Char column in a Paradox table from 4 to 5 programmatically.   It seems that I cannot write a SQL script to do this - or have I missed this in the documentation?   What is the easiest alternative?   TIA   Mark