Re: Fox pro 2 Oracle

It is pretty easy. But the key is of course setting things up correctly in the first place to handle the correct formats for datetimes and PKs. If the data is not good enough to APPEND directly, then some pre-APPEND massage could be required.

As far as the "what then" is concerned if VFP runs into an error and stops appending, if table buffering is set on the view, then you can rollback, fix the problem, and try again.

Of course you can always loop thru your source data and construct SQL statements for each row, SQLEXEC() them thru an ODBC handle, and catch any errors at the row level (and even wrap your loop in a transaction so you can still rollback if any errors are not recoverable).

Jim Davis
Informatique Ressources Humaines

"Ted Knijff" <knijff_at_bigfoot.com> wrote in message news:3aa25f09.24797847_at_news.online.de...
> Well, that sure sounds easy, but I don't know about stuff like
> primary keys (where Oracle is a bit more stringent than VFP) and
> date formats and datetime formats and memo fields and logical fields
> and code pages...
>
> Because as soon as APPEND runs into an Oracle error, it just sort
> of stops appending. What then ?
>
> On Sun, 4 Mar 2001 10:16:18 +0100, "Jim Davis" <jimdavis_at_iprolink.ch>
> wrote:
>
> >Create a VFP view (if this is VFP) for the Oracle data, in the same
 format
> >as the data you want to import. Make sure to turn on the appropriate
 update
> >options in the view. Open that view, and APPEND into it.
> >
> >Jim Davis
> >Informatique Ressources Humaines
> >
> >
> >
> >"Tristan" <moonshine_at_apex.net.au> wrote in message
> >news:983444934.868085_at_draal.apex.net.au...
> >> Is there a simple way to copy in foxpro data into oracle tables? At the
> >> moment I am copying out the foxpro data to a simple file, then using
 the
> >> sqlldr utility.
> >>
> >> Thanks,
> >>
> >> Tristan
> >>
> >>
> >
> >
>
> EMail: knijff_at_bigfoot.com
Received on Mon Mar 05 2001 - 00:19:24 CST