|
In
Interbase 5.x we had to do it that way. Interbase 6 has a function for
changeing column lengths etc.
Steve
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 -----
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
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
|
