Jason Harris wrote:
>
> On Tue, 02 Sep 1997 13:52:35 -0600, aheller@visa.com wrote:
>
> There may be a way. You can try setting the contraints on the table to
> filter mode which will allow rows to be inserted that dont violate the
> constraints but not allow constraint violations, such as primary keys
> etc.
>
> Dont know if this covers all possible errors.
>
> Regards,
>
> Jason
>
> >
> >What I'd really like to do is run the LOAD command within DB-ACCESS and
> >have LOAD ignore any errors it gets along the way (instead of blowing
> >up). Does anyone know if this is possible (if so, the syntax) or do I
> >have to use DBLOAD
> >
> >Thanks in advance
> >
> >-------------------==== Posted via Deja News ====-----------------------
> > http://www.dejanews.com/ Search, Read, Post to Usenet
Version 7.1 has this feature of being able to copy information about
constraint violations to another table and continue the load. I have
used it and it's great. It is particularly useful for non-unique
violations.
It won't solve problems of trying to convert a text non-number to a
number. To do that you'd need an intermediate table and some code of
your own to check the text.
If you do not have a huge amount of data to deal with you could use awk
or perl.
Peter
--
Peter Lancashire
Mail: Peter.Lancashire.PL1@bayer.co.uk
Information Systems Specialist, Bayer plc
Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK
Tel: +44-1635-562258, Fax: +44-1635-562281
All opinions are my own and not those of Bayer plc.