Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Serious bug in our application
Message
 
 
To
20/03/2006 19:14:25
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01105978
Message ID:
01106101
Views:
26
>In that case, how about this workaround: have a special string, say "(null)" in the combo for where we should have real nulls, then when saving, if there's this string in the field that's cbo's controlsource, replace that string with a real null.
>
>How bout that?

I've added setting NullDisplay to 'NULL' in lAddBlank_assign method and added the following code in the Valid event of the combobox that seems to solve the problem (I would need more tests tomorrow):
if this.listindex > 0
	if this.rowsourcetype = 5 and isnull(this.aRowSource[this.ListIndex,2]) ;
			and this.boundcolumn = 2 and not empty(this.controlsource)
		replace (justext(this.controlsource)) with null in (juststem(this.controlsource))
	endif
endif
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform