FiveTech Software tech support forums

... from: => EVAL( 0 ) Called from: .\source\prg\tdolpsrv.prg => TDOLPHINSRV:CHECKERROR( 836 ) Called from: .\source\prg\tdolpqry.prg => (b)TDOLPHINQRY:TDOLPHINQRY( 133 ) Called from: => TDOLPHINQRY:CHECKERROR( 0 ) Called from: .\source\prg\tdolpqry.prg => TDOLPHINQRY:SAVE( 1480 ) ...

oQry := TDolphinQry():New( "SELECT * FROM materiales order by serialpc", oServer ) if oQry:Seek( rNueva0,"serialpc" )== 0 ? "no hay nada de nada" else ? "si esta el registro" oQry:dias=Str(cTequedan) ...

... 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 => GRABALINEA( 411 ) Called from: c:\disco-d\programs\ventasql\prgh\Remitos.prg ...

... 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( 333 ) Called from: D:\Programs\ESTUDI~1\PRG\deudor.prg => ...

... subido los cambios al repositorio. Lo que pasaba es que no se generaba bien el array aColumns, prueba de cambiar el metodo BuildDatas de la clase tDolphinQry METHOD BuildDatas( cQuery ) CLASS TDolphinQry   LOCAL aToken, cItem, cSelect, cTables, cFind,nPos   LOCAL aCommands ...

... *********************************************************** METHOD SetNewFilter( nType, cFilter, lRefresh ) CLASS TDolphinQry ************************************************************ LOCAL cOldFilter LOCAL l := .T. DEFAULT lRefresh TO .T. SWITCH nType CASE SET_WHERE ...

HOW TO MAKE ? IN TDOLPHIN oQry := TDolphinQry():New("select * from country ", oServer ) oQry:setWhere("name like '%REPLUBLICA%'",.T.) // QUERY RESULT -> select * from country where name like '%REPLUBLICA% to clean oQry:setWhere("",.T.) ...

... veja: https://bitbucket.org/danielgarciagil/tdolphin/downloads please, replace in tdolqry.prg, recompile and test. METHOD GetRow( nRow ) CLASS TDolphinQry LOCAL cType, uValue, cField LOCAL cCol LOCAL nIdx LOCAL aRow LOCAL hRow, uItem, aStructure, nPad DEFAULT nRow TO ::nRecNo IF ::hResult <> ...

Gracias!

Lo que estaba haciendo gracias a Carlos que me guio desde el principio me funcionó ,
lo que estaba mal era que yo ponia TDOLPHINQRY y debia ser TDOLPHINSRV gracias
a ambos!

Solucionado.

... as many as 15000 rows, I have to transform it to an array to do some operations on the data. Rigth now I'm doing this. Local xArr:={} Local xDb:=tDolphinQry():New("select f1, f2, f3 from xTable", oSvr) Local x:=0 For x=1 to xDb:nRecCount xDb:getRow() Aadd(xArr,{f1,f2,f3,1,.F.}) xDb:Skip() ...

... 15.000 filas, y debo si o si pasarlos a una array por diversos manejos y calculos que hago con ellos. Ahora hago esto. Local xArr:={} Local xDb:=tDolphinQry():New("select f1, f2, f3 from xTable", oSvr) Local x:=0 For x=1 to xDb:nRecCount xDb:getRow() Aadd(xArr,{f1,f2,f3,1,.F.}) xDb:Skip() ...

... Called from: => ALLTRIM( 0 ) Called from: .\source\prg\tdolpsrv.prg => CLIPVALUE2SQL( 1955 ) Called from: .\source\prg\tdolpqry.prg => TDOLPHINQRY:SEEK( 1376 ) Called from: T:\new\fivewin\xbrowse.prg => TXBRWCOLUMN:SETORDER( 11902 ) Called from: T:\new\fivewin\xbrowse.prg => TXBRWCOLUMN:HEADERLBUTTONUP( ...

... 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( 310 ) Called from: .\source\prg\tdolpsrv.prg => TDOLPHINSRV:QUERY( ...

... 'update slbdactg set contador = contador + 1 WHERE campo = `BCOAGECC` ;’ cQry += 'select contador from slbdactg WHERE campo = `BCOAGECC` ' oQry := TDolphinQry:New(cQry,::nServer) Error description: Error MYSQL/1064 You have an error in your SQL syntax; check the manual that corresponds to your ...

... 2291 ) Called from: .\source\prg\tdolpsrv.prg => TDOLPHINSRV:CHECKERROR( 671 ) Called from: .\source\prg\tdolpqry.prg => (b)TDOLPHINQRY:TDOLPHINQRY( 130 ) Called from: => TDOLPHINQRY:CHECKERROR( 0 ) Called from: .\source\prg\tdolpqry.prg => TDOLPHINQRY:GETROW( 954 ) ...