Using BO.Seek with strings and single quotes


Author
Message
Ger Cannoll
Ger Cannoll
Advanced StrataFrame User (628 reputation)Advanced StrataFrame User (628 reputation)Advanced StrataFrame User (628 reputation)Advanced StrataFrame User (628 reputation)Advanced StrataFrame User (628 reputation)Advanced StrataFrame User (628 reputation)Advanced StrataFrame User (628 reputation)Advanced StrataFrame User (628 reputation)Advanced StrataFrame User (628 reputation)
Group: StrataFrame Users
Posts: 430, Visits: 507
I have a variable called myName and its value is -->  Paddy O'Sullivan

I have a MyBo.seek("Comp_name = " + "'"  + myName   + "'") and its erroring out, I think  because of the embedded single quote in the name before Sullivan

(If I was doing this in SQL (as opposed to a BO) I'd use a Parameter so single quotes would not be a problem)

I know I cam probably get over this by replacing single quotes with adifferent character but I wont get a proper result then.

Is there any way of using e Parameter structure when I do BO.Seek ?
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search