Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select statement with count
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00786834
Message ID:
00787333
Views:
26
Thank you very much Yuri. It is working perfect now.

I changed little bit saying thisform.List2src

It is working fine.
***************************************************
local lcSource,col1,lccom,cuList2,temp
**thisform.List2src = .f.
WITH thisform.pageframe1.page3
with .List1
.Rowsource="chgnotce"
.RowsourceType=8
endwith

thisform.addproperty("List2src["+trans(.List1.ListCount)+",2]","")
sele (.list1.Rowsource)
FOR ia= 1 to .List1.ListCount
thisform.List2src[ia,1]=.List1.list[ia,1]
lccom="count for not empty("+.List1.list[ia,1]+") to thisform.List2src[ia,2]"
&lccom
endfor

with .List2
.RowsourceType=5
.Rowsource="thisform.List2src"
.ColumnCount=2
endwith
endwith

***********************************
Thanks for your help.
Previous
Reply
Map
View

Click here to load this message in the networking platform