Utilities like DBU, Make, IDE written in HMG/ used to create HMG based applications
Moderator: Rathinagiri
MigSoft
Posts: 84 Joined: Sat Aug 02, 2008 5:51 am
DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL, FireBird
Location: Santiago - Chile
Contact:
Post
by MigSoft » Wed Dec 30, 2009 2:57 am
Hello everyone,
"dbfview" is an application that is a mixture of code provided by our friends Rathinagiri, Grigory Filatov and an adaptation of sample "contactos" by Roberto Lopez.
I hope it serves as a starting point of a tool for viewing files DBF.
Regards,
Miguel Angel Juárez A.
Compile with IDE
Attachments
HMGdbview.zip
(898.06 KiB) Downloaded 1424 times
dhaine_adp
Posts: 457 Joined: Wed Aug 06, 2008 12:22 pm
Location: Manila, Philippines
Post
by dhaine_adp » Wed Dec 30, 2009 5:08 am
Hi MigSoft,
I downloaded the file, thanks for sharing. I'll test it and hopefully I can get back to you.
Happy New Year too...... and to everyone as well!!!!!!!!!!!!!!!!!!!
Thanks,
Danny
Regards,
Danny
Manila, Philippines
Alex Gustow
Posts: 290 Joined: Thu Dec 04, 2008 1:05 pm
Location: Yekaterinburg, Russia
Contact:
Post
by Alex Gustow » Wed Dec 30, 2009 8:28 am
Hi Miguel! I downloaded your app, runed - it looks and works fine & useful. Really good thing - thanks for sharing!
Danny, I agree with you - HAPPY NEW YEAR to all !!!!!!
fchirico
Posts: 324 Joined: Sat Aug 23, 2008 11:27 pm
Location: Argentina
Post
by fchirico » Wed Dec 30, 2009 11:22 am
MigSoft wrote: Hello everyone,
"dbfview" is an application that is a mixture of code provided by our friends Rathinagiri, Grigory Filatov and an adaptation of sample "contactos" by Roberto Lopez.
I hope it serves as a starting point of a tool for viewing files DBF.
Regards,
Miguel Angel Juárez A.
Compile with IDE
Gracias Miguel!
Feliz año nuevo para todos!!!
Happy new year for all!!
Saludos, Fernando Chirico.
MigSoft
Posts: 84 Joined: Sat Aug 02, 2008 5:51 am
DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL, FireBird
Location: Santiago - Chile
Contact:
Post
by MigSoft » Wed Dec 30, 2009 12:56 pm
Corrigenda,
File "dbview.prg "on export to Excel routine please change a few lines as follows.
Code: Select all
*--------------------------------------------------------*
Procedure SaveToXls( cAlias, cFile )
*--------------------------------------------------------*
Local oExcel, oSheet, oBook, aColumns, nCell := 1
If !Empty( cbase )
IF ( oExcel := win_oleGetActiveObject("Excel.Application" )) == NIL
IF ( oExcel := win_oleCreateObject("Excel.Application" ) ) == NIL
MsgStop( "ERROR! Excel is not available. ["+ Ole2TxtError()+ "]", PROGRAM )
Return
ENDIF
ENDIF
oExcel:Visible := .F.
oExcel:WorkBooks:Add()
oSheet := oExcel:ActiveSheet()
Aeval( (cAlias)->( DBstruct(cAlias) ), { |e,i| oSheet:Cells( nCell, i ):Value := e[DBS_NAME] } )
do while !(cAlias)->( EoF() )
nCell++
aColumns := (cAlias)->( Scatter() )
aEval( aColumns, { |e,i| oSheet:Cells( nCell, i ):Value := e } )
(cAlias)->( DBskip() )
enddo
oBook := oExcel:ActiveWorkBook()
oBook:Title := cAlias
oBook:Subject := cAlias
oBook:SaveAs(cFile)
oExcel:Quit()
Endif
Return
Regards,
MigSoft
sudip
Posts: 1456 Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India
Post
by sudip » Wed Dec 30, 2009 5:55 pm
Hello MigSoft,
Thanks a lot for sharing.
Regarding export to excel. You may try with copying and pasting (from clipboard). IMHO, it will be more efficient mainly for larger tables.
With best regards.
Sudip
With best regards,
Sudip
MigSoft
Posts: 84 Joined: Sat Aug 02, 2008 5:51 am
DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL, FireBird
Location: Santiago - Chile
Contact:
Post
by MigSoft » Wed Dec 30, 2009 6:15 pm
Hi Sudip,
Very interesting. How so
Regards,
MigSoft
esgici
Posts: 4543 Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:
Post
by esgici » Wed Dec 30, 2009 6:41 pm
Hola Miguel
Congrats and thanks, good and big job
Yet another "contender" to DBA
Saludos
--
Esgici
Viva
INTERNATIONAL HMG
MigSoft
Posts: 84 Joined: Sat Aug 02, 2008 5:51 am
DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL, FireBird
Location: Santiago - Chile
Contact:
Post
by MigSoft » Wed Dec 30, 2009 11:16 pm
Hello Esgici,
Thanks for your kind words.
DBA is a powerful tool (Congratulations), and has many functions that at this time "DBViewer" does not count.
In the future we can all keep adding new features.
Best regards,
MigSoft
Roberto Lopez
HMG Founder
Posts: 4012 Joined: Wed Jul 30, 2008 6:43 pm
Post
by Roberto Lopez » Wed Dec 30, 2009 11:45 pm
MigSoft wrote: Hello everyone,
"dbfview" is an application that is a mixture of code provided by our friends Rathinagiri, Grigory Filatov and an adaptation of sample "contactos" by Roberto Lopez.
I hope it serves as a starting point of a tool for viewing files DBF.
Regards,
Miguel Angel Juárez A.
Compile with IDE
Thanks!!!
Regards/Saludos,
Roberto
(Veritas Filia Temporis)