Link to home
Start Free TrialLog in
Avatar of philipleighs
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.
Avatar of kretzschmar
kretzschmar
Flag of Germany image

What Database you use?

execute a sqlstatement in a sqlquerycomponoent

the statemant maybe like this:

alter table tablename modify(fieldname newdatatype)

meikl
Oops,

the statement above is only available on Oracle-databases

meikl
Avatar of ZifNab
ZifNab

The problem is then that you totally reconfigure your database table... Do you want that?

Paradox table?

Zif.
this is an example how to change the paradox table in source :
http://www.inprise.com/devsupport/bde/files/pxrest.zip
ASKER CERTIFIED SOLUTION
Avatar of ZifNab
ZifNab

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of philipleighs

ASKER

Thanks Zif,

This is exactly what I needed.

Regards,
Phil.