lenasi Posted January 30, 2008 Report Share Posted January 30, 2008 Sei que o Count TO, obtem a quantidade de registros de um dbf. Minha dúvida : Existe um que seja mais rápido? Pois se um dbf for muito grande, há uma demora para obter a qtde... Os registros deletados, são considerados ? LENASI FWh 2.6 + xHArbour 0.99 + WS + xDev 0.65 lenasi@hotmail.com Editado por - lenasi on 01/02/2008 21:37:50 Quote Link to comment Share on other sites More sharing options...
lenasi Posted January 30, 2008 Author Report Share Posted January 30, 2008 Sei que o Count TO, obtem a quantidade de registros de um dbf. Minha dúvida : Existe um que seja mais rápido? Pois se um dbf for muito grande, há uma demora para obter a qtde... Os registros deletados, são considerados ? LENASI FWh 2.6 + xHArbour 0.99 + WS + xDev 0.65 lenasi@hotmail.com Editado por - lenasi on 01/02/2008 21:37:50 Quote Link to comment Share on other sites More sharing options...
sygecom Posted January 30, 2008 Report Share Posted January 30, 2008 Se vc usa DBFCDX pode assim: vTOT_REG=OrdKeyCount() Leonardo Machado Porto Alegre-RS Hwgui + Mysql / xHarbour 0.99.70 / BCC55 / Vrmm / xDev /Migrando aos Pouco para Fivewin 2.7 + PostgreSql Quote Link to comment Share on other sites More sharing options...
lenasi Posted January 30, 2008 Author Report Share Posted January 30, 2008 citação:Se vc usa DBFCDX pode assim: vTOT_REG=OrdKeyCount() Leonardo Machado Porto Alegre-RS Hwgui + Mysql / xHarbour 0.99.70 / BCC55 / Vrmm / xDev /Migrando aos Pouco para Fivewin 2.7 + PostgreSql id=quote>id=quote>Uso sin DBFCDX, mas usando este ORdKeyCount(), percebi que ele considera qtde de registro somando os que foram deletados... LENASI FWh 2.6 + xHArbour 0.99 + WS + xDev 0.65 lenasi@hotmail.com Quote Link to comment Share on other sites More sharing options...
sygecom Posted January 30, 2008 Report Share Posted January 30, 2008 Fez o teste usando "SET DELE ON" Leonardo Machado Porto Alegre-RS Hwgui + Mysql / xHarbour 0.99.70 / BCC55 / Vrmm / xDev /Migrando aos Pouco para Fivewin 2.7 + PostgreSql Quote Link to comment Share on other sites More sharing options...
lenasi Posted January 31, 2008 Author Report Share Posted January 31, 2008 citação:Fez o teste usando "SET DELE ON" Leonardo Machado Porto Alegre-RS Hwgui + Mysql / xHarbour 0.99.70 / BCC55 / Vrmm / xDev /Migrando aos Pouco para Fivewin 2.7 + PostgreSql id=quote>id=quote>TAMBÉM FIZ ESTE TESTE, TANTO ON QTO OFF LENASI FWh 2.6 + xHArbour 0.99 + WS + xDev 0.65 lenasi@hotmail.com Quote Link to comment Share on other sites More sharing options...
SHARK Posted January 31, 2008 Report Share Posted January 31, 2008 Eu uso OrdKeyNo() no fim do arquivo assim: CLIENTES->( DbGoBottom() ) nTotal := CLIENTES->OrdKeyNo() Shark - FWH 2.6 / xharbour 0.99.5 / xMate 1.15 / Resource WorkShop Quote Link to comment Share on other sites More sharing options...
lenasi Posted January 31, 2008 Author Report Share Posted January 31, 2008 citação:Eu uso OrdKeyNo() no fim do arquivo assim: CLIENTES->( DbGoBottom() ) nTotal := CLIENTES->OrdKeyNo() Shark - FWH 2.6 / xharbour 0.99.5 / xMate 1.15 / Resource WorkShop id=quote>id=quote>FIZ ASSIM : SELECT USUARIO SET ORDER TO 1 USUARIO->(DbGoBottom()) nTRegUsua := OrdKeyNo() Msginfo(str(OrdKeyNo())) OU Msginfo(str(nTRegUsua)) DELETEI REGISTRO, MESMO ASSIM ESTà CONTANDO-OS!!! LENASI FWh 2.6 + xHArbour 0.99 + WS + xDev 0.65 lenasi@hotmail.com Quote Link to comment Share on other sites More sharing options...
vagner Posted February 1, 2008 Report Share Posted February 1, 2008 Olá, Coloque na indexação For !Deleted() Vagner Wirts VI Encontro está chegando , não perca Quote Link to comment Share on other sites More sharing options...
joaosolution Posted February 1, 2008 Report Share Posted February 1, 2008 Srs. Já tentou usar LastRec() arquivo->( LastRec() ) Att João Bosco Clip 5.3b FW 2.6 FWH 2.6 xHarbour 99.1 WorkShop 4.5 Quote Link to comment Share on other sites More sharing options...
lenasi Posted February 1, 2008 Author Report Share Posted February 1, 2008 Foi resolvido da seguinte forma: Colocando FOR !Deleted() CLIENTES->( DbGoBottom() ) nTotal := CLIENTES->OrdKeyNo() Mais uma vez obrigado a todos.... LENASI FWh 2.6 + xHArbour 0.99 + WS + xDev 0.65 lenasi@hotmail.com Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.