Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is this a Y2K problem?
Message
 
 
To
03/01/2000 11:13:22
John Baird
Coatesville, Pennsylvania, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00311693
Message ID:
00311703
Views:
16
I think your problem stems from the INDEX ON command. It should be:

INDEX ON &tcField TAG &lcIndexName

>Gentlemen:
>
>Below is a method of my program that allows changing index order on a grid header click(). This worked fine until today. I am getting calls from all over the country about the "contains unknown command" error.
>
>The error is occuring on the this line:
>
> SET ORDER TO &lcIndexName &lcOrder
>
>IF I change it to
>
> SET ORDER TO (lcIndexName) &lcOrder
>
>it works just fine. Any idea as to what's up?
>
>
>*************************************************************
>
>LOCAL lcOrder, lcIndexName
>
>SELECT cQuoteList
>WITH this
>	IF .cColName = ALLTRIM(tcColName)
>		.cColOrder = IIF(.cColOrder = 'DESC', 'ASCEND', 'DESC')
>		lcIndexName = .cIndexName
>	ELSE
>		.cColOrder = 'ASCEND'
>		.cColName   = ALLTRIM(tcColName)
>		lcIndexName = SUBSTR(SYS(2015), 3, 10)
>		.cIndexName = lcIndexName
>
>		INDEX ON &tcField TO &lcIndexName
>	ENDIF
>
>	lcOrder = .cColOrder
>	SET ORDER TO &lcIndexName &lcOrder
>	.LockScreen = .T.
>	.grdList.refresh()
>	LOCATE
>	.LockScreen = .F.
>ENDWITH
>
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform