Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Ignoring the validations...
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00870670
Message ID:
00870810
Vues:
8
Hi,
Take a look at the Alter Table SQL approach.
Rather than the approach that you have tried, I find it better to use the Alter Table Command with the NOVALIDATE clause.
I have used this approach on a number of occasions, and never had a problem, whereas starting with a fresh set of tables and appending causes all sorts of validation and related problems with foreign keys.
HTH
Regards
.

>Hi,
>
>I have some tables (in production). Then I add (in my test database) some new checks for some tables.
>
>Then I create a PRG using GenDBC, go to my client and create a new database (without data)...
>
>So, I run some APPEND FROM and get the data from old to new database...
>
>But, some records are not passing in my new check and I get an error message.
>
>Is there a way to ignore it while I'm transfering it? (just this moment... after that I want to VFP check everthing).
>
>TIA!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform