DBF Viewer
Moderator: Rathinagiri
- MigSoft
- Posts: 74
- Joined: Sat Aug 02, 2008 5:51 am
- DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL, FireBird
- Location: Santiago - Chile
- Contact:
DBF Viewer
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
"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 1319 times
Regards,
MigSoft.
MigSoft.
- dhaine_adp
- Posts: 457
- Joined: Wed Aug 06, 2008 12:22 pm
- Location: Manila, Philippines
Re: DBF Viewer
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
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
Danny
Manila, Philippines
- Alex Gustow
- Posts: 290
- Joined: Thu Dec 04, 2008 1:05 pm
- Location: Yekaterinburg, Russia
- Contact:
Re: DBF Viewer
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 !!!!!!
Danny, I agree with you - HAPPY NEW YEAR to all !!!!!!
Re: DBF Viewer
Gracias Miguel!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
Feliz año nuevo para todos!!!
Happy new year for all!!
Saludos, Fernando Chirico.
- MigSoft
- Posts: 74
- Joined: Sat Aug 02, 2008 5:51 am
- DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL, FireBird
- Location: Santiago - Chile
- Contact:
Re: DBF Viewer
Corrigenda,
File "dbview.prg "on export to Excel routine please change a few lines as follows.
Regards,
MigSoft
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
MigSoft
Regards,
MigSoft.
MigSoft.
Re: DBF Viewer
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
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
Sudip
- esgici
- Posts: 4543
- Joined: Wed Jul 30, 2008 9:17 pm
- DBs Used: DBF
- Location: iskenderun / Turkiye
- Contact:
Re: DBF Viewer
Hola Miguel
Congrats and thanks, good and big job
Yet another "contender" to DBA
Saludos
--
Esgici
Congrats and thanks, good and big job
Yet another "contender" to DBA
Saludos
--
Esgici
Viva INTERNATIONAL HMG
- MigSoft
- Posts: 74
- Joined: Sat Aug 02, 2008 5:51 am
- DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL, FireBird
- Location: Santiago - Chile
- Contact:
Re: DBF Viewer
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
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
Regards,
MigSoft.
MigSoft.
- Roberto Lopez
- HMG Founder
- Posts: 4004
- Joined: Wed Jul 30, 2008 6:43 pm
Re: DBF Viewer
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)
Roberto
(Veritas Filia Temporis)