Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't find error: Table Has no Index Order Set
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00021538
Message ID:
00021548
Views:
38
>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
Tom
--------------------------------
Tom O'Hare
407-299-4268 -- tom@redtile.com -- http://www.redtile.com/
Independent Programmer Using Visual FoxPro, Visual Basic & more...
Operations Manager -- Virtual FoxPro User Group (VFUG)
http://www.vfug.org/ -- tom@vfug.org
President -- Central Florida FoxPro User Group (CFFUG)
http://www.redtile.com/foxpro/
Universal Thread Most Valued Professional (MVP)
http://www.transformation.com/foxpro/
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform