Re: [DUG]: Paradox SQL

[Mark Howard]

Steve Really surprised that you have to go through this tortuous procedure with Interbase.  The only other database that I have had anything to do with is Informix (long time ago) and with that you could do     alter table mytable modify myfield(chr( 4), chr (5)) or something similar.   Oh well - guess I'll just have to do it the way you have suggested.    I see there is a way to do it using low level BDE calls - but that looks like it might be easy for someone with my experience to stuff things up big time!   Thanks for your help   Mark ----- Original Message ----- From: Steve Aish To: Multiple recipients of list delphi Sent: Thursday, November 01, 2001 10:26 AM Subject: RE: [DUG]: Paradox SQL 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