FiveTech Software tech support forums

... Error description: Error MYSQL/1051 Unknown table 'v' y el error que me muestra la query, pero me la cambia no sale completo : TDOLPHINSRV:SQLQUERY Param 1: C "SELECT v.*, (select count(*) FROM vendido ve WHERE ve.COD_INTERNO=v.codigo_control) AS npasaje ORDER BY v.fecha_salida,v.hora_salida,v.nom_viaje" ...

Utilizo lo siguiente sin inconvenientes
::oServer:SqlQuery(cQuery )

... otras maneras de grabar la variable y sin resultados me vi forzado a ejecutar el siguiente Query para q grabe la informacion correctamente oConex:SqlQuery("UPDATE movimdet SET igv="+ALLTRIM(STR(::vGet:nIgv))+",impdes="+ALLTRIM(STR(::vGet:nImpDes))+; " WHERE tipcpg='"+::vGet:cTipCpg+"' ...

... otras maneras de grabar la variable y sin resultados me vi forzado a ejecutar el siguiente Query para q grabe la informacion correctamente oConex:SqlQuery("UPDATE movimdet SET igv="+ALLTRIM(STR(::vGet:nIgv))+",impdes="+ALLTRIM(STR(::vGet:nImpDes))+; " WHERE tipcpg='"+::vGet:cTipCpg+"' ...

... 2807 ) Called from: .\source\prg\tdolpsrv.prg => TDOLPHINSRV:CHECKERROR( 793 ) Called from: .\source\prg\tdolpsrv.prg => TDOLPHINSRV:SQLQUERY( 2024 ) Called from: .\source\prg\tdolpqry.prg => TDOLPHINQRY:SAVE( 1456 ) Called from: c:\disco-d\programs\ventasql\prgh\Remitos.prg => ...

... objeto coneccion, la documentacion indica lo siguiente: METHOD Execute( cSqlStatement, [params], [lShowError] ) --> uResult (Can also use oCn:SqlQuery(...) ) uResult can be a) nil if there is no result or if error occured. In case of error, oCn:nError and oCn:cError provide teh error information ...

... OBJECT  ::oQVProv  Que muestra el dato tal como lo guardé mediante: oData:oServer:Insert(...) o cuando actualizo mediante oData:oServer:SqlQuery( cQry ) Luego para mostrarlo en un say, lo recupero con, en este caso: oQryPrv:= hA:oConn:Query( "SELECT * FROM provclie WHERE id_prvcli="+cIDProv ...

... 2822 ) Called from: .\source\prg\tdolpsrv.prg => TDOLPHINSRV:CHECKERROR( 793 ) Called from: .\source\prg\tdolpsrv.prg => TDOLPHINSRV:SQLQUERY( 2039 ) Called from: .\source\prg\tdolpqry.prg => TDOLPHINQRY:SAVE( 1456 ) Called from: D:\Programs\ESTUDI~1\PRG\deudor.prg => EDITDEU( ...

... ::Blank() this value is 0. 24. oCn ( ReadOnly Type: "O" ): ADO Connection object to the folder containing the DBF. Created if and when ::SqlQuery() method is called. Closed by the ::Close() method. Uses VFPOLEDB if installed when DBFCDX is used. METHODS METHODS 1. New( [ncArea], [cFile], ...

... and that may be complicating the process too much. The sql functionality was there for many years and is not used unless program calls the method SqlQuery() explicitly. Since you are not using it it should not concern you at all. TDatabase does not know anything about TRecord class of TData library. ...

... as SETGET method. - New Data: bEdit (format { |oRec|UserEdit( oRec ) } ) for user edit instead of default edit procedure. - Enhancement: Method SqlQuery() uses VFPOLEDB is installed for DBFCDX. - Added DESTRUCTOR method. oDbf := nil closes table and connections. * MENUS - Fixed: increase font ...

... as SETGET method. - New Data: bEdit (format { |oRec|UserEdit( oRec ) } ) for user edit instead of default edit procedure. - Enhancement: Method SqlQuery() uses VFPOLEDB is installed for DBFCDX. - Added DESTRUCTOR method. oDbf := nil closes table and connections.

... diplay in xbrowse. Functions similar to the ADO function. METHOD Execute( cSqlStatement, [params], [lShowError] ) --> uResult (Can also use oCn:SqlQuery(...) ) uResult can be a) nil if there is no result or if error occured. In case of error, oCn:nError and oCn:cError provide teh error information ...

... 2901 ) Called from: .\source\prg\tdolpsrv.prg => TDOLPHINSRV:CHECKERROR( 838 ) Called from: .\source\prg\tdolpsrv.prg => TDOLPHINSRV:SQLQUERY( 2099 ) Called from: .\source\prg\tdolpqry.prg => TDOLPHINQRY:LOADQUERY( 1230 ) Called from: .\source\prg\tdolpqry.prg => TDOLPHINQRY:NEW( ...

COMO ACTIVAS LA EJECUCION CON MULTIPLES SENTENCIAS ?