News:

Download Pelles C here: http://www.pellesc.se

Main Menu

Recent posts

#71
User contributions / Re: DynSQLite Library - SQLite...
Last post by Michele - November 11, 2026, 09:27:04 AM
Quote from: MrBcx on November 10, 2026, 10:32:03 PMI 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.  One thing I very much liked about MS Access was the
(Q)uery (B)y (E)xample feature for quickly and easily creating various sql statements, like Select
queries, Joins, Views, etc.  Adding a QBE feature is not an easy thing to accomplish but AI could
probably help a lot, if you decide to take on the challenge.
Not an easy task, could be a good feature, I'll give a try as I can.
What I would add in short are features that increment the flexibility of the library, i.e. I already introduced a flag that can be applied at each distinct column of a table that hide its value in editing, useful when using the table data editor in a custom program and the user doesn't want that field to show up or be changed, normally the primary key.
Maybe can be useful a similar flag to hide the value also in the browser.
These permits, together with per column validation functions, to use the generalized library functions to build custom interface for proprietary programs.
#72
User contributions / Re: DynSQLite Library - SQLite...
Last post by Michele - November 10, 2026, 11:06:13 PM
I touched again the sources to force workspace zip to include a folder with the gdiplus headers.
I have the frankie SDK installed, and didn't realized that pellesC still comes without those files (why Mr Pelle doesn't include them?).
The updated library DynSqlite_workspace_V00.73.11.zip is available for download on sourceforge.net, download the workspace here.
Robert please let me know if it compiles now.
#73
User contributions / Re: DynSQLite Library - SQLite...
Last post by MrBcx - November 10, 2026, 10:32:03 PM
Quote from: Michele on November 10, 2026, 03:08:47 PMThanks MrBCX!  :)
The sample databases I used for the testing are available here on sourceforge.net.
I will appreciate your suggestion about what enhancements can be introduced.

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.  One thing I very much liked about MS Access was the
(Q)uery (B)y (E)xample feature for quickly and easily creating various sql statements, like Select
queries, Joins, Views, etc.  Adding a QBE feature is not an easy thing to accomplish but AI could
probably help a lot, if you decide to take on the challenge.

#74
User contributions / Re: DynSQLite Library - SQLite...
Last post by TimoVJL - November 10, 2026, 09:56:01 PM
A that win32_functions.db3 isn't mine.
It is in John Z project.

lib_src\AboutDlg.c(23): fatal error #1035: Can't find #include file <gdiplus.h>

src\background.c(24): fatal error #1035: Can't find #include file <fGdiPlusFlat.h>

include\FKSplitPicker.h(25): fatal error #1035: Can't find #include file <FkVirtualGrid.h>

sqlitestudio\src\About.c(25): fatal error #1035: Can't find #include file <sqlite3.h>.

EDIT: poide have a Differences tool, so after unpacking test folder it is easy to see, what files are missing source zip. After that zipping sources gives better result than ...

Also a WinMerge is good tool for it.

https://sourceforge.net/projects/dynsqlite/files/include/

How to force file to project, add something like this to one of project files
.EXCLUDEDFILES:
include\FkVirtualGrid.h \
include\sqlite3.h
.SILENT:
#75
User contributions / Re: DynSQLite Library - SQLite...
Last post by Robert - November 10, 2026, 09:35:32 PM
Quote from: Michele on November 10, 2026, 01:22:57 PMThanks Robert!  :)
I fixed the workspace zip and reloaded it. There were 2 problems.
The first was the missing folder for the SQLite3.h header, in my system compiled because I have this location in the system path.
The second problem was a missing header file that I included using <> brackets, so the zipper skipped it and doesn't included in the zip.
Please let me know if you can compile it now.
I will appreciate your opinion and what would you like to be added to the library.

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

I ran
Clean WorkSpace
then
Build WorkSpace

MemLeakCheck.lib is built
ReflectControl.lib is built
then in the IDE output window

Project opened: D:\WorkBench\Pelles C\Michele\DynSqlite_workspace_V00.73.10\sqlitestudio_dll.ppj
Project build started
Project build ended successfully
Project build started
Project build ended in complete failure


#76
User contributions / Re: DynSQLite Library - SQLite...
Last post by Michele - November 10, 2026, 09:22:13 PM
Quote from: TimoVJL on November 10, 2026, 03:14:51 PMhttps://forum.pellesc.de/index.php?topic=11621.msg42757#msg42757

I tested it database from a that project.

A SQLite 3 databases use also extension form '.db3'

https://fileinfo.com/extension/db3

If the modification of your table 'Functions' as below still works for you, you can edit easily it using SQLiteStudio on DynSQLite.
In the table schema editor, first image, change column type to integer for the columns 'HeaderC' and LibraryC'. For the same columns click the button 'FK', in the dialog that appears select the referenced table 'Header' for headers and 'Library' for libraries. For the referenced column select the 'key' column. Remove the second primary key, actually DynSqlite doesn't support multiple primary keys.
Press Proceed and the table will be modified keeping the same contents.
You must use the last revision of the library (V.00.73.11).


I can't post the modified database because is too large.
#77
User contributions / Re: DynSQLite Library - SQLite...
Last post by Michele - November 10, 2026, 09:10:41 PM
I made 2 fixes to the library:
  • Fixed table modification, MsqlAlterTable, that dropped the foreign key modification due to missing db context assignment.
  • Enhanced description column selection for foreign key fields in record editor. Now if no descriptive column is found it defaults to the first text column.

The library DynSqlite_workspace_V00.73.10.zip is available for download on sourceforge.net, download the workspace here.
#78
Assembly discussions / Re: Retrieving the size of a f...
Last post by Vortex - November 10, 2026, 07:28:21 PM
Attached is the 64-bit version.

#79
User contributions / Re: DynSQLite Library - SQLite...
Last post by Michele - November 10, 2026, 03:54:01 PM
Quote from: TimoVJL on November 10, 2026, 03:14:51 PMhttps://forum.pellesc.de/index.php?topic=11621.msg42757#msg42757

I tested it database from a that project.

A SQLite 3 databases use also extension form '.db3'

https://fileinfo.com/extension/db3

Hello TimoVJL.
I'll add it to the file open/save dialogs.
Please let me know if there is something else to add.
#80
User contributions / Re: DynSQLite Library - SQLite...
Last post by TimoVJL - November 10, 2026, 03:14:51 PM
https://forum.pellesc.de/index.php?topic=11621.msg42757#msg42757

I tested it database from a that project.

A SQLite 3 databases use also extension form '.db3'

https://fileinfo.com/extension/db3