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

A new database tool, OTIS, Open Table InSpector

Post 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
Attachments
Otis - V1b06 - 20200629.7z
(857.53 KiB) Downloaded 159 times
Last edited by hansmarc on Mon Jun 29, 2020 11:27 am, edited 4 times in total.
User avatar
salamandra
Posts: 311
Joined: Thu Jul 31, 2008 8:33 pm
DBs Used: DBF, MySQL, SQL
Location: Brazil

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

Post by salamandra »

Hi @hansmarc,

Thanks for share it with us :)


Salamandra - Brazil
There is one time in which is crucial awakening. That time is now. ( Buddha )
JALMAG
Posts: 262
Joined: Sun Jan 10, 2010 7:05 pm
DBs Used: DBF, MariaDB
Location: España - Spain

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

Post by JALMAG »

Thanks!
User avatar
dragancesu
Posts: 921
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

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

Post by dragancesu »

Interesting
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 »

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

Anand

Image
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 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
Attachments
Otis - V1b06 - 20200629.7z
(857.53 KiB) Downloaded 147 times
Last edited by hansmarc on Mon Jun 29, 2020 11:28 am, edited 2 times in total.
User avatar
Steed
Posts: 427
Joined: Sat Dec 12, 2009 3:40 pm

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

Post by Steed »

Thanks
User avatar
luisvasquezcl
Posts: 1258
Joined: Thu Jul 31, 2008 3:23 am
Location: Chile
Contact:

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

Post by luisvasquezcl »

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

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
Last edited by hansmarc on Mon Jun 29, 2020 11:28 am, edited 2 times in total.
RPC
Posts: 286
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: 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
Post Reply