Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Array value
Message
From
28/01/2018 13:06:00
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Array value
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows Server 2012 R2
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01657596
Message ID:
01657596
Views:
78
Hello comunity,

I try to update my document with discount value that choose from my combobox from array, but instead of passing for exemple 50 , on my documento i have 2 that suppose is the position of the element values in the array
	DIMENSION arrdb(1) AS int  
	arrdb = 0

	Text to msel textmerge noshow pretext 7
	Select 50 as desconto
	union all
	select 100 as desconto
	Endtext

	If u_SQlexec(msel,[CrsDescontos])
	select CrsDescontos
	Scan
		AAdd('arrdb',ASTR(CrsDescontos.desconto))  &&Here i have the values for my combobox: 0, 50,100
	Endscan

    FECHA([CrsDescontos])
	Endif

After that i make Update on field desconto of my table.
My combobox give me the values : 0, 50, 100, but where i choose for example 50, my document are update with 2.

Someone could give me help.
Many thanks,
Luis
Next
Reply
Map
View

Click here to load this message in the networking platform