Information générale
Catégorie:
Codage, syntaxe et commandes
Hi Frank.
>I notice that GENDBC does not create SET FILTERS for primay key on indexed files in a dbc. I'm interested in doing this as part of a process to create a dbc with imbedded tables on the fly and need to get by requirement to add these manually. Any ideas anybody?
Consider using Stonefield Database Toolkit. It can create all your tables with a single call (or update their structures if the tables already exist). It knows how to create a filtered primary key.
As an alternative, you can modify the code generated by GENDBC, removing the PRIMARY definitions from the CREATE TABLE statements and adding ALTER TABLE statements to create the filtered primary keys. Of course, this is tedious, error-prone, and has to be done each time you make even the slightest change to your data structures.
Doug
Précédent
Suivant
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