A new database tool, OTIS, Open Table InSpector
Moderator: Rathinagiri
Re: A new database tool, OTIS, Open Table InSpector
Hi,
another modif today, see below changelog.
25-06-2020 : OTIS V1.00 b04
Modif : Some users rename there ".DBF" to another extension ex. ".DAT"
Otis no longer verifies if the extension is ".DBF".
Any file can be loaded know.
I use error trapping everywhere with "Try and Catch" so if
a non dbf file is loaded a error message will be displayed.
Modif : Also added (*.* All files) when you want to load a index file.
By default Otis proposes the extension of the default RDD driver in use.
Attention, you can not load by example a .ntx file if you set DBFCDX
as default driver. A error message will be displayed in that case.
UPDATE 29/06/2020 :
latest version is attached
Regards,
Hans
another modif today, see below changelog.
25-06-2020 : OTIS V1.00 b04
Modif : Some users rename there ".DBF" to another extension ex. ".DAT"
Otis no longer verifies if the extension is ".DBF".
Any file can be loaded know.
I use error trapping everywhere with "Try and Catch" so if
a non dbf file is loaded a error message will be displayed.
Modif : Also added (*.* All files) when you want to load a index file.
By default Otis proposes the extension of the default RDD driver in use.
Attention, you can not load by example a .ntx file if you set DBFCDX
as default driver. A error message will be displayed in that case.
UPDATE 29/06/2020 :
latest version is attached
Regards,
Hans
- Attachments
-
- Otis - V1b06 - 20200629.7z
- (857.53 KiB) Downloaded 250 times
Last edited by hansmarc on Mon Jun 29, 2020 11:26 am, edited 4 times in total.
Re: A new database tool, OTIS, Open Table InSpector
Yes, I made it in Harbour for my Win10 64 bit. Attached here.
Regards,
Anand
- Attachments
-
- dbu9.zip
- (738.63 KiB) Downloaded 568 times
Re: A new database tool, OTIS, Open Table InSpector
Hi Anand
Many thanks for your generosity.
When I open DBU I get small boxes in place of where lines should be.
Though it does not affect DBU's functionality was wondering if there was a way to avoid them.
Rajeev
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: A new database tool, OTIS, Open Table InSpector
Nice work. A request. Please modify the updated version in the first post. This will help the persons who read from the first post will get the latest version.
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: A new database tool, OTIS, Open Table InSpector
Hi Rathinagiri,
Thanks for your compliment. It is a pleasure that i can do something back for this community.
Done, all previous posts contains the latest version know.
This post also.
Attached file is the latest version V1.0b05
Changelog :
26-06-2020 : OTIS V1.00 b05
----------------------------
New : Menu 'Table Properties" added a button to copy the structure to the clipboard.
Modif : Menu 'Structure Editor', added (*.* All files) when you want to load
the structure of a existing dbf table. For the same reason as below.
Some users change the extension '.dbf' to by example '.dat'.
Bug : Otis exits with a error when we tried to load a dataset selected in the
most used combobox list that DID NOT EXIST ANYMORE.
UPDATE 29/06/2020 :
latest version is attached
Regards
Hans
Thanks for your compliment. It is a pleasure that i can do something back for this community.
Done, all previous posts contains the latest version know.
This post also.
Attached file is the latest version V1.0b05
Changelog :
26-06-2020 : OTIS V1.00 b05
----------------------------
New : Menu 'Table Properties" added a button to copy the structure to the clipboard.
Modif : Menu 'Structure Editor', added (*.* All files) when you want to load
the structure of a existing dbf table. For the same reason as below.
Some users change the extension '.dbf' to by example '.dat'.
Bug : Otis exits with a error when we tried to load a dataset selected in the
most used combobox list that DID NOT EXIST ANYMORE.
UPDATE 29/06/2020 :
latest version is attached
Regards
Hans
- Attachments
-
- Otis - V1b06 - 20200629.7z
- (857.53 KiB) Downloaded 178 times
Last edited by hansmarc on Mon Jun 29, 2020 11:25 am, edited 1 time in total.
Re: A new database tool, OTIS, Open Table InSpector
Hi Anand
Yes, I made it in Harbour for my Win10 64 bit. Attached here.
Regards,
Anand
Are you willing to share your modified source of dbu.exe?
Best regards,
Gabor
Gabor
Re: A new database tool, OTIS, Open Table InSpector
Sure.
I have created new post for it, so that Hans post is not affected.
https://www.hmgforum.com/viewtopic.php?p=62472#p62472
Regards,
Anand
Re: A new database tool, OTIS, Open Table InSpector
Hi Rajeev,
Check the font in cmd properties.
Regards,
Anand
Re: A new database tool, OTIS, Open Table InSpector
Hi everybody,
I received some suggestions so find attached a new version of OTIS V1.00 b06 date 2020/06/29.
Enjoy,
Hans
-------------------------------------------------------------------------------
Changes since version OTIS V1.00 b05 :
You can find detailed info of all modifications in Changelog.txt
New :
- Added option 'AUTOOPEN' orderbag files.
- Added option 'ORDER SCOPE'.
- Added checkbox 'FILELOCK' to place a file width lock until you uncheck it.
- Added menus to 'MOVE UP' or 'MOVE DOWN' a record.
- Added a 'CLEAR' button in the structure editor.
- 'Index manager' a orderbag name is automatically proposed when creating a new order tag.
Modif :
-'COPY/PASTE' functions copies and paste only visible columns.
- Some menus have a new position so that they are regrouped in function of record or file width operations.
Bug : - see changelog.txt
I received some suggestions so find attached a new version of OTIS V1.00 b06 date 2020/06/29.
Enjoy,
Hans
-------------------------------------------------------------------------------
Changes since version OTIS V1.00 b05 :
You can find detailed info of all modifications in Changelog.txt
New :
- Added option 'AUTOOPEN' orderbag files.
- Added option 'ORDER SCOPE'.
- Added checkbox 'FILELOCK' to place a file width lock until you uncheck it.
- Added menus to 'MOVE UP' or 'MOVE DOWN' a record.
- Added a 'CLEAR' button in the structure editor.
- 'Index manager' a orderbag name is automatically proposed when creating a new order tag.
Modif :
-'COPY/PASTE' functions copies and paste only visible columns.
- Some menus have a new position so that they are regrouped in function of record or file width operations.
Bug : - see changelog.txt
- Attachments
-
- Otis - V1b06 - 20200629.7z
- (857.53 KiB) Downloaded 221 times