Hi Joro,

What OLE error (in hex) and message do you get?
BTW, You don't have to use macro substitution in this case.

oRecordSet.Open("SELECT * FROM " + lcTable,This.lcConnection)

>Hi all
>
>I have one class and two equal methods and i get this error
> -#1426
> -.oConnect.Procura_Unica('Clientes')
>when i call the method procura_unica, the code is the same in the 2 methods,
>
>

>LPARAMETERS lcTable
>oRecordSet=CREATEOBJECT('adodb.recordset')
>oRecordSet.Open("SELECT * FROM &lcTable",This.lcConnection)
>RETURN oRecordSet
>

>
>code that call the two methods
>

>with This
>	lcChv = '-1'
>	llok=.oConnect.Conectar()
> 	if llok
> 	    ? 'OK - Connected'
>	 	.oConnect.Procura_cliente('Clientes') - OK
>	 	.oConnect.Procura_unica('Clientes') - Error Here
>	 else
>	 ? 'NOT Connected'
>	endif
>endwith
>

>But if i call only the second Procura_Unica i get the same error
>
>Thanks in Advance
>
>João Batista