> >
> > 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

Hi:

While upsizing if we change the structure it is not showing error. That means if it is N(6,2) change it to (12,4) the value will be correctly upsized.
I have table with more than 60 fields and 100's of such tables. can any body tell me a shot cut to do this. or some other solution.

Thanks& Regards
Renjith