Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 26 Table has no index order set
Message
From
16/04/2014 13:02:35
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Error 26 Table has no index order set
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01598711
Message ID:
01598711
Views:
69
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.

someone could give me some help

Best regards,

Luis Santos
Next
Reply
Map
View

Click here to load this message in the networking platform