BrowseDialog "EndsWith" option...


Author
Message
Robin J Giltner
Robin J Giltner
StrataFrame User (131 reputation)StrataFrame User (131 reputation)StrataFrame User (131 reputation)StrataFrame User (131 reputation)StrataFrame User (131 reputation)StrataFrame User (131 reputation)StrataFrame User (131 reputation)StrataFrame User (131 reputation)StrataFrame User (131 reputation)
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

StrataFrame Team
S
StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)StrataFrame Developer (4.4K reputation)
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.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search