BrowseDialog "EndsWith" option...

Author	Message
StrataFrame Team	S StrataFrame Team posted 17 Years Ago Post Details Share Post
S Group: StrataFrame Developers Posts: 3K, Visits: 2.5K	Nice catch, Robin. I updated it on this end as well and it will be included in the next update. Thanks.
	Reply Like 0
Robin J Giltner	Robin J Giltner posted 17 Years Ago Topic Details Share Topic
Group: Forum Members Posts: 105, Visits: 650	In the BrowseDialog, on a string field, when Using the "EndsWith" advanced option, I noticed that the query was putting it together with an "&" instead of a"%". I went into the SqlDataSourceItem.vb, line 627, it has loParam.Value = "&" & CType(loWhere.Values(0), String) I changed that to loParam.Value = "%" & CType(loWhere.Values(0), String) and it seems to be working fine now. I'm not too well versed on Oracle, and VFP data sources etc., so I didn't know if those should be changed as well, but since we aren't using any of those, I guess I'll be ok :-) Thanks, Robin Giltner
	Reply Like 0