Hi Nadya,
>>
>>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.
>>
>>Any Ideas?
>>TIA,
>
>Hi Bill,
>
>Trying to find the thread, I searched through all my 673 messages and get rid off some of them. Anyway, finally I found thread by searching on Gar Lipov.
>Databases,Tables, Views, Indexing and SQL syntax Re: Create an Integer field on the fly Thread #
382290>
>Hope this helps.
Somewhat, but not exactly. I guess I need to expand my question.
The function Get_Age() returns NULL when the Birth_Date is NULL. That IS the result I want since, you can't know the Age when you don't know the Birth_Date. However, VFP creates a Numeric field in the cursor for the result of Get_Age(). When Get_Age() returns a NULL, I get the error, Field doesn't accept NULL! True, since Numeric can't accept NULL, but Integer can. (Unless I'm mistaken there. <G>)
Any Ideas?
Bill Armbrecht
VFP MCP