VB syntax - quotes in string


Author
Message
Charles R Hankey
Charles R Hankey
StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)
Group: Forum Members
Posts: 524, Visits: 30K
I am using guid keys.



In a custom data source BO for a report I am putting a filter on a child cursor



Basically I want the filter to be "cclientkey =" and then the guid as a string - but of course in quotes



_policydisplay.SourceBO.Filter = "cclientkey = " & Me.ckey.ToString



doesn't work as the guid is not surrounded by quote in the resulting filter string.



I googled and tried things like



Dim quotes As Char = ChrW(34)

Dim filtstr As String = "cclientkey = " & quotes & Me.ckey.ToString & quotes

_policyDisplay.SourceBO.Filter = filtstr





Dim filtstr As String = "cclientkey = """ & Me.ckey.ToString & """"

_policyDisplay.SourceBO.Filter = filtstr



etc and no joy



Then reverted to the old Foxpro way



Dim filtstr as String = "cclientkey = '" & me.ckey.toString & "'" ( using single quotes to surround the guid )

and it works.



But a single quote to surround a string will throw and error. Is this some magic the old Foxers at Microfour have made possible? Never saw any solution like this in VB land? And what other ways are there to do this that work?















Replies
Charles R Hankey
Charles R Hankey
StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)
Group: Forum Members
Posts: 524, Visits: 30K
Apropos of this discussion I just ran across this snippet re dates in filter strings so thought I'd stick it here for the benefit of anyone (like me) who may be searching later and need it.



filterON = String.Format("EnterDateTime >= #{0}# and EnterDateTime <= #{1}#", begDate.Date,endDate.Date)

Greg McGuffey
Greg McGuffey
Strategic Support Team Member (4.8K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
Thanks for the additional info Charles! BigGrin



These sorts of things can be hard to figure out when moving to .NET. Nice to have em in one place. BigGrin
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Charles R Hankey - 16 Years Ago
Edhy Rijo - 16 Years Ago
Charles R Hankey - 16 Years Ago
Edhy Rijo - 16 Years Ago
Charles R Hankey - 16 Years Ago
Charles R Hankey - 16 Years Ago
Edhy Rijo - 16 Years Ago
Charles R Hankey - 16 Years Ago
Keith Chisarik - 16 Years Ago
Greg McGuffey - 16 Years Ago
Charles R Hankey - 16 Years Ago
Charles R Hankey - 16 Years Ago
Charles R Hankey - 16 Years Ago
Greg McGuffey - 16 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search