Page 1 of 3

A new database tool, OTIS, Open Table InSpector

Posted: Mon Jun 22, 2020 12:42 pm
by hansmarc
Hi everybody,

a few months ago i started the developpement of a new database tool.
It is called OTIS, Open Table InSpector.

You will find in the attached zip file the executable, a readme and a changelog file.
Yes, it is like DBU, DBFVIEW and all the others but read the readme file to know why i wrote it and
to get a impression what you can do with it.

I have mentionned in the readme file that i will publish the source prg (almost 10.000 lines) as open source later on
so that you can include it in your own projects. There are no dependencies, everything is in written in one prg file.
I used hmgextended so some translation are necessary for hmg but you can already use the exe version.
For the moment i will wait for your reactions, bug reports and suggestions.
Some parts and idees of the program are borrowed from others prg like dbfview, dbu, ...

This is my participation in the Harbour community. Thanks everybody for all the support for many years.

UPDATE 29/06/2020 :
latest version is attached


Enjoy, i hope it is of any purpose for you.

Hans

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

Posted: Mon Jun 22, 2020 1:14 pm
by salamandra
Hi @hansmarc,

Thanks for share it with us :)


Salamandra - Brazil

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

Posted: Mon Jun 22, 2020 5:48 pm
by JALMAG
Thanks!

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

Posted: Mon Jun 22, 2020 6:05 pm
by dragancesu
Interesting

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

Posted: Tue Jun 23, 2020 12:52 pm
by Anand
Hi Hans,

Good job.

I am more of a keyboard fellow, and found otis is mouse driven. Also it did not open NTX files.
These are my feedback as of now.

BTW I use 'save view' of DBU for dataset type requirement.

Regards,

Anand

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

Posted: Tue Jun 23, 2020 8:41 pm
by hansmarc
Hi Anand and other readers,

find attached a updated version of Otis with RDD support for DBFCDX, DBFNTX and DBFNSX.

UPDATE 29/06/2020 :
latest version is attached

Bye
Hans

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

Posted: Wed Jun 24, 2020 1:37 am
by Steed
Thanks

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

Posted: Wed Jun 24, 2020 3:51 am
by luisvasquezcl
Thanks

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

Posted: Thu Jun 25, 2020 7:46 am
by hansmarc
Hi,

small update to V1.0 b03.

The DESCEND() function is added as a EXTERNAL.
This function is sometimes used in a index KEY expression and Otis refused to open the index file.

Reported by Marcelo Brigatti, thanks.

UPDATE 29/06/2020 :
latest version is attached


Regards
Hans

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

Posted: Thu Jun 25, 2020 7:47 am
by RPC
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