Otis, database tool, new version V1.1 b03, 01-08-2020

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
hansmarc
Posts: 13
Joined: Thu Jun 23, 2016 5:38 am
Location: Belgium
Been thanked: 26 times

Otis, database tool, new version V1.1 b03, 01-08-2020

Post by hansmarc »

Hi everybody,

you can find a new release (v1.1 b03, 01-08-2020) on github :

https://github.com/hansmarc/Otis

Regards
Hans

--------------------------------------------------------------------------------------------------
Changelog file : OTIS, Open Table InSpector
Author : Hans Marc (Belgium)
Latest update : 01-08-2020
--------------------------------------------------------------------------------------------------

01-08-2020 : OTIS V1.10 b03
----------------------------

Bug : You get multiple runtime errors if you run Otis.exe from a different location
if you right clicked, by example, on a table file to 'open' it.
Reason, Otis used getcurrentfolder() for the location of the ini file.
We now use hb_dirbase().
Suggestion proposed by Mario (mhsabado).

New : Connexion info LetoDbf rdd
Added server mode info with LETO_GETSERVERMODE()

New : Otis as default windows program to open tables in explorer.
Default rdd driver is always DBXCDX.

New : Command line option :
Otis table1.dbf, table2.dbf, table3.dbf, ...etc.
or
Otis table1.dbf table2.dbf table3.dbf ...etc
will add all the specified tables to a new dataset.

Modif : 'LetoDbf server'
Click 'Add table' with LetoDbf rdd activated.
Some letoDbf servers return a 'Undefined' variable with the leto_directory() function.
We still are searching for the reason.
It happens when we scan the 'root' directory to build a tree for the filepicker form.
code : aDir := leto_directory("\*.*", "D")
if valtype(aDir) == "U"
....
Otis displays a message if this happens and longer quits with a error.
No subdirectories will be displayed in the "tree" control.
If you see this message please tell me what your server configuration is.

hansmarc
Posts: 13
Joined: Thu Jun 23, 2016 5:38 am
Location: Belgium
Been thanked: 26 times

Post by hansmarc »

Hi,

small update of Otis on :

https://github.com/hansmarc/Otis

Regards
Hans


01-08-2020 : OTIS V1.10 b04
----------------------------

Bug : 'First start of Otis.exe'
1.There is no dataset table file Otis_ds.dbf if you start Otis for the first time in a folder.
Load a dbf in the dataset.
Exit the program. Otis asks if you want to save the changed dataset.
Otis exits with a error if you confirm because there is no dataset table.
This table is now created when you start Otis.
Before it was only created if you used menus 'save' or 'load' a dataset.

2. If you start Otis from a different location (see bug v1.10 b03)
and you start Otis for the first time than the name of the dataset
table OTIS_DS.DBF did not use hb_dirbase or any other path.
This could result in a Dos error 5 because Otis tried to create the dataset
table in the current folder.

Bug : 'LetoDbf'
saving a table in the 'Inspector' didn't function when the letoDbf rdd was used.

Post Reply