General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
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