Otis, database tool, a new version V1.1 b01

[hansmarc]

Hi everybody,

i m glad to announce a new version of Otis, a database viewer tool.
I have just created a repository in github where you can download a zip, the manual and the changelog files.

https://github.com/hansmarc/Otis

Below changelog for this version.

Regards
Hans

------------------------------------------------------------------------------------------

V 17-07-2020 : OTIS V1.10 b01

New : 'Otis manual.pdf' included in zip file.

New : Added rdd driver LETODBF from Elchs (https://github.com/elchs/LetoDBf). (fork from Alexander Kresin LETODB.)
This is really a excellent client server solution. Thanks Elchs.

Modif : 'Otis Dataset Manager'
The RDD driver name is also saved in the dataset for each individual opened table.
It is possible to use tables with a different RDD in the same dataset.
ex. local files with RDD DBFCDX and LetoDBf files with RDD LETO.

Modif : 'Plugin mode'
A lot of modifications for "Plugin mode" of Otis.lib.
Please read included document 'Otis manual.pdf'.
Some remarks in it are very important.

New : 'Otis Dataset Manager'
Settings menu.
Used to define area numbers and LetoDbf server settings.

New : 'Otis Dataset Manager'
Update of columns 'F' filelock status,
'F' file is locked or loaded in excl. mode
'R' a record is locked.
'R+' multiple records are locked.

Bug : 'Otis Dataset Manager'
Otis exits with a error when you hit menu 'Remove Index' when there where no tables opened.

Bug : 'Otis Dataset Manager'
The table OTIS.DS.DBF could not be opened if another RDD was set than DBFCDX.
We now use the VIA clause to open this table.

New : Some warning messages.

New : REQUEST of all functions mentioned below. They could be used in a index expression.
ABS, ALLTRIM, AT, CHR, CTOD, CDOW, CMONTH, DATE, DAY, DELETED, DESCEND, DTOC, DTOS, DOW, ;
EMPTY, I2BIN, L2BIN, LEFT, LEN, LOWER, LTRIM, MAX, MIN, MONTH, OS, PAD, PADC, ;
PADL, PADR, RAT, RECNO, RIGHT, ROUND, RTRIM, SPACE, STOD, STR, STRZERO, ;
SUBSTR, REPLICATE, TIME, TRANSFORM, TRIM, UPPER, VAL, VALTYPE, YEAR,;
SOUNDEX

New : All known codepages in Harbour are included now in Otis simply by including the file "hbextcdp.ch".
Suggestion from 'Ivo Fritz Hasse' who asked to add "PT850".

New : Added RDD "SIXCDX".
Complete list of rdds loaded, "DBFCDX", "DBFNTX", "DBFNSX", "SIXCDX".

Modif : Otis program icon has been changed. Much better i think.

Modif : 'Table Inspector'
Otis show now the number of orders that are opened in the upper left label 'Orders (xx)'.
No longer necessary to open the combobox to see how many orders are opened.

Modif : 'Table Inspector'
'Delete key' could already be used to Delete/Recall a record but
from this version this feature is only enabled if the checkbox 'Allow Edit' is checked.

Corr. : 'Table Inspector'
Scope button and checkbox are disabled if there is no order/index selected.

Corr. : 'Table Inspector'
The order combobox was not updated correctly when a new order tag was created.

Modif : 'Table Properties'
Table Info text is reordered and some info is added, ex. used RDD driver.

Corr. : 'Index Manager'
New index, the tag name can maximum be 10 characters.

Corr. : 'Index Manager'
If one of the expressions failed a error message was displayed but afterwards
Otis tried nevertheless to create the new order.

[fouednoomen]

Many thanks

[hansmarc]

Hi everybody,

uploaded to github a small update, https://github.com/hansmarc/Otis

Modifications see below and changelog.txt.

There is still a bug with the LetoDbf server.
In some situation Otis exits with a error if you click 'Add table' in the dataset manager.
I am working on it.

Regards
Hans

22-07-2020 : OTIS V1.10 b02
----------------------------

Bug : 'Otis.ini file'
Otis quits with a error after update because some new ini vars were not yet defined in the ini file.

New : Menu 'Settings'
Added a 'Test conn. Leto' button to test the connexion with a LetoDbf server.

[RPC]

Hi Hansmarc
Thanks for OTIS. I find it quite useful.
There is a little request I want to make. I use .ntx files for indexing. In the window for selecting index files you have provided mask only for .cdx files could you please provide a mask for .ntx files also so that I don't have to look through all the files to find my .ntx file.
With best wishes
Rajeev