to Mr. Nages - xBrowse and LetoRDD

[lucasdebeltran]

Hello,

I am testing LetoDb RDD via Internet and xBrowse is a bit slow. But other functions (append, filter, locate, REPORT, FAST REPORT) do very well.

Is there any way to increase speed of xBrowse?.

Thank you very much. Best regads,

Lucas

[FiveWiDi]

Hola Lucas,

Veo que estas trabajando con LETODB, podrías decirme dónde lo has bajado?

Quiero probarlo y ver que tal va, como se integra en Harbour+FWH, etc.

He visto que indicabas el uso de "csv" para obtenerlo, pero nunca he sabido como usar esta "herramienta" (en este aspecto soy bastante ignorante).

Saludos
Carlos G.

[lucasdebeltran]

Hola,

Tienes que usar un cliente cvs, por ejemplo tortoise, o este: http://www.syntevo.com/smartcvs/download.html

Y ejecutar el comando.

Luego, tienes los .bat según el compilador de Harbour y C.

En samples tienes ejemplos.

Y en el blog de Biel tienes un artículo: http://bielsys.blogspot.com/2008/07/let ... -para.html

LetoDB es una pasada. Estoy haciendo pruebas con mi aplicación y no he tenido que tocar apenas nada de código.

Un saludo

[FiveWiDi]

Hola,

Tienes que usar un cliente cvs, por ejemplo tortoise, o este: http://www.syntevo.com/smartcvs/download.html

Y ejecutar el comando.

Luego, tienes los .bat según el compilador de Harbour y C.

En samples tienes ejemplos.

Y en el blog de Biel tienes un artículo: http://bielsys.blogspot.com/2008/07/let ... -para.html

LetoDB es una pasada. Estoy haciendo pruebas con mi aplicación y no he tenido que tocar apenas nada de código.

Un saludo

Gracias Lucas,

Estas probando en una Intranet o sales a Internet?

Si estás saliendo a Internet, que características debe soportar el servidor para poder usar LeToDB? Es público? Es tuyo?

Gracias,

[lucasdebeltran]

Hi,

We have a Windows 2008 hired at an ISP.

Yes, I am accesing data via Internet.

[lucasdebeltran]

Hello,

Please, any clue?.

Thank you very much!!!!!!

[RAMESHBABU]

Mr.Lucas,

Can you please share the reqired LIB file(s) and the test program ?

I am using xHarbour 1.2.1 (Simplex) + FWH + BCC582

Regards,

- Ramesh Babu P

[lucasdebeltran]

Hello,

Thanks for reply. Sure.

To download leto:

Code: Select all | Expand

cvs -d:pserver:anonymous@letodb.cvs.sourceforge.net:/cvsroot/letodb checkout -r rel-1-mt letodb

Here is a cvs.exe:
http://bitshare.com/files/685v2mh1/cvs.exe.html

To build server and lib, there are bats at letodir.


This is a sample:

Code: Select all | Expand

Function Main()


Local cPath := "//127.0.0.1:2812/letodb/"

   REQUEST LETO, DBFCDX

   RDDSETDEFAULT( "LETO" )


   IF leto_Connect( cPath ) == -1   // check errors
         MsgAlert( "Can't connect to server ..."+CRLF+CRLF+"Error: "+cValToChar(LETO_CONNECT_ERR())  )
         quit
   ENDIF




   use ( cPath+"customer" ) SHARED New
   dbgotop()

   xbrowse()
   dbcloseall()

  QUIT


Return Nil

To this sample, add rddleto.lib.


I can also provide access to a public internet server. If interested, please indicate me your mail.


Using leto in local mode works very fast.

The problem is when accesing data via Internet, particulary xBrowse.

The rest of opperations (APPEND, LOCATE, SEEK, SET FILTER, ...) do very well via Internet, but not xBrowse.

Thank you very much.



Best regards,

Lucas

[dutch]

Dear Lucas,

I am really interesting, could you give the internet example.

I try to compile Leto Server but it do nothing. I use make_b32.bat with BCC55.

Code: Select all | Expand

D:\letodb>make_b32

                      PBMake 2.17G  for Clipper, C and ASM
                   ฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤฤ
       Copyright (C) 1995-98 Phil Barnett, All Rights Reserved Worldwide

Make File -L.MAK was not found
 

The mistake must be this line

Code: Select all | Expand

make -l EXE_OBJ_DIR=obj\b32\bin OBJ_DIR=obj\b32 -fmakefile.bc %1 %2 %3 > make_b32.log
 

How do I get it?

Thanks,
Dutch

[dutch]

Dear Lucas,

I've got the new error. I use HARBOUR 3.1 from FW and BCC582.

MAKE Version 5.2 Copyright (c) 1987, 2000 Borland
IF EXIST "bin\letodb.exe" del "bin\letodb.exe" > NUL
bcc32 @MAKE0001.@@@
Borland C++ 5.5.1 for Win32 Copyright (c) 1993, 2000 Borland
Turbo Incremental Link 5.00 Copyright (c) 1997, 2000 Borland
Error: Unresolved external '_HB_FUN_HB_CODEPAGE_HR437' referenced from D:\LETODB\OBJ\B32\SERVER.OBJ
Error: Unresolved external '_HB_FUN_HB_CODEPAGE_RUWIN' referenced from D:\LETODB\OBJ\B32\SERVER.OBJ
Error: Unresolved external '_HB_FUN___CLSACTIVE' referenced from D:\LETODB\OBJ\B32\SERVER.OBJ
Error: Unresolved external '_hb_retcAdopt' referenced from D:\LETODB\OBJ\B32\LETOFUNC.OBJ
Error: Unresolved external '_hb_itemPutDTL' referenced from D:\LETODB\OBJ\B32\LETOFUNC.OBJ
Error: Unresolved external '_hb_GetSetStructPtr' referenced from D:\LETODB\OBJ\B32\LETOFUNC.OBJ

[lucasdebeltran]

Hello,

I use Harbour 3.1 and BCC 5.8.2 and I built it without problem using make_b32.bat

Please check paths at makefile.bc

I choose SRV_MODE = __CONSOLE__

Hope it helps.

Regards,

[dutch]

Dear Lucas,

I try as your mention, change in Makefile.bc and I use Harbour 3.1 and BCC582 too. I've got error as below.

MAKE Version 5.2 Copyright (c) 1987, 2000 Borland
bcc32 -c -Iinclude;D:\HARBOUR\include -d -tWM -D__WIN32__ -D__CONSOLE__ -oobj\b32\leto1.obj source\client\leto1.c
Borland C++ 5.5.1 for Win32 Copyright (c) 1993, 2000 Borland
source\client\leto1.c:
Warning W8075 source\client\leto1.c 442: Suspicious pointer conversion in function leto_ConnectionNew
Error E2451 source\client\leto1.c 2218: Undefined symbol 'UINT16' in function letoPutValue
Error E2293 source\client\leto1.c 2218: ) expected in function letoPutValue
Warning W8065 source\client\leto1.c 4945: Call to function 'ISNUM' with no prototype in function HB_FUN_LETO_BEGINTRANSACTION
Warning W8065 source\client\leto1.c 4962: Call to function 'ISNIL' with no prototype in function HB_FUN_LETO_ROLLBACK
Warning W8065 source\client\leto1.c 4962: Call to function 'ISLOG' with no prototype in function HB_FUN_LETO_ROLLBACK
Warning W8065 source\client\leto1.c 4982: Call to function 'ISLOG' with no prototype in function HB_FUN_LETO_COMMITTRANSACTION
Warning W8065 source\client\leto1.c 5029: Call to function 'ISCHAR' with no prototype in function HB_FUN_LETO_SUM
Warning W8065 source\client\leto1.c 5038: Call to function 'ISCHAR' with no prototype in function HB_FUN_LETO_SUM
Warning W8065 source\client\leto1.c 5185: Call to function 'ISNIL' with no prototype in function HB_FUN_LETO_SETFASTAPPEND
Warning W8065 source\client\leto1.c 5196: Call to function 'ISCHAR' with no prototype in function HB_FUN_LETO_CLOSEALL
*** 2 errors in Compile ***

** error 1 ** deleting obj\b32\leto1.obj

Hello,

I use Harbour 3.1 and BCC 5.8.2 and I built it without problem using make_b32.bat

Please check paths at makefile.bc

I choose SRV_MODE = __CONSOLE__

Hope it helps.

Regards,

[lucasdebeltran]

Dutch,

How do you get Leto source code?.

It seems you are using an old version, as in latest 2.43 ISNIL, etc calls are properly converted to HB_ISNILL.

Best regards,

[dutch]

I downloade from SourceForge.net.

http://letodb.cvs.sourceforge.net/viewvc/letodb/

Where do I get the latest version?

Regards,
Dutch

[lucasdebeltran]

Please, use this command:

cvs -d:pserver:anonymous@letodb.cvs.sourceforge.net:/cvsroot/letodb checkout -r rel-1-mt letodb

You are not downloading the latest version.

The same happened to me at first time.