Page 2 of 3

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

Posted: Thu Jun 25, 2020 8:42 am
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

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

Posted: Thu Jun 25, 2020 10:46 am
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

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

Posted: Thu Jun 25, 2020 5:49 pm
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

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

Posted: Fri Jun 26, 2020 10:34 am
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.

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

Posted: Fri Jun 26, 2020 12:10 pm
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

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

Posted: Fri Jun 26, 2020 3:41 pm
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?

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

Posted: Sat Jun 27, 2020 9:56 am
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

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

Posted: Sat Jun 27, 2020 9:57 am
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

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

Posted: Sun Jun 28, 2020 2:59 pm
by RPC
Anand wrote: Sat Jun 27, 2020 9:57 am
Check the font in cmd properties.

Regards,

Anand
Hi Anand
Thanks. Got it.

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

Posted: Mon Jun 29, 2020 11:23 am
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