Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to do this SQL query?
Message
From
01/05/2008 10:39:28
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7 SP1
Miscellaneous
Thread ID:
01314464
Message ID:
01314472
Views:
8
Thanks Sergey. That's what I did. I thought there could be another way. As for the other I probably have them all. I mean logical, strings, numeric. And I hope to be able to make that move to VFP9 soon. I already tested some things in my app in VFP9 and it looks ok.

Is it possible to add memo? This one is just out of curiosity. Not that I need it and I guess that string could be used instead.

>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 types are 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
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform