Sintaxis del comando shape
Tengo en vb6 el siguiente comando
SHAPE {select codprov, nomprov from proveedores where codprov collate database_default in (select distinct codprov from impfaltante order by codprov} AS P1 APPEND ((SHAPE {select distinct codprod, codprov from impfaltante } AS P2 APPEND ((SHAPE {select codven, nomven, fecha, codprod, descrip, cantidad, cliente, codprov, precio, cantidad * precio as total, fechaarribo, backorder, yapedido, c_categoria from impfaltante a inner join bms_data_partesdecamion.dbo.inv_cate b on a.codprod = b.cod_prod order by codprod, fecha,cantidad } AS P3 APPEND ({SELECT * FROM faltantereemplazo } AS P4 RELATE 'CODVEN' TO 'CODVEN', 'CODPROD' TO 'CODPROD', 'NOMVEN' TO 'NOMVEN', 'FECHA' TO 'FECHA', 'CANTIDAD' TO 'CANTIDAD', 'CLIENTE' TO 'CLIENTE' )) AS P4 RELATE 'CODPROD' TO 'CODPROD', 'CODPROV' TO 'CODPROV')) AS P3 RELATE 'CODPROV' TO 'CODPROV') AS P2
Me genera el error ' incorrect syntax near ';'
Alguna sugerencia
Gracias
SHAPE {select codprov, nomprov from proveedores where codprov collate database_default in (select distinct codprov from impfaltante order by codprov} AS P1 APPEND ((SHAPE {select distinct codprod, codprov from impfaltante } AS P2 APPEND ((SHAPE {select codven, nomven, fecha, codprod, descrip, cantidad, cliente, codprov, precio, cantidad * precio as total, fechaarribo, backorder, yapedido, c_categoria from impfaltante a inner join bms_data_partesdecamion.dbo.inv_cate b on a.codprod = b.cod_prod order by codprod, fecha,cantidad } AS P3 APPEND ({SELECT * FROM faltantereemplazo } AS P4 RELATE 'CODVEN' TO 'CODVEN', 'CODPROD' TO 'CODPROD', 'NOMVEN' TO 'NOMVEN', 'FECHA' TO 'FECHA', 'CANTIDAD' TO 'CANTIDAD', 'CLIENTE' TO 'CLIENTE' )) AS P4 RELATE 'CODPROD' TO 'CODPROD', 'CODPROV' TO 'CODPROV')) AS P3 RELATE 'CODPROV' TO 'CODPROV') AS P2
Me genera el error ' incorrect syntax near ';'
Alguna sugerencia
Gracias