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.
Bharat Sanghvi
Vice President, Information Technology
Deyta
Continuous Quality Measurement Systems