Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement