A new database tool, OTIS, Open Table InSpector

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

hansmarc
Posts: 9
Joined: Thu Jun 23, 2016 5:38 am
Location: Belgium
Been thanked: 17 times

Re: A new database tool, OTIS, Open Table InSpector

Post by hansmarc »

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
Attachments
Otis - V1b06 - 20200629.7z
(857.53 KiB) Downloaded 29 times
Last edited by hansmarc on Mon Jun 29, 2020 11:26 am, edited 4 times in total.

User avatar
Anand
Posts: 495
Joined: Tue May 24, 2016 4:36 pm
DBs Used: DBF
Has thanked: 190 times
Been thanked: 79 times

Post by Anand »

RPC wrote:
Thu Jun 25, 2020 7:47 am
Anand wrote:
Tue Jun 23, 2020 12:52 pm

BTW I use 'save view' of DBU for dataset type requirement.
Hi Anand
Do you have DBU compatible with win 10, 64 bit ?
Can you share ?
Thanks
Rajeev
Yes, I made it in Harbour for my Win10 64 bit. Attached here.

Regards,

Anand
Attachments
dbu9.zip
(738.63 KiB) Downloaded 76 times
Image

RPC
Posts: 210
Joined: Fri Feb 10, 2017 4:12 am
DBs Used: DBF
Has thanked: 92 times
Been thanked: 12 times

Post by RPC »

Anand wrote:
Thu Jun 25, 2020 10:46 am
Yes, I made it in Harbour for my Win10 64 bit. Attached here.

Regards,

Anand
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

User avatar
Rathinagiri
Posts: 5300
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 183 times
Been thanked: 202 times
Contact:

Post by Rathinagiri »

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.

hansmarc
Posts: 9
Joined: Thu Jun 23, 2016 5:38 am
Location: Belgium
Been thanked: 17 times

Post by hansmarc »

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
Attachments
Otis - V1b06 - 20200629.7z
(857.53 KiB) Downloaded 6 times
Last edited by hansmarc on Mon Jun 29, 2020 11:25 am, edited 1 time in total.

mlnr
Posts: 106
Joined: Fri Aug 28, 2015 1:52 pm
DBs Used: DBF
Location: Hungary
Has thanked: 33 times
Been thanked: 13 times

Post by mlnr »


Yes, I made it in Harbour for my Win10 64 bit. Attached here.

Regards,

Anand
Hi Anand

Are you willing to share your modified source of dbu.exe?
Best regards,
Gabor

User avatar
Anand
Posts: 495
Joined: Tue May 24, 2016 4:36 pm
DBs Used: DBF
Has thanked: 190 times
Been thanked: 79 times

Post by Anand »

mlnr wrote:
Fri Jun 26, 2020 3:41 pm

Yes, I made it in Harbour for my Win10 64 bit. Attached here.

Regards,

Anand
Hi Anand

Are you willing to share your modified source of dbu.exe?
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
Image

User avatar
Anand
Posts: 495
Joined: Tue May 24, 2016 4:36 pm
DBs Used: DBF
Has thanked: 190 times
Been thanked: 79 times

Post by Anand »

RPC wrote:
Thu Jun 25, 2020 5:49 pm
Anand wrote:
Thu Jun 25, 2020 10:46 am
Yes, I made it in Harbour for my Win10 64 bit. Attached here.

Regards,

Anand
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
Hi Rajeev,

Check the font in cmd properties.

Regards,

Anand
Image

RPC
Posts: 210
Joined: Fri Feb 10, 2017 4:12 am
DBs Used: DBF
Has thanked: 92 times
Been thanked: 12 times

Post by RPC »

Anand wrote:
Sat Jun 27, 2020 9:57 am

Check the font in cmd properties.

Regards,

Anand
Hi Anand
Thanks. Got it.

hansmarc
Posts: 9
Joined: Thu Jun 23, 2016 5:38 am
Location: Belgium
Been thanked: 17 times

Post by hansmarc »

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
Attachments
Otis - V1b06 - 20200629.7z
(857.53 KiB) Downloaded 44 times

Post Reply