Usando LetoDBf

[LolaThick133]

letodb e letodbf são bibliotecas diferentes para acesso a bancos de dados em xHarbour, ambas feitas em Harbour e compatíveis com xHarbour e Harbour.
Escolha entre letodb e letodbf com base nas necessidades do seu banco de dados. letodb é mais genérico, enquanto letodbf é específico para DBF.
Para mudar de DBF para CDX, use dbfsetdriver("DBFCDX"), garantindo a configuração correta do driver em seu ambiente.
Bases de dados em servidor devem ter reindexações e índices temporários no mesmo local, geralmente transparente para o usuário.
Ao usar set filter e WHEN FOR em índices, considere possíveis limitações dependendo do tipo de índice e do banco de dados.

[deividdjs]

bom dia amigos .. blz?

qual a versão mais estável do LETODBF ?? gostaria de implementar no meu sistema ... uso HARBOUR 3.2

onde baixo e como começo ??

Abraço a todos!

Deivid

[Itamar M. Lins Jr.]

Olá!

onde baixo e como começo ??

https://pctoledo.org/forum/viewto ... 43&t=25904

Saudações,
Itamar M. Lins Jr.

[deividdjs]

Não compila com BCC 5.8 ??

[Itamar M. Lins Jr.]

Olá!
As pessoas que fezeram o LetoDb e o LetoDBf não usam BCC. O padrão é o GCC.
Tem uns exemplos ai pela internet usando BCC, só que perde a compactação dos dados na rede e não sei mais o quê que fica fora.

Código: Selecionar todos

     2.2 Borland Win32 C++ compiler
      2.3 Old MS Visual C compiler

 If the above described way to compile with ".hbp" files does not work ( wrong setup ?, no hbmk2 ),
 for BCC and old older MsVc exists a make_b32.bat and a make_vc.bat. Look into, adapt OS search
 paths to point to Harbour and your C-compiler executable. Further important is to set:
 "HB_PATH" to point to the base! directory of Harbour, e.g. "C:\harbour"
 Called without argument these build the C-API client library, called with "full" as first argument
 they build LetoDBf server and Harbour client library.
 You will know what to do, are on your own. I use them only for sporadic compile tests.

 BCC55 and maybe also newer ones have a problem with compiling LZ4 compression library, you will
 get this case slower ZLib compression. This must fit together for client lib and server when you
 want to use network traffic compression. It is configured by this "{!bcc}" at top in the ".hbp" files.

Saudações,
Itamar M. Lins Jr.

[deividdjs]

Bom dia amigos ..

qual a melhor versão do GCC ?? onde eu posso baixar simplificado e de facil instalação ??

[Itamar M. Lins Jr.]

Olá!
Eu uso essa:

Código: Selecionar todos

hbmk2 -build
hbmk2: Processando script local: hbmk.hbm
Harbour 3.2.0dev (r2405092123)
Copyright (c) 1999-2021, https://harbour.github.io/

Harbour Build Info
---------------------------
Version: Harbour 3.2.0dev (r2405092123)
Compiler: MinGW GNU C 14.1 (64-bit)
Platform: Windows 10 10.0
PCode version: 0.3
ChangeLog last entry: 2024-05-09 23:23 UTC+0200 Przemyslaw Czerpak (druzus/at/poczta.onet.pl)
ChangeLog ID: 082e33cd5b5068974abf7d6aa33d747a7d13b597
Built on: May 10 2024 10:27:33
Build options: (Clipper 5.3b) (Clipper 5.x undoc)
---------------------------

Atualizei agora com a nova função do harbour.

Saudações,
Itamar M. Lins Jr.

[Itamar M. Lins Jr.]

Olá!
Use o msys2.
https://github.com/msys2/msys2-installe ... 240507.exe
Depois clicar no icone do msys2

Código: Selecionar todos

$ pacman -S git base-devel msys2-devel mingw-w64-{i686,x86_64}-toolchain

Depois:

Código: Selecionar todos

pacman -Syu

Depois baixar o harbour direto do GIT.

Código: Selecionar todos

git clone --depth=20 https://github.com/harbour/core.git harbour-core

win-make clean install ou make clean install(vai depender se está no prompt do msys2 ou fora dele.)
Eu tenho o GIT do tortoise(não lembro mais onde baixei)

Código: Selecionar todos

git -v
git version 2.41.0.windows.1

Saudações,
Itamar M. Lins Jr.

[deividdjs]

deu erro no primeiro processo ...

[Itamar M. Lins Jr.]

Olá!

Código: Selecionar todos

 pacman -S git base-devel msys2-devel mingw-w64-{i686,x86_64}-toolchain

ou esse que é mais novo.

Código: Selecionar todos

$ pacman -S mingw-w64-ucrt-x86_64-gcc

Saudações,
Itamar M. Lins Jr.

[Itamar M. Lins Jr.]

Olá!
Esse msys2 é o mais novo usa UCRT!!!

UCRT (Universal C Runtime) is a newer version which is also used by Microsoft Visual Studio by default. It should work and behave as if the code was compiled with MSVC.

Better compatibility with MSVC, both at build time and at run time.
It is included as part of the operating system in Windows 10 or later, and Windows Server 2016 or later. For older Windows versions, you have to provide it explicitly or depend on the user having it installed. More information about that can be found in UCRT deployment.

Quando eu fiz isso tem muitos anos. Vou mudar para esse dai.

O meu é esse MINGW64 /mingw64. Vou trocar para o UCRT.

Saudações,
Itamar M. Lins Jr.

[Itamar M. Lins Jr.]

Olá!
Já me bati muito com o msys2.
Mas é o seguinte, até onde aprendi, ele instala agora até 6(seis) versões de compiladores, 2(dois)GCC(32/64), 2(dois)CLANG(32/64), 1 CLANGARM64(ANDROID), 1 UCRT64(MSVC-NATIVO Windows) *NOVO*
Pode usar ele dentro clicando nos icones->prompt($) ou por fora via CMD do windows.
Já fiz muita confusão com isso.

Saudações,
Itamar M. Lins Jr.

[Itamar M. Lins Jr.]

Olá!
Instalei o UCRT64 e vou testar agora!

Código: Selecionar todos

Itamar@DESKTOP-MP8Q5KH UCRT64 ~
$ pacman -S mingw-w64-ucrt-x86_64-gcc
resolving dependencies...

looking for conflicting packages...

Packages (16) mingw-w64-ucrt-x86_64-binutils-2.42-2
              mingw-w64-ucrt-x86_64-crt-git-11.0.0.r731.g8fdf7c9b5-1
              mingw-w64-ucrt-x86_64-gcc-libs-14.1.0-2
              mingw-w64-ucrt-x86_64-gettext-runtime-0.22.5-2  mingw-w64-ucrt-x86_64-gmp-6.3.0-2
              mingw-w64-ucrt-x86_64-headers-git-11.0.0.r731.g8fdf7c9b5-1
              mingw-w64-ucrt-x86_64-isl-0.26-1  mingw-w64-ucrt-x86_64-libiconv-1.17-4
              mingw-w64-ucrt-x86_64-libwinpthread-git-11.0.0.r731.g8fdf7c9b5-1
              mingw-w64-ucrt-x86_64-mpc-1.3.1-2  mingw-w64-ucrt-x86_64-mpfr-4.2.1-2
              mingw-w64-ucrt-x86_64-windows-default-manifest-6.4-4
              mingw-w64-ucrt-x86_64-winpthreads-git-11.0.0.r731.g8fdf7c9b5-1
              mingw-w64-ucrt-x86_64-zlib-1.3.1-1  mingw-w64-ucrt-x86_64-zstd-1.5.6-2
              mingw-w64-ucrt-x86_64-gcc-14.1.0-2

Total Download Size:    65.10 MiB
Total Installed Size:  501.40 MiB

:: Proceed with installation? [Y/n] Y
:: Retrieving packages...
 mingw-w64-ucrt-x86_64-crt-...     4.4 MiB   686 KiB/s 00:07 [###############################] 100%
 mingw-w64-ucrt-x86_64-gcc-...  1030.0 KiB   118 KiB/s 00:09 [###############################] 100%
 mingw-w64-ucrt-x86_64-libi...   719.2 KiB   372 KiB/s 00:02 [###############################] 100%
 mingw-w64-ucrt-x86_64-isl-...  1452.1 KiB  77.7 KiB/s 00:19 [###############################] 100%
 mingw-w64-ucrt-x86_64-zstd...   636.4 KiB   233 KiB/s 00:03 [###############################] 100%
 mingw-w64-ucrt-x86_64-mpfr...   535.7 KiB   410 KiB/s 00:01 [###############################] 100%
 mingw-w64-ucrt-x86_64-gmp-...   578.5 KiB   150 KiB/s 00:04 [###############################] 100%
 mingw-w64-ucrt-x86_64-gett...   297.3 KiB   210 KiB/s 00:01 [###############################] 100%
 mingw-w64-ucrt-x86_64-mpc-...   128.3 KiB   165 KiB/s 00:01 [###############################] 100%
 mingw-w64-ucrt-x86_64-winp...    40.0 KiB  65.1 KiB/s 00:01 [###############################] 100%
 mingw-w64-ucrt-x86_64-libw...    29.2 KiB  50.0 KiB/s 00:01 [###############################] 100%
 mingw-w64-ucrt-x86_64-wind...     3.0 KiB  7.15 KiB/s 00:00 [###############################] 100%
 mingw-w64-ucrt-x86_64-zlib...    92.1 KiB  29.3 KiB/s 00:03 [###############################] 100%
 mingw-w64-ucrt-x86_64-binu...     5.8 MiB   189 KiB/s 00:31 [###############################] 100%
 mingw-w64-ucrt-x86_64-head...     6.1 MiB   193 KiB/s 00:32 [###############################] 100%
 mingw-w64-ucrt-x86_64-gcc-...    43.4 MiB   861 KiB/s 00:52 [###############################] 100%
 Total (16/16)                    65.1 MiB  1285 KiB/s 00:52 [###############################] 100%
(16/16) checking keys in keyring                             [###############################] 100%
(16/16) checking package integrity                           [###############################] 100%
(16/16) loading package files                                [###############################] 100%
(16/16) checking for file conflicts                          [###############################] 100%
(16/16) checking available disk space                        [###############################] 100%
:: Processing package changes...
( 1/16) installing mingw-w64-ucrt-x86_64-libwinpthread-git   [###############################] 100%
( 2/16) installing mingw-w64-ucrt-x86_64-gcc-libs            [###############################] 100%
( 3/16) installing mingw-w64-ucrt-x86_64-libiconv            [###############################] 100%
( 4/16) installing mingw-w64-ucrt-x86_64-gettext-runtime     [###############################] 100%
( 5/16) installing mingw-w64-ucrt-x86_64-zlib                [###############################] 100%
( 6/16) installing mingw-w64-ucrt-x86_64-zstd                [###############################] 100%
( 7/16) installing mingw-w64-ucrt-x86_64-binutils            [###############################] 100%
( 8/16) installing mingw-w64-ucrt-x86_64-headers-git         [###############################] 100%
( 9/16) installing mingw-w64-ucrt-x86_64-crt-git             [###############################] 100%
(10/16) installing mingw-w64-ucrt-x86_64-gmp                 [###############################] 100%
(11/16) installing mingw-w64-ucrt-x86_64-isl                 [###############################] 100%
(12/16) installing mingw-w64-ucrt-x86_64-mpfr                [###############################] 100%
(13/16) installing mingw-w64-ucrt-x86_64-mpc                 [###############################] 100%
(14/16) installing mingw-w64-ucrt-x86_64-windows-default...  [###############################] 100%
(15/16) installing mingw-w64-ucrt-x86_64-winpthreads-git     [###############################] 100%
(16/16) installing mingw-w64-ucrt-x86_64-gcc                 [###############################] 100%

Itamar@DESKTOP-MP8Q5KH UCRT64 ~

Saudações,
Itamar M. Lins Jr.

[Itamar M. Lins Jr.]

Olá!
Vou mudar minhas variáveis de ambiente para pegar a nova pasta UCRT que é um GCC támbém só que usa o RUNTIME de MICROSOFT.
Veja que antes era na pasta mingw64\include por exemplo.

No path tenho que mudar para pegar na pasta ucrt64

Saudações,
Itamar M. Lins Jr.

[Itamar M. Lins Jr.]

Olá!
Já mudei o path para pegar a nova pasta ucrt64.

Código: Selecionar todos

C:\Users\Itamar>gcc -v
Using built-in specs.
COLLECT_GCC=gcc
COLLECT_LTO_WRAPPER=C:/msys64/ucrt64/bin/../lib/gcc/x86_64-w64-mingw32/14.1.0/lto-wrapper.exe
Target: x86_64-w64-mingw32
Configured with: ../gcc-14.1.0/configure --prefix=/ucrt64 --with-local-prefix=/ucrt64/local --build=x86_64-w64-mingw32 --host=x86_64-w64-mingw32 --target=x86_64-w64-mingw32 --with-native-system-header-dir=/ucrt64/include --libexecdir=/ucrt64/lib --enable-bootstrap --enable-checking=release --with-arch=nocona --with-tune=generic --enable-languages=c,lto,c++,fortran,ada,objc,obj-c++,rust,jit --enable-shared --enable-static --enable-libatomic --enable-threads=posix --enable-graphite --enable-fully-dynamic-string --enable-libstdcxx-filesystem-ts --enable-libstdcxx-time --disable-libstdcxx-pch --enable-lto --enable-libgomp --disable-libssp --disable-multilib --disable-rpath --disable-win32-registry --disable-nls --disable-werror --disable-symvers --with-libiconv --with-system-zlib --with-gmp=/ucrt64 --with-mpfr=/ucrt64 --with-mpc=/ucrt64 --with-isl=/ucrt64 --with-pkgversion='Rev2, Built by MSYS2 project' --with-bugurl=https://github.com/msys2/MINGW-packages/issues --with-gnu-as --with-gnu-ld --disable-libstdcxx-debug --enable-plugin --with-boot-ldflags=-static-libstdc++ --with-stage1-ldflags=-static-libstdc++
Thread model: posix
Supported LTO compression algorithms: zlib zstd
gcc version 14.1.0 (Rev2, Built by MSYS2 project)

C:\Users\Itamar>

Agora é recompilar o Harbour para ver se vai!!! Talvez o OPENSSL dê chabu!!! Vamos ver.
>win-make clean install
Meu HB_INSTALL_PREFIX é:
SET HB_INSTALL_PREFIX=c:\hb32
Só isso que eu seto, não toco em mais nada.

Saudações,
Itamar M. Lins Jr.