Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Views and set order
Message
From
07/05/2002 06:51:51
 
 
To
06/05/2002 21:32:47
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00653340
Message ID:
00653405
Views:
28
I have defined several indexes for my view but every time I execute set order the The content of my grid doesn't reorder,

This code in the grid's SetOrder() method:
LPARAMETERS tcTag
LOCAL lnRecNo
*** Make sure a valid tag name was passed
IF ! EMPTY( tcTag )
  SET PROCEDURE TO Ch06 ADDITIVE
  WITH This
    *** Make sure it really is a tag for the grid's RecordSource
    IF IsTag( tcTag, .RecordSource )
      lnRecNo = RECNO( .RecordSource )
      *** Go ahead and set the order for the table
      SELECT ( .RecordSource )
      SET ORDER TO ( tcTag )
      IF lnRecNo # 0
        GO lnRecNo IN ( .RecordSource )
      ENDIF
      .SetFocus()
    ENDIF
  ENDWITH					
ENDIF
Previous
Reply
Map
View

Click here to load this message in the networking platform