Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Nevermind the other one, this is simpler
Message
 
 
To
21/09/2006 16:52:41
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01156202
Message ID:
01156235
Views:
14
>
>
>MyNumericField     MyMemoField
>
>1                  Blah
>2                  BlahBlah
>2                  BlahBlah
>3                  BlahBlahBlah
>
>I only want:
>
>1                  Blah
>2                  BlahBlah
>3                  BlahBlahBlah
>
>But I can't group by a memo field, so how can I get this to work:
>
>SELECT MyNumericField, MyMemoField FROM MyTable INTO MyCursor
>
>
If you want distinct data in your cursor and you have long memo (more than 254 chars) you would have to use procedural code (scan /endscan with locate for)
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform