Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Writeexpression() messes up grid
Message
From
29/07/2008 17:46:45
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Writeexpression() messes up grid
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01335095
Message ID:
01335095
Views:
62
I want to automate a change to my form.
I have property names and values in a table.
The code below, based upon the table values, sets about 6 out of 12 columns in the grid to visible=.f.

For columns set to invisible, the (previously) adjacent column no longer has a vertical line next to it. When I set this non-programmatically in the form designer, it is fine. I think there might also be another problem.. one column with header caption missing?.. need to check further.

note: gridlines is set to 3, gridlinewidth is 1

Any ideas on this?

thanks!
set step on 
modify form FORMS\SOTORJ NOWAIT
lnresult=aselobj(la_form,1)
loform=la_form[1]
use members alias curmemberstochange
set filter to 'COLUMN' $ upper(curmemberstochange.cobject) and 'VISIBLE'  $ upper(curmemberstochange.cpropname) 
*browse 
go top in curmemberstochange
do while not eof('curmemberstochange')
	lc_property=alltrim(curmemberstochange.cpropname)
	lc_object=alltrim(curmemberstochange.cobject)
	if not empty(lc_object) and 'COLUMN' $ upper(curmemberstochange.cobject) and 'VISIBLE'  $ upper(curmemberstochange.cpropname) 
	
	do case
	case curmemberstochange.cvaluetype='C'
		lu_objectvalue=curmemberstochange.cvalue
	case curmemberstochange.cvaluetype='N'
		lu_objectvalue=transform(curmemberstochange.nvalue)
	
	case curmemberstochange.cvaluetype='L'
		lu_objectvalue=transform(curmemberstochange.lvalue)
	
	case curmemberstochange.cvaluetype='D'
		lu_objectvalue=transform(curmemberstochange.dvalue)
	otherwise
		lu_objectvalue=''	
	endcase	
	
	*lc_objectvalue=curmemberstochange.cvalue
	
	*thisform.erpgrd1.&lc_object..&lc_property=lu_objectvalue
	*loform.erpgrd1.&lc_object..&lc_property=lu_objectvalue
	loform.erpgrd1.&lc_object..writeexpression(lc_property,lu_objectvalue)
	
	endif
	skip in curmemberstochange
enddo
*keyboard '{ctrl+w}'
wait window 'here'
Next
Reply
Map
View

Click here to load this message in the networking platform