Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can't find error: Table Has no Index Order Set
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00021538
Message ID:
00021548
Vues:
34
>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/
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform