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.