Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can you force Integer datatype in query?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00427622
Message ID:
00427952
Views:
14
Bill,

You have to cludge it. There are a couple of ways:
create cursor TheCludgeThing ( Currency_Age i )
select * ;
   from TheCludgeThing ;
   into cursor TheRealThing ;
union ;
select GetAge() as Currency_Age ;
   from ...
or
select GetAge() as Currency_Age ;
   from ... ;
   into cursor TheCludgeThing
create cursor TheRealThing ( Currency_Age i )
append from dbf( "TheCludgeThing" )
>I know how to force Currency in a SQL statement:
>SELECT $1 * Get_Age() AS Currency_Age FROM ...
(And NO I wouldn't want a Currency Age <bg>)
>
>I can't figure out how to get Integer instead of Numeric.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform