Create cursor MyCursor (MylongNameField1 I) Select Viewfield as MylongNameField1 from MyView into cursor MyCursor