SQLMan released

[p-OS]

Error 1:

Open an existing SLQLite3 database file. In query Tab enter:

Code: Select all

select * from sqlite_master

Press on exceute.
As this table is part of any database file by default, I expected it to work. But nothing happens at all.

Error 2:
Open an existing SLQLite3 database file. In query Tab enter:

Code: Select all

select * from bla

where bla is a table not exisiting.
Press on exceute.
I get an error dialog saying "1598: An error has occurred: no such table: bla!" .
So far behaviour is ok. But after clicking Ok, SQLMan window is empty (assume my database file has been closed automatically). An false sql query shouldn't quit the project. Esepecially as data that has been inputted is lost.

[lazi]

The content of sqlite_master is actually displayed at the left side of the window. I can't imagine any good use for it, however it could be addressed by the query.

The closing of the database is really annoying, I will fix it.

Thanks for your comments!

[lazi]

SQLMan updated again. Version 0.5.
Now with UTF8 support.

http://aminet.net/biz/dbase/SQLMan.lha

I am so curious about experiences of non Latin-1 writers.

[lazi]

Another update is released.
SQLMan 0.6 can be downloaded from http://aminet.net/package/biz/dbase/SQLMan
Platforms are: OS4, MOS, AROS, OS3.x

A new product page is added to my site: http://kezdobetu.hu/software/sqlman.php

History:
~~~~~
Version 0.6 (11-Feb-2025)

- chg: OS4Depot import module needs HURL.hwp plugin for SSL HTTP communication
- fix: some OS3.x fix made it to work with MUI3.8, but still has problems
- add: modules list is shown in the about window
- chg: updated SQLite plugin to 1.2 in the archive
- add: added some balance class between gui elements
- add: set screen title to program name and version
- chg: SQL errors do not close database
- fix: mui ids cannot handle some non-latin chars, so field names are converted to unique latin strings in gui xml
- fix: xlsx importer - removed own hungarian UTF8 converter function needed prior Hollywood UTF8 support
- fix: query panel ArrowRight button made it properly with imagebutton class
- fix: OS4Depot import module raw string functions fixed against UTF8
- fix: OS4Depot import module failed if subcategory was missing
- add: dropfile support for open database from the first icon
- add: about window displays sqlite3 engine version
- fix: dbf importer convert strings to UTF8 if needed