Re: Menu_Pizza_SQlite
Posted: Thu Mar 10, 2016 8:17 am
OK, thanks,
Serge
Serge
Exclusive forum for HMG, a Free / Open Source xBase WIN32/64 Bits / GUI Development System
https://mail.hmgforum.com/
Nice idea Mustafa. Even though I had shared some projects fully based on SQLite (like waresoft), as you have said, no samples with simple database operations are available. We shall do necessary things.I really wish the forum for a section located
only dedicated to these databases where they provide
samples and programming tips for us
We started in this other way of programming.
Code: Select all
Harbour 3.2.0dev (r1509031202)
Copyright (c) 1999-2015, http://harbour-project.org/
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xb5): undefined reference to `sqlite3_close'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x193): undefined reference to `sqlite3_user_data'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x202): undefined reference to `sqlite3_value_type'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x27e): undefined reference to `sqlite3_result_error_code'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x297): undefined reference to `sqlite3_value_bytes'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2a8): undefined reference to `sqlite3_value_blob'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2c8): undefined reference to `sqlite3_value_text'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2f7): undefined reference to `sqlite3_value_double'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x318): undefined reference to `sqlite3_value_int64'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x354): undefined reference to `sqlite3_result_int64'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x364): undefined reference to `sqlite3_result_null'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x39e): undefined reference to `sqlite3_result_text'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3c3): undefined reference to `sqlite3_result_double'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x8d4): undefined reference to `sqlite3_libversion'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x8f4): undefined reference to `sqlite3_libversion_number'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x914): undefined reference to `sqlite3_sourceid'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x934): undefined reference to `sqlite3_initialize'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x954): undefined reference to `sqlite3_shutdown'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xa38): undefined reference to `sqlite3_extended_result_codes'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xb0a): undefined reference to `sqlite3_errcode'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xbda): undefined reference to `sqlite3_extended_errcode'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xcaa): undefined reference to `sqlite3_errmsg'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xce3): undefined reference to `sqlite3_errstr'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xd13): undefined reference to `sqlite3_sleep'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xdda): undefined reference to `sqlite3_last_insert_rowid'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xe6f): undefined reference to `sqlite3_open'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0xf58): undefined reference to `sqlite3_close'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1025): undefined reference to `sqlite3_open_v2'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x10f9): undefined reference to `sqlite3_close'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x12f5): undefined reference to `sqlite3_exec'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1307): undefined reference to `sqlite3_free'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1450): undefined reference to `sqlite3_prepare_v2'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1460): undefined reference to `sqlite3_finalize'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x14ca): undefined reference to `sqlite3_complete'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1537): undefined reference to `sqlite3_sql'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x15c3): undefined reference to `sqlite3_stmt_status'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1637): undefined reference to `sqlite3_stmt_readonly'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1697): undefined reference to `sqlite3_step'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x16f7): undefined reference to `sqlite3_clear_bindings'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1757): undefined reference to `sqlite3_reset'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x17b7): undefined reference to `sqlite3_finalize'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1863): undefined reference to `sqlite3_bind_blob'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1902): undefined reference to `sqlite3_bind_double'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1993): undefined reference to `sqlite3_bind_int'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1a3d): undefined reference to `sqlite3_bind_int64'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1aca): undefined reference to `sqlite3_bind_null'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1b78): undefined reference to `sqlite3_bind_text'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1c23): undefined reference to `sqlite3_bind_zeroblob'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1c97): undefined reference to `sqlite3_bind_parameter_count'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1d18): undefined reference to `sqlite3_bind_parameter_index'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1d9a): undefined reference to `sqlite3_bind_parameter_name'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1e8a): undefined reference to `sqlite3_changes'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1f5a): undefined reference to `sqlite3_total_changes'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x1f97): undefined reference to `sqlite3_column_count'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x200b): undefined reference to `sqlite3_column_type'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x207b): undefined reference to `sqlite3_column_decltype'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x20eb): undefined reference to `sqlite3_column_name'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x215b): undefined reference to `sqlite3_column_bytes'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x21d8): undefined reference to `sqlite3_column_bytes'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x21e6): undefined reference to `sqlite3_column_blob'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x227b): undefined reference to `sqlite3_column_double'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x22eb): undefined reference to `sqlite3_column_int'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x235b): undefined reference to `sqlite3_column_int64'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x23d8): undefined reference to `sqlite3_column_bytes'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x23e6): undefined reference to `sqlite3_column_text'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2538): undefined reference to `sqlite3_load_extension'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2561): undefined reference to `sqlite3_free'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2648): undefined reference to `sqlite3_enable_load_extension'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2748): undefined reference to `sqlite3_busy_timeout'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2878): undefined reference to `sqlite3_get_table'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2920): undefined reference to `sqlite3_free_table'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x294c): undefined reference to `sqlite3_free'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2b0c): undefined reference to `sqlite3_blob_open'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2b9e): undefined reference to `sqlite3_blob_reopen'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2bf7): undefined reference to `sqlite3_blob_close'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2c57): undefined reference to `sqlite3_blob_bytes'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2d00): undefined reference to `sqlite3_blob_read'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2d44): undefined reference to `sqlite3_blob_bytes'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2dfc): undefined reference to `sqlite3_blob_write'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2f0a): undefined reference to `sqlite3_get_autocommit'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2f43): undefined reference to `sqlite3_enable_shared_cache'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3060): undefined reference to `sqlite3_profile'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3180): undefined reference to `sqlite3_trace'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3376): undefined reference to `sqlite3_interrupt'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x347f): undefined reference to `sqlite3_busy_handler'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x34a2): undefined reference to `sqlite3_busy_handler'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x35d8): undefined reference to `sqlite3_progress_handler'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x35fa): undefined reference to `sqlite3_progress_handler'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x36ff): undefined reference to `sqlite3_commit_hook'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3722): undefined reference to `sqlite3_commit_hook'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x382f): undefined reference to `sqlite3_rollback_hook'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3852): undefined reference to `sqlite3_rollback_hook'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x395f): undefined reference to `sqlite3_set_authorizer'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3ae8): undefined reference to `sqlite3_backup_init'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3b8a): undefined reference to `sqlite3_backup_step'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3bd7): undefined reference to `sqlite3_backup_finish'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3c17): undefined reference to `sqlite3_backup_remaining'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3c57): undefined reference to `sqlite3_backup_pagecount'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3c84): undefined reference to `sqlite3_memory_used'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3cb3): undefined reference to `sqlite3_memory_highwater'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3cd4): undefined reference to `sqlite3_threadsafe'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3da1): undefined reference to `sqlite3_status'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x3f0c): undefined reference to `sqlite3_db_status'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x4056): undefined reference to `sqlite3_limit'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x4093): undefined reference to `sqlite3_compileoption_used'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x40c3): undefined reference to `sqlite3_compileoption_get'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x4250): undefined reference to `sqlite3_create_function'
c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o):core.c:(.text+0x2671): undefined reference to `sqlite3_reset_auto_extension'
c:/hmg.3.4.2/mingw/bin/../lib/gcc/i686-w64-mingw32/4.9.2/../../../../i686-w64-mingw32/bin/ld.exe: c:/hmg.3.4.2/harbour/lib/win/mingw/libhbsqlit3.a(core.o): bad reloc address 0xc in section `.rdata'
c:/hmg.3.4.2/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: Error: Ejecutando enlazador. 1
gcc.exe C:/Users/Robert/AppData/Local/Temp/hbmk_dtrfi3.dir/Menu_Sqlite.o C:/Users/Robert/AppData/Local/Temp/hbmk_dtrfi3.dir/hbmk_pnopex.o C:/tmp2/Menu_Pizza_SQlite/_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 -lhbpgsql -lhbnetio -lxhb -lpng -llibhpdf -lhbvpdf -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 -oMenu_Sqlite.exe -Lc:/hmg.3.4.2/harbour/lib/win/mingw -Lc:/hmg.3.4.2/lib