Page 1 of 2
to Mr. Nages - xBrowse and LetoRDD
Posted: Wed Mar 07, 2012 1:20 pm
by 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
Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Wed Mar 07, 2012 1:45 pm
by 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.
Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Wed Mar 07, 2012 2:00 pm
by lucasdebeltran
Hola,
Tienes que usar un cliente cvs, por ejemplo tortoise, o este:
http://www.syntevo.com/smartcvs/download.htmlY 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.htmlLetoDB es una pasada. Estoy haciendo pruebas con mi aplicación y no he tenido que tocar apenas nada de código.
Un saludo
Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Wed Mar 07, 2012 3:39 pm
by FiveWiDi
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,
Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Wed Mar 07, 2012 8:09 pm
by lucasdebeltran
Hi,
We have a Windows 2008 hired at an ISP.
Yes, I am accesing data via Internet.
Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Fri Mar 09, 2012 8:52 am
by lucasdebeltran
Hello,
Please, any clue?.
Thank you very much!!!!!!
Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Sat Mar 10, 2012 3:34 am
by 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
Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Sat Mar 10, 2012 9:23 am
by 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.htmlTo 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
Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Sat Mar 10, 2012 4:14 pm
by 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
Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Sat Mar 10, 2012 4:45 pm
by 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
Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Sun Mar 11, 2012 10:29 am
by 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,
Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Mon Mar 12, 2012 5:10 am
by 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
lucasdebeltran wrote: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,
Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Mon Mar 12, 2012 7:41 am
by 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,
Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Mon Mar 12, 2012 8:34 am
by dutch
I downloade from SourceForge.net.
http://letodb.cvs.sourceforge.net/viewvc/letodb/Where do I get the latest version?
Regards,
Dutch
Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Mon Mar 12, 2012 8:51 am
by 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.