topic-23636

Posts: 1303

Joined: Tue Jul 21, 2009 08:12 AM

to Mr. Nages - xBrowse and LetoRDD
Posted: Wed Mar 07, 2012 01:20 PM

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

Muchas gracias. Many thanks.

Un saludo, Best regards,

Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]

Implementando MSVC 2010, FWH64 y ADO.

Abandonando uso xHarbour y SQLRDD.

FiveWiDi

Posts: 1445

Joined: Mon Oct 10, 2005 02:38 PM

Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Wed Mar 07, 2012 01:45 PM

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.

Un Saludo

Carlos G.

FiveWin 25.12 + Harbour 3.2.0dev (r2502110321), BCC 7.7 Windows 11 Home

lucasdebeltran

Posts: 1303

Joined: Tue Jul 21, 2009 08:12 AM

Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Wed Mar 07, 2012 02:00 PM

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

Muchas gracias. Many thanks.

Un saludo, Best regards,

Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]

Implementando MSVC 2010, FWH64 y ADO.

Abandonando uso xHarbour y SQLRDD.

FiveWiDi

Posts: 1445

Joined: Mon Oct 10, 2005 02:38 PM

Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Wed Mar 07, 2012 03:39 PM

lucasdebeltran wrote: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,

Un Saludo

Carlos G.

FiveWin 25.12 + Harbour 3.2.0dev (r2502110321), BCC 7.7 Windows 11 Home

lucasdebeltran

Posts: 1303

Joined: Tue Jul 21, 2009 08:12 AM

Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Wed Mar 07, 2012 08:09 PM

Hi,

We have a Windows 2008 hired at an ISP.

Yes, I am accesing data via Internet.

Muchas gracias. Many thanks.

Un saludo, Best regards,

Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]

Implementando MSVC 2010, FWH64 y ADO.

Abandonando uso xHarbour y SQLRDD.

lucasdebeltran

Posts: 1303

Joined: Tue Jul 21, 2009 08:12 AM

Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Fri Mar 09, 2012 08:52 AM

Hello,

Please, any clue?.

Thank you very much!!!!!!

Muchas gracias. Many thanks.

Un saludo, Best regards,

Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]

Implementando MSVC 2010, FWH64 y ADO.

Abandonando uso xHarbour y SQLRDD.

RAMESHBABU

Posts: 654

Joined: Fri Oct 21, 2005 05:54 AM

Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Sat Mar 10, 2012 03:34 AM

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

Posts: 1303

Joined: Tue Jul 21, 2009 08:12 AM

Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Sat Mar 10, 2012 09:23 AM

Hello,

Thanks for reply. Sure.

To download leto:

Code (fw): Select all Collapse

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 (fw): Select all Collapse

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

Muchas gracias. Many thanks.

Un saludo, Best regards,

Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]

Implementando MSVC 2010, FWH64 y ADO.

Abandonando uso xHarbour y SQLRDD.

dutch

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Sat Mar 10, 2012 04:14 PM

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 (fw): Select all Collapse

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 (fw): Select all Collapse

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

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

dutch

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Sat Mar 10, 2012 04:45 PM

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

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

lucasdebeltran

Posts: 1303

Joined: Tue Jul 21, 2009 08:12 AM

Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Sun Mar 11, 2012 10:29 AM

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,

Muchas gracias. Many thanks.

Un saludo, Best regards,

Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]

Implementando MSVC 2010, FWH64 y ADO.

Abandonando uso xHarbour y SQLRDD.

dutch

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Mon Mar 12, 2012 05:10 AM

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,

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

lucasdebeltran

Posts: 1303

Joined: Tue Jul 21, 2009 08:12 AM

Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Mon Mar 12, 2012 07:41 AM

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,

Muchas gracias. Many thanks.

Un saludo, Best regards,

Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]

Implementando MSVC 2010, FWH64 y ADO.

Abandonando uso xHarbour y SQLRDD.

dutch

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Mon Mar 12, 2012 08:34 AM

I downloade from SourceForge.net.

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

Where do I get the latest version?

Regards,
Dutch

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

lucasdebeltran

Posts: 1303

Joined: Tue Jul 21, 2009 08:12 AM

Re: to Mr. Nages - xBrowse and LetoRDD
Posted: Mon Mar 12, 2012 08:51 AM

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.

Muchas gracias. Many thanks.

Un saludo, Best regards,

Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]

Implementando MSVC 2010, FWH64 y ADO.

Abandonando uso xHarbour y SQLRDD.

FiveTech Support Forums