Re: Oracle to dbf, again
From: Anders Altberg (x_pragma_at_telia.com)
Date: 06/02/04
- Next message: madge: "FoxPro's command and SQL"
- Previous message: Anders Altberg: "Re: is it possibble : array with 18 column and over 10000 rows ?"
- In reply to: josepe: "Oracle to dbf, again"
- Next in thread: josepe: "Re: Oracle to dbf, again"
- Reply: josepe: "Re: Oracle to dbf, again"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 3 Jun 2004 00:28:39 +0200
Hi Josepe
Does the query work if you insert it directly in the SQLEXEC function? Is
there an error message you can pick up with AERROR?
It's surprising that you join two tables, VTA_DETMP ans VTA_MOVm, (from two
different database?), without any references to primary and foreign keys
that relate them.
Have you checked the the variable h has a numeric value?
-Anders
josepe" <ENEMIGODELSPAMbuzon@navegante.com.sv> wrote in message
news:40BDF262.2030908@navegante.com.sv...
> Here my code, but it is emerging a funtion error in this line:
> x = SQLEXEC(h, lcSQL, 'cursor1' )
> I'm using VFP6; may be this version don't support the command. As this
> fail I can't see any data of the query. Plz help me.
> ..............................................
> PUBLIC h, lcSQL
> h=SQLCONNECT("mydatabank")
> * this opens a window where you can select the ODBC DSN for this Oracle
> database.
> *If you know the name of the DSN you can use it:
>
> TEXT TO lcSQL NOSHOW
> SELECT VTA_DETMP.COD_CIA, VTA_DETMP.COD_SUCURSAL, VTA_DETMP.COD_DOCTOCC,
> VTA_DETMP.NUM_DOCTO, VTA_DETMP.SECUENCIA, VTA_DETMP.COD_BODEGA,
> VTA_DETMP.COD_PROD, VTA_DETMP.CANTIDAD, VTA_DETMP.PRECIO_VTA,
> FROM FACTUR.VTA_DETMP VTA_DETMP, IMPO.VTA_MOVM VTA_MOVM
> WHERE (VTA_DETMP.COD_BODEGA=5) AND (VTA_MOVM.FECHA_DOCTO={ts '2004-05-31
> 00:00:00'})
> ENDTEXT
> x = SQLEXEC(h, lcSQL, 'cursor1' )
>
> IF x <= 0 && the query did not succed.
> AERROR(aa)
> ELSE
> SELECT cursor1
> BROWSE NOWAIT
> ENDIF
>
- Next message: madge: "FoxPro's command and SQL"
- Previous message: Anders Altberg: "Re: is it possibble : array with 18 column and over 10000 rows ?"
- In reply to: josepe: "Oracle to dbf, again"
- Next in thread: josepe: "Re: Oracle to dbf, again"
- Reply: josepe: "Re: Oracle to dbf, again"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
