GetByName

[Beren]

Hello,
I'm working with the Automation Interface and I get the following error:

DAO.QueryDef [3075]
Syntax error (missing operator) in query expression 'Name='<RNFO-007>Obligatoriedad de campos: 'Datos Solicitante'' AND Object_ID in (13,14,117,118,17,7)'.

I'm getting this error when using the function GetByName() and the string used contains the character ' .
I whish to know is there is any way to escape this character to avoid this error or something like that.

The code I'm using is:

EA_Elem = (EA.Element)EA_Pkg.Elements.GetByName(EA_ElemName);

which work perfectly as long as the string EA_ElemName doesn't contains '

Thank you

Jose

[thomaskilian]

Looks like a bug. You should report that to Sparx.

[Beren]

Ok, done
Thank you

[«Midnight»]

While you wait for a solution, it might be possible to perform the operation by first updating the element name to use a double apostrophe each time there is a single one.

What I mean is to replace each occurrence of an "'" with "''". This would produce the escaped string that an SQL query expects, which is probably why the current code throws an error.