There's something wrong with the SQL string you're passing to OLE DB provider. It has nothing to do with using [] string delimiters.

>HI Sergey,
>
>I try your syntax, but when i pass it to my DLL it gives a error exception code 5 and them 0x80040e14
>

>lOk=.oConnect.ADO_CONECTAR()
>lcCommand = [SHAPE {SELECT * FROM "dbo"."Clientes" WHERE C_CODIGO = '] 	+ tcChv + ['}  AS Clientes ]
>lcCommand=lcCommand + [  APPEND ({SELECT * FROM "dbo"."CodPostais"}  AS Cod_Postais RELATE 'c_postal' TO 'c_codigo') AS Cod_Postais ]
>lOK = .oConnect.ADO_PROCURA_CHV(toRS, lcCommand)
>

>
>But, if i try
>

>lOk=.oConnect.ADO_CONECTAR()
>lcCommand = "select * from Clientes where c_codigo = '" + tcChv + "'"
>lOK = .oConnect.ADO_PROCURA_CHV(toRS, lcCommand)
>

>
>it work's ok.
>
>Thank's for your time
>
>João Batista