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