FiveTech Support Forums

 TEXT into cSql
      Select
      p.id AS c1,
      p.idsucursal AS c2,
      p.iddistribuidor AS c3,
      p.nombre AS c4,
      pr.id AS c5,
      pr.idsucursal AS c6,
      pr.idproducto AS c7,
      pr.fecha AS c8,
      pr.importe AS c9,
      pr.stock AS c10,
      pr.stockminimo AS c11,
      pr.ganancia AS c12
      FROM tbprod p
      Left join tbprecio pr
      ON pr.idproducto = p.id
      WHERE p.id = ::nId
      ENDTEXT

TEXT INTO cSql
      SELECT
          p.id AS c1,
          p.idsucursal AS c2,
          p.iddistribuidor AS c3,
          p.nombre AS c4,
          pr.id AS c5,
          pr.idsucursal AS c6,
          pr.idproducto AS c7,
          pr.fecha AS c8,
          pr.importe AS c9,
          pr.stock AS c10,
          pr.stockminimo AS c11,
          pr.ganancia AS c12
      FROM tbprod AS p
      LEFT JOIN tbprecio AS pr
          ON pr.idproducto = p.id
      WHERE p.id = ?
ENDTEXT

cSql := FW_AdoApplyParams( cSql, { ::nId } )