>When I try to run a certain form using VFP 5.0, I get an error stating: Table has no index order set. The error occurs somewhere between the init dataenvironment event and the form init event.
>
>The form has one parametized remote view in the dataenvironment. If I remove the parameter, the error goes away. However, if I create a new form based on the parametized view (using the form wizard), this new form does not have the error.
>
>I've examined all the methods for the dataenvironment and none of them have code in them.
>
>Any ideas?
Jeff
Something like a SEEK is firing -- it needs an index.. You cam Index a field in the Datainenvironment Set the ORDER in your dataenvironment to use a 'default' order (tag). In the OPEN TABLES you can put something like:
set multilocks on
NODEFAULT
llX = dodefault()
*-
if used('OrderHeader')
select OrderHeader
index on cCustID tag cCustID
index on cCustName tag cCustName
index on cDestID tag cDestID
index on cShipID tag cShipID
index on cStatus tag cStatus
index on cTermsID tag cTermsID
index on dDate tag dDate
index on nOrderID tag nOrderID
endif
*-
if !cursorsetprop('BUFFERING',5)
wait window 'Table Buffering for OrderHeader could not be set.'
*-
return(FALSE)
endif
HTH
Tom