> >
> >
> > Morning,
> > Stefan's reply is #1 to see what is in fact failing and why.
> > Generally speaking lots of times migration inserts fail due to two
> > main general reasons.
> > 1. NULL handling.
> > 2. Training blanks on field values trying to be inserted.
> > Pete "the IceMan", from the Great White North of Canada.
>
> Hi:
>
> I have identified the probelm. But I dont have the solution till now. My database is in VFP5. in some table the structure is containing N(5,2) but contains more tahn two decimal plces in the data. taht data is failing to be inserted into the oracle tables. When i increse the oracle table field size it is upsizing correctly. Can i get some permnent solution for this.
> Regards
> Renjith


Num(5,2) is not the same in most SQL database as in VFP. In VFP the . dot counts as part of the length 5.
-Anders