Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error 26 Table has no index order set
Message
De
17/04/2014 08:18:30
 
 
À
16/04/2014 13:02:35
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01598711
Message ID:
01598735
Vues:
60
>Hello comunity
>
>I work with to cursor where i keep information of my documento (header invoice) and Linhas (Lines of invoice).
>
>I try to use this code:
>LOCAL loXMLAdapter AS XMLAdapter
>
>
>Select ft.ftstamp,fdata, fno,no, nome, morada,local,codpost from ft order by ft.fno into cursor Documento where ft.fno = 121005551
>
>Select fi.ftstamp, fno,ref,design,qtt, epv,etiliquido,usr4 AS 'Codpautal',codigo from fi order by fi.fno into cursor Linhas where fi.fno = 121005551
>
>
>SELECT Documento
>SET RELATION TO ftstamp INTO Linhas ADDITIVE
>
>
>loXMLAdapter = CREATEOBJECT([XMLAdapter])
>
>
>WITH loXMLAdapter AS XMLAdapter
> .XMLSchemaLocation = [AddTableToSchema_Nest.xsd]
> .RespectNesting = .T.
> .AddTableSchema([Categories])
> .AddTableSchema([Products])
> .ToXML([AddTableToSchema_Nest.xml], [], .T.)
> MODIFY FILE AddTableToSchema_Nest.xml
>ENDWITH
>
>loXMLAdapter = .NULL.
>
>But, this script return this error:
>Code 26
>Line: 10
>Message 1: Table has no index order set.
>

You're using SET RELATION; to do that, you (almost always) need an index tag on the child table.

Tamar
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform