A better Listbox/Combobox

[tonton2]

bonjour,
j'ai supprimé dans l'ancienne version de Invoice_combo "COMBOBOX,aRefProduit" et je l'ai remplacé par "TEXTBOX" et "COMBOSEARCHBOX" ce qui nous permet de rechercher le produit par incrémentation .

hello,
I deleted the old version of Invoice_combo "COMBOBOX, aRefProduit" and I read "TEXTBOX" and "COMBOSEARCHBOX" which allows us to search for the product by incremention

[Javier Tovar]

Hola Tonton2,

Muy buen ejemplo, gracias por compartir.

Saludos

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

Hello Tonton2,

Very good example, thanks for sharing.

regards

[serge_girard]

Merci TonTon de vouloir partager ce exemple !

Serge

[esgici]

Thanks Youcef

Viva HMG

[tonton2]

Bonsoir à toute l'équipe HMG
quelques changements dans le fichier précédent :
Changement de " On key inser" par button "AJOUT PRODUIT";
le choix du produit peut être choisi directement dans "COMBOBOX" ;
le bouton " AJOUT PRODUIT" met directement la référence ,la désignation et le prix de référence dans la grille de facturation .

some changes in the previous file:
Change "ON KEY INSER" by button "AJOUT PRODUIT"
product can be selected directly in "COMBOBOX"
the "AJOUT PRODUIT" button makes directly reference, description and the reference price in the grid billing

[danielmaximiliano]

Tonton :

Gracias por compartir

Thanks for sharing

[tonton2]

INVOICE_COMBO.rar

(24.96 KiB) Downloaded 333 times

Bonjour,
en essayant de recompilé le fichier bl_combo.HBP dans INVOICE_COMBO.rar avec HMG3.4.2 ,celui ci ne fonctionne pas , mais fonctionne très bien avec HMG3.3.1.
ci joint le fichier erreur.
Hello,
I wanted recompiled the bl combo.HBP file in INVOICE COMBO.rar with HMG3.4.2 or HMG 3.4.1, this one does not work, but it works well with HMG3.3.1.

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[bl_Combo]: Error: Running linker. 1
gcc.exe C:/Users/youcef/AppData/Local/Temp/hbmk_1875ai.dir/bl_client.o C:/Users/youcef/AppData/Local/Temp/hbmk_1875ai.dir/bl_enreg.o C:/Users/youcef/AppData/Local/Temp/hbmk_1875ai.dir/combosearchgrid.o C:/Users/youcef/AppData/Local/Temp/hbmk_1875ai.dir/hbmk_8365wd.o C:/hmg.3.4.2/examples/INVOICE_COMBO/_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 -obl_Combo.exe  -LC:/hmg.3.4.2/harbour/lib/win/mingw -LC:/hmg.3.4.2/lib)

[/quote]

[Rathinagiri]

It seems that you have not linked the sqlite library in the compiling process.

Please include 'libs=sqlite3' in the hbc file.

[tonton2]

It seems that you have not linked the sqlite library in the compiling process.

Please include 'libs=sqlite3' in the hbc file.

Merci beaucoup , je ne l'avais remarqué
Thank you so much I had not notice it