Unfortunatelly, there's no such function in VFP. So you'll have to do something like
select (0000000.00 + int1/int2) as myFloat ;
from ... ;
into table tempTable
>does the T-SQL statement:
> select convert( float, int1 / int2 ) as myFloat
> into tempTable From ......
>
>have an equivalent in FoxPro ?
>I tried this:
> select int1/int2 as myFloat ;
> from ... ;
> into table tempTable
>
>the problem with this is that tempTable is created using the structure from the very first record of the resulting query. If the very FIRST records has int1 = 0, then the resulting data type of myFloat in tempTable is N(1,0) !!!!
>
>For all subsequent data, the myFloat value truncates the results to fit N(1,0) data type !
>
>help !
>
>my queries need to be dynamic (based on user-selections, complicated with the fact that each client has different data, but I would like to keep a common code base), so I cannot anticipate the structure of the tempTable before the query is run.
--sb--