General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using greater than 10 chrs in Alter Table - Add Column
Hi,
I have a .dbc that I wish to programatically add new fields. I open the .dbc exclusively, the open the table I want to alter exclusively and then...
ALTER TABLE (lcOldFile) ;
ADD COLUMN &mfield c(mwidth)
...however if the field name is greater than 10 characters, then the field name is truncated to 10 characters.
Is there any way programatically to use greater than 10 chr field names.
Regards
Doug Johnston
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only