Ayuda con la migracion
Publicado por Jorge Cruz (30 intervenciones) el 16/09/2008 04:50:42
Hola a todos, alguien que me pueda ayudar, migre mi proyecto de VFP 6 a VFP 9, recompile y me sale el siguiente error:
Compiling c:sdinewactstinc.prg
Select codclie,tipodoc,fec_mov,docabrev,seriedoc,nrodoc,idprod,concepto,cantidad,tipomovi from sm!movid Where movid.idprod = cidProd and fechaemi between Fec_ini and Fec_Fin and anulada = .F. Union All (Select codclie,tipodoc,fec_mov,docabrev,seriedoc,nrodoc,idprod,concepto,cantidad,tipomovi from sm!movicomd Where movicomd.idprod = cidProd and fechaemi between Fec_ini and Fec_Fin and anulada = .F. Union All (Select codigo,tipodocf,fechaemf,docabrf,serdocf,nrodocf,idprod,concepto,cantidad,tipomovi from sm!movingd Where movingd.idprod = cIdprod and fechaemf between Fec_ini and Fec_Fin and Tipmov <> 2 and anulada = .F. Union All (Select codigo,tipodocf,fechaemf,docabrf,serdocf,nrodocf,idprod,concepto,cantidad,tipomovi from sm!movsald Where movsald.idprod = cIdprod and fechaemf between Fec_ini and Fec_Fin and anulada = .F.))) Order By 3,10 Into cursor v_Kardex
Error in line 38: Only a single SQL SELECT statement can be enclosed in parentheses.
Gracias de antemano-
Jbc.
Compiling c:sdinewactstinc.prg
Select codclie,tipodoc,fec_mov,docabrev,seriedoc,nrodoc,idprod,concepto,cantidad,tipomovi from sm!movid Where movid.idprod = cidProd and fechaemi between Fec_ini and Fec_Fin and anulada = .F. Union All (Select codclie,tipodoc,fec_mov,docabrev,seriedoc,nrodoc,idprod,concepto,cantidad,tipomovi from sm!movicomd Where movicomd.idprod = cidProd and fechaemi between Fec_ini and Fec_Fin and anulada = .F. Union All (Select codigo,tipodocf,fechaemf,docabrf,serdocf,nrodocf,idprod,concepto,cantidad,tipomovi from sm!movingd Where movingd.idprod = cIdprod and fechaemf between Fec_ini and Fec_Fin and Tipmov <> 2 and anulada = .F. Union All (Select codigo,tipodocf,fechaemf,docabrf,serdocf,nrodocf,idprod,concepto,cantidad,tipomovi from sm!movsald Where movsald.idprod = cIdprod and fechaemf between Fec_ini and Fec_Fin and anulada = .F.))) Order By 3,10 Into cursor v_Kardex
Error in line 38: Only a single SQL SELECT statement can be enclosed in parentheses.
Gracias de antemano-
Jbc.
Valora esta pregunta


0