I want to create a cursor from a remote view because the data is in SQLServer and shows up in the view as MEMOs which I have trouble displaying in grids etc.

When I use the following command the second field is truncated to 12 characters, I don't understand why.

SELECT ALLTRIM(category), ALLTRIM(subcategory) FROM C2!realcats_distinct INTO CURSOR tt

Any clues folks?

Chris Haynes