DynSQLite Library - SQLite support library

[Michele]

No. Same problem with last two updates including DynSqlite_workspace_V00.73.10.

Robert the version V00.73.11 works?
Download the workspace here.

[TimoVJL]

I don't do much with databases anymore ( retired 12 years ago ) but when I was doing DB work,
most of it involved MS Access and Sql Server.

Same here, retired few years ago, and had to at worklife to suffer of MS Sql Server, Oracle, Progress, and with a their client drivers.
MS SQL Server was an easy part. For Oracle have to make a special installer for minimal client database drivers.

[John Z]

OK same here VAX/VMS DBMS, Ingres, Oracles, MS SQL, Access, ISAM DB (anyway I'm still no expert)

I used 'DB Browser for SQLite Version 3.13.1' to create the DB. 
https://sqlitebrowser.org/

I modified the DB per the request (as I understood it) using the the same tool, and attached it here for testing in the DynSQLite program.  The changes do not break my Hint_SA code. The DB is very small if you .7z it, or use .zip

However - Why does a database need to be changed to use a specific editor?  There is nothing inherently wrong with the database, yes changing HeaderC and LibraryC to numeric is not unreasonable but as is should not be breaking an editor.  Not that uncommon to have multiple primary keys either imo, even though I had not implemented using both.

I have not download DynSQLite lib and program since the first posting, waiting for the dust to settle a bit. Hadn't tried to build it yet either....

John Z

Note: If testing in Hint_SA rename the db to the original win32_functions.db3 (hard coded in the program)

[Michele]

I modified the DB per the request (as I understood it) using the the same tool, and attached it here for testing in the DynSQLite program.  The changes do not break my Hint_SA code. The DB is very small if you .7z it, or use .zip

However - Why does a database need to be changed to use a specific editor?  There is nothing inherently wrong with the database, yes changing HeaderC and LibraryC to numeric is not unreasonable but as is should not be breaking an editor.  Not that uncommon to have multiple primary keys either imo, even though I had not implemented using both.

I have not download DynSQLite lib and program since the first posting, waiting for the dust to settle a bit. Hadn't tried to build it yet either....

John Z

Note: If testing in Hint_SA rename the db to the original win32_functions.db3 (hard coded in the program)

Hello John Z, your database structure doesn't break the DynSQLite editor, you can use it on your original database without any problem.
The library got a feature that analyzes the table's foreign key and shows a more friendly visualization in the editor for such fields.
In your database you join 2 tables, on headers and libraries, without a foreign key declaration (relaxed schema), if you declare the 2 foreign keys the editor automatically shows the available FK values using the most human friendly text field in the referenced table.
So for quick fixes, or to add more entries, you can easily select the header or library using the name instead of the numeric key, and take advantage of the filter available on top of the selection combo to locate faster the header/library you want. DynSQLite will take care to insert the correct key.
Using an integer for key reference speeds up database work removing eventual conversions.
The modification to the data base could have been done directly with DynSQLite using tools->modify_table using the dialog editor showed in my former posts.
It was a suggestion in hope that the feature I tried to give to my library could make things easier, not a request.