BrowseDialog "EndsWith" option...


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

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