build error : c:\hmg.3.4.4\SAMPLES\HFCL\SQL\HMGSQLite

Moderator: Rathinagiri

Post Reply
User avatar
hmgchang
Posts: 273
Joined: Tue Aug 13, 2013 4:46 am
Location: Indonesia

build error : c:\hmg.3.4.4\SAMPLES\HFCL\SQL\HMGSQLite

Post by hmgchang »

Dear Friends,

built and error on build error : c:\hmg.3.4.4\SAMPLES\HFCL\SQL\HMGSQLite

the build.log :

Code: Select all

hbmk2: Triggered by #require directive: hmgsqlite.hbc
hbmk2[demo]: Warning: Cannot find hmgsqlite.hbc
hbmk2: Linking... demo.exe
.hbmk/win/mingw/demo.o:demo.c:(.data+0xa8): undefined reference to `HB_FUN_CONNECT2DB'
.hbmk/win/mingw/demo.o:demo.c:(.data+0x168): undefined reference to `HB_FUN_SQL'
.hbmk/win/mingw/demo.o:demo.c:(.data+0x178): undefined reference to `HB_FUN_C2SQL'
.hbmk/win/mingw/demo.o:demo.c:(.data+0x218): undefined reference to `HB_FUN_MISCSQL'
collect2.exe: error: ld returned 1 exit status
hbmk2[demo]: Error: Running linker. 1
gcc.exe .hbmk/win/mingw/demo.o .hbmk/win/mingw/_hbmkaut_demo.o c:/hmg.3.4.4/SAMPLES/HFCL/SQL/HMGSQLite/_temp.o    -pthread  -static-libgcc  -static-libstdc++  -static -lpthread -mwindows -Wl,--start-group -lhmg -lcrypt -ledit -leditex -lgraph -lini -lreport -lhfcl -lmsvfw32 -lvfw32 -lhbmysql -lmysql -lhbfimage -lhbpgsql -lsddmy -lhbvpdf -lhbct -lhbwin -lhbmzip -lminizip -lhbmemio -lhbmisc -lhbtip -lsqlite3 -lhbsqlit3 -lsddodbc -lrddsql -lhbodbc -lodbc32 -lhbhpdf -lhbnetio -lxhb -lpng -llibhpdf -lhbzebra -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 -odemo.exe  -LC:/hmg.3.4.4/harbour/lib/win/mingw -LC:/hmg.3.4.4/lib

hbmk2: Error: Referenced, missing, but unknown function(s): CONNECT2DB(),
       SQL(), C2SQL(), MISCSQL()
TIA

best rgds,
Chang
Just Hmg It !
jayadevu
Posts: 238
Joined: Tue May 19, 2009 7:10 am

Re: build error : c:\hmg.3.4.4\SAMPLES\HFCL\SQL\HMGSQLite

Post by jayadevu »

Hi Chang,

These functions are in hmgsqlite.prg found in c:\hmg.3.4.4\SOURCE\HMGSQL

Warm regards,

Jayadev
User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: build error : c:\hmg.3.4.4\SAMPLES\HFCL\SQL\HMGSQLite

Post by dragancesu »

You need hmgsql library

Look at c:\hmg.3.4.4\SOURCE\HMGSQL and create library what you need
User avatar
hmgchang
Posts: 273
Joined: Tue Aug 13, 2013 4:46 am
Location: Indonesia

Re: build error : c:\hmg.3.4.4\SAMPLES\HFCL\SQL\HMGSQLite

Post by hmgchang »

Thanks Dragancesu,
Maybe this is not an original sample from HMG,
if I am not mistake its from the HMGforum...
Anyway every code is a good teacher for me...

best rgds,
Chang
Just Hmg It !
User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: build error : c:\hmg.3.4.4\SAMPLES\HFCL\SQL\HMGSQLite

Post by dragancesu »

Sample is OK, but you must do

1. on folder c:\hmg.3.4.4\SOURCE\HMGSQL run buildlib.bat
then you can see new library in c:\hmg.3.4.4\lib

2. then c:\hmg.3.4.4\hmg32.hbc add line libs=hmgsqlite

3. then compile demo c:\hmg.3.4.4\SAMPLES\HFCL\SQL\HMGSQLite
it's work

p.s. this library is not default, this is Rathi's work, search forum for it
User avatar
mustafa
Posts: 1158
Joined: Fri Mar 20, 2009 11:38 am
DBs Used: DBF
Location: Alicante - Spain
Contact:

Re: build error : c:\hmg.3.4.4\SAMPLES\HFCL\SQL\HMGSQLite

Post by mustafa »

Hi friend Chang
Look at this Sqlite sample I published
viewtopic.php?f=9&t=4795&p=45549&hilit= ... ite#p45549
Sample New ---> Sqlite_Sample_New.zip
Regards
Mustafa
User avatar
SALINETAS24
Posts: 667
Joined: Tue Feb 27, 2018 3:06 am
DBs Used: DBF
Contact:

Re: build error : c:\hmg.3.4.4\SAMPLES\HFCL\SQL\HMGSQLite

Post by SALINETAS24 »

Muy buena la aplicación Musfata y la he compilado y a la primera. Por el contrario el SAMPLES\HFCL\SQL\HMGSQLITE no he podido todavia.
Agradecido y lo dicho.. me pongo a ver eso del SQL.. vamos con una cervecita..!!
Como dijo el gran pensador Hommer Simpson..., - En este mundo solo hay 3 tipos de personas, los que saben contar y los que no. :shock:
User avatar
jairpinho
Posts: 420
Joined: Mon Jul 18, 2011 5:36 pm
Location: Rio Grande do Sul - Brasil
Contact:

Re: build error : c:\hmg.3.4.4\SAMPLES\HFCL\SQL\HMGSQLite

Post by jairpinho »

use C:\hmg.3.4.4\SAMPLES\HFCL\SQL\SQLITE works perfect
Jair Pinho
HMG ALTA REVOLUÇÃO xBASE
HMG xBASE REVOLUTION HIGH
http://www.hmgforum.com.br
User avatar
jairpinho
Posts: 420
Joined: Mon Jul 18, 2011 5:36 pm
Location: Rio Grande do Sul - Brasil
Contact:

Re: build error : c:\hmg.3.4.4\SAMPLES\HFCL\SQL\HMGSQLite

Post by jairpinho »

hmgchang wrote: Tue Jun 05, 2018 9:10 pm Dear Friends,

built and error on build error : c:\hmg.3.4.4\SAMPLES\HFCL\SQL\HMGSQLite

the build.log :

Code: Select all

hbmk2: Triggered by #require directive: hmgsqlite.hbc
hbmk2[demo]: Warning: Cannot find hmgsqlite.hbc
hbmk2: Linking... demo.exe
.hbmk/win/mingw/demo.o:demo.c:(.data+0xa8): undefined reference to `HB_FUN_CONNECT2DB'
.hbmk/win/mingw/demo.o:demo.c:(.data+0x168): undefined reference to `HB_FUN_SQL'
.hbmk/win/mingw/demo.o:demo.c:(.data+0x178): undefined reference to `HB_FUN_C2SQL'
.hbmk/win/mingw/demo.o:demo.c:(.data+0x218): undefined reference to `HB_FUN_MISCSQL'
collect2.exe: error: ld returned 1 exit status
hbmk2[demo]: Error: Running linker. 1
gcc.exe .hbmk/win/mingw/demo.o .hbmk/win/mingw/_hbmkaut_demo.o c:/hmg.3.4.4/SAMPLES/HFCL/SQL/HMGSQLite/_temp.o    -pthread  -static-libgcc  -static-libstdc++  -static -lpthread -mwindows -Wl,--start-group -lhmg -lcrypt -ledit -leditex -lgraph -lini -lreport -lhfcl -lmsvfw32 -lvfw32 -lhbmysql -lmysql -lhbfimage -lhbpgsql -lsddmy -lhbvpdf -lhbct -lhbwin -lhbmzip -lminizip -lhbmemio -lhbmisc -lhbtip -lsqlite3 -lhbsqlit3 -lsddodbc -lrddsql -lhbodbc -lodbc32 -lhbhpdf -lhbnetio -lxhb -lpng -llibhpdf -lhbzebra -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 -odemo.exe  -LC:/hmg.3.4.4/harbour/lib/win/mingw -LC:/hmg.3.4.4/lib

hbmk2: Error: Referenced, missing, but unknown function(s): CONNECT2DB(),
       SQL(), C2SQL(), MISCSQL()
TIA

best rgds,
Chang
follows a new review as an example in IDE
HMGSQLite_Rev2.zip
(1.95 MiB) Downloaded 217 times
Jair Pinho
HMG ALTA REVOLUÇÃO xBASE
HMG xBASE REVOLUTION HIGH
http://www.hmgforum.com.br
Post Reply