HMG 3.4.4

HMG Unicode versions 3.1.x related

Moderator: Rathinagiri

User avatar
jairpinho
Posts: 346
Joined: Mon Jul 18, 2011 5:36 pm
Location: Rio Grande do Sul - Brasil
Has thanked: 3 times
Been thanked: 11 times
Contact:

Re: HMG 3.4.4

Post by jairpinho » Sun Sep 01, 2019 10:54 pm

hello guys, I'm having trouble compiling the 64bit libraries follows the error says the .c file was not found but it is in the folder because I used incremental parameter with hbmk2
Attachments
erro build 64bits.png
erro build 64bits.png (28.61 KiB) Viewed 5911 times
Jair Pinho
HMG ALTA REVOLUÇÃO xBASE
HMG xBASE REVOLUTION HIGH
http://www.hmgforum.com.br

User avatar
Ismach
Posts: 114
Joined: Wed Nov 28, 2012 5:55 pm
DBs Used: DBF, mySQL, Mariadb, postgreSQL, Oracle, Db2, Interbase, Firebird, and SQLite
Location: Buenos Aires - Argentina
Been thanked: 8 times

Post by Ismach » Mon Oct 28, 2019 8:40 pm

Estimados de HMGForum:

He velto al ruedo y he instalado HMG344 y he intentado compilar el ejemplo demo que está en "c:\hmg\SAMPLES\HFCL\SQL\HMGSQLite\", pero
al hacerlo me manda estos errores:

Code: Select all

hbmk2: Error: Función(es) referenciada, no encontrada, pero desconocida:
       CONNECT2DB(), SQL(), C2SQL(), MISCSQL()
he compilado todas las lib y me sigue saliendo este error...

User avatar
susviela
Posts: 14
Joined: Wed Oct 17, 2018 4:44 am
DBs Used: DBF, PostgreSql, SQLite
Has thanked: 5 times
Contact:

Post by susviela » Mon Oct 28, 2019 11:09 pm

Tengo uns demos en mi Blog, talvez te sirva.

Harbour: SQLite – Classe I

https://programandoxbase.wordpress.com/ ... -classe-i/


#Susviela

User avatar
mustafa
Posts: 860
Joined: Fri Mar 20, 2009 11:38 am
DBs Used: DBF
Location: Alicante - Spain
Been thanked: 132 times
Contact:

Post by mustafa » Tue Oct 29, 2019 3:15 pm

Hola Ismach:
el el Prg Principal pon:

Code: Select all

#include <hmg.ch>
#include <Sql1.prg>   <------------- Incluir

FUNCTION MAIN  
...........
En tu proyecto incluye el Sql1.prg
que está en Zip que te mando
Haber si funciona ?
Saludos
Mustafa
Attachments
Sql1.zip
(1.27 KiB) Downloaded 80 times

User avatar
Ismach
Posts: 114
Joined: Wed Nov 28, 2012 5:55 pm
DBs Used: DBF, mySQL, Mariadb, postgreSQL, Oracle, Db2, Interbase, Firebird, and SQLite
Location: Buenos Aires - Argentina
Been thanked: 8 times

Post by Ismach » Tue Oct 29, 2019 5:03 pm

Gracias amigos por la respuesta... ahora no enlaza... creo que tengo que recompilar libhbsqlite3.a porque me tira estos errores:

Code: Select all

C:\hmg\SAMPLES\HFCL\SQL\HMGSQLite>build
Building demo.hbp
hbmk2[demo]: Advertencia: Ignorando biblioteca del núcleo especificada
             explícitamente: hbsix (in option 'libs=hbsix' in
             C:\hmg\hmg.hbc:25)
Harbour 3.2.0dev (r1509031202)
Copyright (c) 1999-2015, http://harbour-project.org/
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xb5): undefined reference to `sqlite3_close'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x193): undefined reference to `sqlite3_user_data'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x202): undefined reference to `sqlite3_value_type'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x27e): undefined reference to `sqlite3_result_error_code'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x297): undefined reference to `sqlite3_value_bytes'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2a8): undefined reference to `sqlite3_value_blob'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2c8): undefined reference to `sqlite3_value_text'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2f7): undefined reference to `sqlite3_value_double'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x318): undefined reference to `sqlite3_value_int64'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x354): undefined reference to `sqlite3_result_int64'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x364): undefined reference to `sqlite3_result_null'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x39e): undefined reference to `sqlite3_result_text'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3c3): undefined reference to `sqlite3_result_double'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x8d4): undefined reference to `sqlite3_libversion'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x8f4): undefined reference to `sqlite3_libversion_number'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x914): undefined reference to `sqlite3_sourceid'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x934): undefined reference to `sqlite3_initialize'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x954): undefined reference to `sqlite3_shutdown'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xa38): undefined reference to `sqlite3_extended_result_codes'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xb0a): undefined reference to `sqlite3_errcode'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xbda): undefined reference to `sqlite3_extended_errcode'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xcaa): undefined reference to `sqlite3_errmsg'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xce3): undefined reference to `sqlite3_errstr'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xd13): undefined reference to `sqlite3_sleep'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xdda): undefined reference to `sqlite3_last_insert_rowid'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xe6f): undefined reference to `sqlite3_open'

User avatar
mustafa
Posts: 860
Joined: Fri Mar 20, 2009 11:38 am
DBs Used: DBF
Location: Alicante - Spain
Been thanked: 132 times
Contact:

Post by mustafa » Tue Oct 29, 2019 5:46 pm

Mira este sample que publique

viewtopic.php?f=9&t=4795&hilit=base+sqlite&start=10

Sqlite_Photo_Selection_New.zip

Para entrar

Username : george
Charge : General Manager
Password : admin

jorge.posadas
Posts: 89
Joined: Mon May 19, 2014 7:43 pm
DBs Used: DBF, SQLite, MS-SQL, ACCESS, MariaDB (en proceso)
Location: Tizayuca, Hgo. México
Been thanked: 6 times
Contact:

Post by jorge.posadas » Tue Oct 29, 2019 6:19 pm

HMG

Gracias por los cambios, a pesar de ni usar todos los cambios, se que son mejoras importantes. Gracias por este trabajo
Cordialmente

Jorge Posadas Ch
Tizayuca, Hgo.
M é x i c o .
Movil +52 55 1427 2013
SKYPE: jorge.posadasch
Email: jorge.posadas@gmail.com

User avatar
Ismach
Posts: 114
Joined: Wed Nov 28, 2012 5:55 pm
DBs Used: DBF, mySQL, Mariadb, postgreSQL, Oracle, Db2, Interbase, Firebird, and SQLite
Location: Buenos Aires - Argentina
Been thanked: 8 times

Post by Ismach » Tue Oct 29, 2019 6:46 pm

Gracias Mustafa por tu generosidad, el problema que tengo es con
las .a, tengo instalado HMG 3.4.2 Unicode en Win10,
tengo algun conflicto con el 32 y 64bit. Sospecho que es eso
porque me hace mencion a la libreria

Code: Select all

C:\hmg\SAMPLES\HFCL\SQL\HMGSQLite>build
Building demo.hbp
hbmk2[demo]: Advertencia: Ignorando biblioteca del núcleo especificada
             explícitamente: hbsix (in option 'libs=hbsix' in
             C:\hmg\hmg.hbc:25)
Harbour 3.2.0dev (r1509031202)
Copyright (c) 1999-2015, http://harbour-project.org/
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xb5): undefined reference to `sqlite3_close'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x193): undefined reference to `sqlite3_user_data'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x202): undefined reference to `sqlite3_value_type'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x27e): undefined reference to `sqlite3_result_error_code'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x297): undefined reference to `sqlite3_value_bytes'
..
..
..
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x4250): undefined reference to `sqlite3_create_function'
C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2671): undefined reference to `sqlite3_reset_auto_extension'
C:/hmg/mingw/bin/../lib/gcc/i686-w64-mingw32/4.9.2/../../../../i686-w64-mingw32/bin/ld.exe: C:/hmg/harbour/lib/win/mingw/libhbsqlit3.a(core.o): bad reloc address 0xc in section `.rdata'
C:/hmg/mingw/bin/../lib/gcc/i686-w64-mingw32/4.9.2/../../../../i686-w64-mingw32/bin/ld.exe: final link failed: Invalid operation
collect2.exe: error: ld returned 1 exit status
hbmk2[Main]: Error: Ejecutando enlazador. 1
gcc.exe C:/Users/231201/AppData/Local/Temp/hbmk_fysojb.dir/Main_SQlite.o C:/Users/231201/AppData/Local/Temp/hbmk_fysojb.dir/Main_Control.o C:/Users/231201/AppData/Local/Temp/hbmk_fysojb.dir/New_Clavex.o C:/Users/231201/AppData/Local/Temp/hbmk_fysojb.dir/Mira_Reg.o C:/Users/231201/AppData/Local/Temp/hbmk_fysojb.dir/apoyo_1.o C:/Users/231201/AppData/Local/Temp/hbmk_fysojb.dir/apoyo_2.o C:/Users/231201/AppData/Local/Temp/hbmk_fysojb.dir/mPrint.o C:/Users/231201/AppData/Local/Temp/hbmk_fysojb.dir/miraprint.o C:/Users/231201/AppData/Local/Temp/hbmk_fysojb.dir/About.o C:/Users/231201/AppData/Local/Temp/hbmk_fysojb.dir/Camely.o C:/Users/231201/AppData/Local/Temp/hbmk_fysojb.dir/Sql1.o C:/Users/231201/AppData/Local/Temp/hbmk_fysojb.dir/Repor_1.o C:/Users/231201/AppData/Local/Temp/hbmk_fysojb.dir/Repor_2.o C:/Users/231201/AppData/Local/Temp/hbmk_fysojb.dir/Repor_3.o C:/Users/231201/AppData/Local/Temp/hbmk_fysojb.dir/Repor_4.o C:/Users/231201/AppData/Local/Temp/hbmk_fysojb.dir/Hours.o C:/Users/231201/AppData/Local/Temp/hbmk_fysojb.dir/hbmk_yk0ixn.o C:/hmg/SAMPLES/HFCL/Sqlite_Photo_Selection_New/_temp.o    -mwindows -Wl,--start-group -lhmg -lcrypt -ledit -leditex -lgraph -lini -lreport -lhfcl -lmsvfw32 -lvfw32 -lhbct -lhbwin -lhbmzip -lminizip -lhbmemio -lhbmisc -lhbmysql -lmysql -lhbtip -lhbsqlit3 -lsddodbc -lrddsql -lsddmy -lhbodbc -lodbc32 -lhbhpdf -lhbfimage -lhbnetio -lxhb -lpng -llibhpdf -lhbvpdf -lhbzebra -lhbziparc -lhbextern -lhbdebug -lhbvmmt -lhbrtl -lhblang -lhbcpage -lgtcgi -lgtpca -lgtstd -lgtwin -lgtwvt -lgtgui -lhbrdd -lhbuddall -lhbusrrdd -lrddntx -lrddcdx -lrddnsx -lrddfpt -lhbrdd -lhbhsx -lhbsix -lhbmacro -lhbcplr -lhbpp -lhbcommon -lhbmainwin -lkernel32 -luser32 -lgdi32 -ladvapi32 -lws2_32 -liphlpapi -lwinspool -lcomctl32 -lcomdlg32 -lshell32 -luuid -lole32 -loleaut32 -lmpr -lwinmm -lmapi32 -limm32 -lmsimg32 -lwininet -lhbpcre -lhbzlib   -Wl,--end-group -oMain.exe  -LC:/hmg/harbour/lib/win/mingw -LC:/hmg/lib

C:\hmg\SAMPLES\HFCL\Sqlite_Photo_Selection_New>
ahi he intentado compilar tu ejemplo y me da los mismos errores

User avatar
Ismach
Posts: 114
Joined: Wed Nov 28, 2012 5:55 pm
DBs Used: DBF, mySQL, Mariadb, postgreSQL, Oracle, Db2, Interbase, Firebird, and SQLite
Location: Buenos Aires - Argentina
Been thanked: 8 times

Post by Ismach » Tue Oct 29, 2019 6:47 pm

En todos los ejemplos me sucede lo mismo

User avatar
Ismach
Posts: 114
Joined: Wed Nov 28, 2012 5:55 pm
DBs Used: DBF, mySQL, Mariadb, postgreSQL, Oracle, Db2, Interbase, Firebird, and SQLite
Location: Buenos Aires - Argentina
Been thanked: 8 times

Post by Ismach » Tue Oct 29, 2019 7:28 pm

Listo se resuelve asi:
En el "hmg.hbc"
existe una linea comentada
# libs=sqlite3
hay que sacar el # y good show!!!

Gracias a todos

Post Reply