StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Using BO.Seek with strings and single quotes

Using BO.Seek with strings and single quotes

Ger Cannoll — Tue, 30 Oct 2012 04:01:22 GMT

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 ?

RE: Using BO.Seek with strings and single quotes

Ger Cannoll — Tue, 30 Oct 2012 04:01:22 GMT

Hi Ivan, Edhy, many thanks for your replies.

Since posting , I have discovered that doing a seek on a BO.Seek is too slow (With thousands of transactions) so I have gone back to Seeking the Database itself, and here I can use parameters anyway, so not a problem

Just one query though, If I do as seek with the replaced two single quotes, does it seek for the Single Quote or seek for two single quotes

In an example, I used a variable to hold the string (with the single quote replaced with two single quotes) , and if it was not found, it inserts it, but it inserted two single quotes !!

RE: Using BO.Seek with strings and single quotes

Ivan George Borges — Mon, 29 Oct 2012 13:57:33 GMT

Yep, looks good. ;)

RE: Using BO.Seek with strings and single quotes

Edhy Rijo — Mon, 29 Oct 2012 09:31:42 GMT

Hi Ger, Ivan,

Since no parameter can be used in the bo.Seek() I am a big fan of using the String.Format to get my expression clearer, so I would use something like this:
[codesnippet]Me.MyBO.Seek(String.Format("MyName='{0}'", Me.MyBO.MyName.Replace("'", "''")))[/codesnippet]

RE: Using BO.Seek with strings and single quotes

Ivan George Borges — Mon, 29 Oct 2012 06:24:29 GMT

Hi Ger.

Try:

[codesnippet]MyBo.seek("Comp_name = " + "'" + myName.Replace("'", "''") + "'")[/codesnippet]