Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ignoring the validations...
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00870670
Message ID:
00870810
Views:
7
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!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform