Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 26 Table has no index order set
Message
From
17/04/2014 01:44:05
 
 
To
16/04/2014 17:36:22
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
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:
01598730
Views:
53
It depends, Luis, on how the output must look like

Maybe including the lineDiscount and lineTax in the select will do
Select	fi.ftstamp, ;
	fno, ;
	ref, ;
	design, ;
	qtt, ;
	epv, ;
	etiliquido, ;
	usr4 AS 'Codpautal', ;
	codigo, ;
	lineDiscount, ;	&& here
	linetax ;		&& here
	;
	from fi ;
	order by fi.fno ;
	 into cursor Linhas ;
	where fi.fno = 121005551
>Hello Gregory
>
>Many thanks for your help, now the code work great.
>
>Please tell me , i need to create 2 subnode for each line of my invoice, like this
>
>Lines
> lineDiscount - to keep comercial discount on each line
> linetax - to keep tax percent and value on each line
>
>When i go to create this 2 new cursors, i must also create na INDEX for each one ?
>
>Many thanks,
>Luis Santos
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform