Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding memo field as calculated field
Message
 
 
To
27/07/2002 12:07:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00683249
Message ID:
00683255
Views:
42
>>Yes, you can create a cursor with memo field and add it to select.
CREATE CURSOR crsTemp (Notes M)
>>APPEND BLANK
>>SELECT * ;
>>  FROM Content, crsTemp ;
>>  INTO CURSOR Temp
>>
>
>This is a nice trick. Thanks

It's quite easy to do such things in Sql Server using CAST/CONVERT functions. Wouldn't be nice to have similar function in VFP? Than you could write something like
SELECT *, ;
  CONVERT(SPACE(100), "M") AS Notes, ;
  CONVERT(0, "Y") AS Amount, ;
  FROM Content INTO CURSOR Temp
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform