no me estaria haciendo lo que pretengo...

[goosfancito]

Hola.

Code: Select all  Expand view

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

me dice que la sintaxix del WHERE esta mal, cual seria la correcta?

[artu01]

viewtopic.php?f=6&t=38182&p=228072&hilit=endtext&sid=a35972a0e833e4feda67b45841e72e50#p228072

[anserkk]

Code: Select all  Expand view

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 } )

[goosfancito]

gracias a todos!