FuelWare
Moderator: Rathinagiri
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
FuelWare
I have named this project as 'FuelWare' which can be used to track expenses related to vehicles in an organization like fuel, insurance, permit and other. I am making the documentation and once it is over, I will share that with you. I am sure the screens are self explanatory.
The project is based on SQLite database. It comes with a sample database. If you want to enter in a fresh database, please rename/delete the file named 'fuelwaredb.sqlite'. A new file in this name will be created.
Source Code: You should include the following library file before compiling using IDE in the /lib folder.
Compiled Executable Help Now it is time for some screenshots:
Main Screen Transaction Entry Screen Vehicle Management Screen Tag Management Screen Report Screen
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
- serge_girard
- Posts: 3178
- Joined: Sun Nov 25, 2012 2:44 pm
- DBs Used: 1 MySQL - MariaDB
2 DBF - Location: Belgium
- Contact:
Re: FuelWare
Great job!
Thanks for sharing!
I will return to sqlite testing after adventures with HMGScript.
I'm sure this sample will help me a tot!
Thanks for sharing!
I will return to sqlite testing after adventures with HMGScript.
I'm sure this sample will help me a tot!
- mustafa
- Posts: 1162
- Joined: Fri Mar 20, 2009 11:38 am
- DBs Used: DBF
- Location: Alicante - Spain
- Contact:
Re: FuelWare
Hola amigo Rathi:
Magnífico , muchas gracias por su aportación
Creo que este proyecto suyo tendria que
incluirse en los samples SQlite de HMG para
la proxíma versión.
Quiero comentarle que el sample me daba
error de compilación , le adjunto Error
----- Solución -------------
he añadido al fichero FuelWare.hbp
Sql1.prg.
En fichero "solution.zip" adjunto
sql1.prg
error.log
build.3.4.2.bat
build.3.4.2_64.bat
Todo Ok con los cambios
saludos
Mustafa
*------------------ Google-----------------------*
Hello friend Rathi
Great, thank you very much for your input
I think this project would have to yours
SQlite included in the HMG samples for
The next version.
I want to tell the sample gave me
I attach compilation Error
------ Solution -----
I added to the file FuelWare.hbp
Sql1.prg.
In file "solution.zip" attached
sql1.prg
error.log
build.3.4.2.bat
build.3.4.2_64.bat
Everything Ok with changes
regards
Mustafa
*--------------------------------------------------- Error Compilation ------------------------------------------------*
Magnífico , muchas gracias por su aportación
Creo que este proyecto suyo tendria que
incluirse en los samples SQlite de HMG para
la proxíma versión.
Quiero comentarle que el sample me daba
error de compilación , le adjunto Error
----- Solución -------------
he añadido al fichero FuelWare.hbp
Sql1.prg.
En fichero "solution.zip" adjunto
sql1.prg
error.log
build.3.4.2.bat
build.3.4.2_64.bat
Todo Ok con los cambios
saludos
Mustafa
*------------------ Google-----------------------*
Hello friend Rathi
Great, thank you very much for your input
I think this project would have to yours
SQlite included in the HMG samples for
The next version.
I want to tell the sample gave me
I attach compilation Error
------ Solution -----
I added to the file FuelWare.hbp
Sql1.prg.
In file "solution.zip" attached
sql1.prg
error.log
build.3.4.2.bat
build.3.4.2_64.bat
Everything Ok with changes
regards
Mustafa
*--------------------------------------------------- Error Compilation ------------------------------------------------*
Harbour 3.2.0dev (r1509031202)
Copyright (c) 1999-2015, http://harbour-project.org/
hmgleavedate.prg:26:0: warning: ignoring #pragma EMDDUMP [-Wunknown-pragmas]
C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/main.o:main.c:(.data+0x128): undefined reference to `HB_FUN_CONNECT2DB'
C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/main.o:main.c:(.data+0x168): undefined reference to `HB_FUN_SQL'
c:/hmg.3.4.2/mingw/bin/../lib/gcc/i686-w64-mingw32/4.9.2/../../../../i686-w64-mingw32/bin/ld.exe: C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/main.o: bad reloc address 0xf in section `.text.startup'
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[FuelWare]: Error: Ejecutando enlazador. 1
gcc.exe C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/main.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/createdb.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/fueltxn.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/grid2csv.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/grid2html.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/hmganywhere.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/hmgleavedate.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/report.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/tagmanager.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/vehmast.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/hbmk_qrh9kf.o c:/Hmg.0_Musta_Total_11_03_2016/Sample_Adordd/FuelWare/_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 -lsqlite3 -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 -oFuelWare.exe -Lc:/hmg.3.4.2/harbour/lib/win/mingw -Lc:/hmg.3.4.2/lib
hbmk2: Error: Funci¢n(es) referenciada, no encontrada, pero desconocida:
CONNECT2DB(), SQL()
- Attachments
-
- solution.zip
- (3.05 KiB) Downloaded 294 times
- dragancesu
- Posts: 926
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Re: FuelWare
Great looks
I have not tried it but I did like that so I think we should add this information, state flown kilometer when full, if you need to take into account the average consumption
I have not tried it but I did like that so I think we should add this information, state flown kilometer when full, if you need to take into account the average consumption
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: FuelWare
In this software I am giving provision to find out the mileage in a different way. Whenever possible, we can just enter the odometer reading (there is a separate field for entering the odometer reading in the transaction entry between amount and remarks). This will help in a later stage to find out the average mileage of a vehicle.dragancesu wrote:Great looks
I have not tried it but I did like that so I think we should add this information, state flown kilometer when full, if you need to take into account the average consumption
This can be tracked for any particular expense also (like battery or tyre replacement).
Please comment about my idea also.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: FuelWare
Dear Mustafa,
You have to include HMGSQLite bridge (as you can see in .hbc file) library in the compilation.
Thanks for your solution also.
You have to include HMGSQLite bridge (as you can see in .hbc file) library in the compilation.
Thanks for your solution also.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
Re: FuelWare
Thank you Mr. Rathi for sharing excellent code in HMG
Also it is used to learn Sqlite
Also it is used to learn Sqlite
BPD
Convert Dream into Reality through HMG
Convert Dream into Reality through HMG
- luisvasquezcl
- Posts: 1258
- Joined: Thu Jul 31, 2008 3:23 am
- Location: Chile
- Contact:
Re: FuelWare
Very nice Rathi. thanks for sharing.
Best regards
Best regards
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: FuelWare
I have now attached the HMGSQLite Library file that is required while compiling the software. Please make use of it by copying the library file in hmg lib folder.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.