Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to do this SQL query?
Message
 
 
To
01/05/2008 10:31:32
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7 SP1
Miscellaneous
Thread ID:
01314464
Message ID:
01314467
Views:
7
Use zeros to tell VFP what sizes of the field you want or upgrade to VFP9 and use CAST() function
select Amount1, amount2, 000000.00 AS ResultComputation
What other field types are you interested in?

>I build a cursor. Within that cursor I want to add a field. The thing is that I will use that field to do computations.
>
>For example:
>
>select Amount1, amount2, ResultComputation
>
>Amount1 and Amount2 are fields in a table. I want to create ResultComputation
>
>How do I create a field without knowing the value it will hold?
>
>For example what if I want that field to hold N(8,2)?
>
>As long as we're at it how would I create other kinds of fields
>
>For example :
>
>I know that for a logical I can do this : Select .t. as LogicalField
>I know that for strings I can do this : select space( 20) as StringField
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform