philipleighs
asked on
Change TField.Size at runtime
I have a table with a string field which is 6 characters in length. I want to change it to ten characters.
I need to do this at run time, so please don't suggest using Database Desktop!
Thanks.
I need to do this at run time, so please don't suggest using Database Desktop!
Thanks.
Oops,
the statement above is only available on Oracle-databases
meikl
the statement above is only available on Oracle-databases
meikl
The problem is then that you totally reconfigure your database table... Do you want that?
Paradox table?
Zif.
Paradox table?
Zif.
this is an example how to change the paradox table in source :
http://www.inprise.com/devsupport/bde/files/pxrest.zip
http://www.inprise.com/devsupport/bde/files/pxrest.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Zif,
This is exactly what I needed.
Regards,
Phil.
This is exactly what I needed.
Regards,
Phil.
execute a sqlstatement in a sqlquerycomponoent
the statemant maybe like this:
alter table tablename modify(fieldname newdatatype)
meikl