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

A VFP numeric(6,2) will accept an input of 123456.49 and store it as 123456 without decimals; 123456.50 will be stored as 123457. The decimals will eithere be chopped or the number rounded up.
The biggest number including actually including two decimals will 999.99, but 9999.94 would be stored as 9999.9.
The nearest in SQL Server (and probably in Oracle) that would accept all possible values of the (6,2) column in VFP would be Numeric(9,2), which will accept 999999.99; If you want to avoid data loss you should run through your numeric columns and SELECT MAX(number1), MAX(number2),, FROM all tables, hen set he size based on the result. You could also change all numeric column to Double and add a CHECK constrint on those that must be restricted as to max allowable value.
-Anders