General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I have a table that is already being used in an installation. I need to modify the table structure to repair a bug and remove an unneeded field. The only way I know how to modify table structures is to use the Project Manager but that is NOT available on the clients site.
>
>#1 - How do I change an existing field type from character 15 to integer 4?
>
>#2 - How do I remove a field from the a table?
>
>#3 - How do I add a field to a table?
>
>#4 - I assume I am updating the clients existing database (somehow), but if I make these changes - what do I need to copy to the clients system (.dbc, .exe, ...)?
>
>
>Thanks
One handy thing is building a command window simulator into your app. There were some in the files section last I checked. Make a secret key combo pop up the form and then you can do anything you can do from the command window. In your case, you'd want MODIFY STRUCTURE.
This is especially handy when the client's tables are hundreds of megs and the client is a day's drive away. PCAnywhere is slow, but better than a long drive. :)
Michelle
Previous
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