A new database tool, OTIS, Open Table InSpector

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

hansmarc
Posts: 40
Joined: Thu Jun 23, 2016 5:38 am
Location: Belgium

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 250 times
Last edited by hansmarc on Mon Jun 29, 2020 11:26 am, edited 4 times in total.
User avatar
Anand
Posts: 595
Joined: Tue May 24, 2016 4:36 pm
DBs Used: DBF

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

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 568 times
Regards,

Anand

Image
RPC
Posts: 281
Joined: Fri Feb 10, 2017 4:12 am
DBs Used: DBF

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

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: 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

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: 40
Joined: Thu Jun 23, 2016 5:38 am
Location: Belgium

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

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 178 times
Last edited by hansmarc on Mon Jun 29, 2020 11:25 am, edited 1 time in total.
mlnr
Posts: 126
Joined: Fri Aug 28, 2015 1:52 pm
DBs Used: DBF

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

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: 595
Joined: Tue May 24, 2016 4:36 pm
DBs Used: DBF

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

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
Regards,

Anand

Image
User avatar
Anand
Posts: 595
Joined: Tue May 24, 2016 4:36 pm
DBs Used: DBF

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

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
Regards,

Anand

Image
RPC
Posts: 281
Joined: Fri Feb 10, 2017 4:12 am
DBs Used: DBF

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

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: 40
Joined: Thu Jun 23, 2016 5:38 am
Location: Belgium

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

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 221 times
Post Reply