> > Hi,
> > I am trying to upsize my data in vfp tables to an oracle. Even thoug the sturcture of the record table in oracle and VFP are same, some record in the vfp table are fail insert into oracle. Can anybody tell me the reson for this and the solution.
> > renjith
>
>
> 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