wxWidgets Discussion Forum

I didn't know whether you{r team} did the development or you just acquire some license from official SQLite dev team. The official SQLite encryption extension is a commercial product, to which I don't have access. Of course, I didn't reinvent the wheel, that is, most crypto algorithms used to imple...

In addition to what Ulrich already said - SQLite is free of charge, but there are extensions which are cost money. If you go with wxSQLite some of those extensions are included in there. Among other extensions (like additional math functions) wxSQLite3 includes a SQLite encryption extension which i...

But if you have a look at the precompiled binaries for windows: https://www.sqlite.org/download.html There are only DLLs. No headers, no libs. ??? Someone who has an application which uses a SQLite DLL just needs the DLL to upgrade the application to a new version of SQLite. The application develop...

The "strange order" of the build log message actually came from multitreaded building. If I swith to 1 horse, the errors all belong to sqlite3.c and its use of (C++) pch etc. Thanks for clarifying. From the log messages shown before it didn't become clear which compilation unit produced the error m...

When building wxWidgets alone, all works well. As soon as I add sqlite3.c I get error(s). No problems with FLTK. (I'm just new to this and thought this would be the easiest way. But there must be a reason for "wxsqlite"???) Any help appreciated. g++.exe -Wall -pipe -mthreads -Winvalid-pch -include ...

The "crash" is most likely an exception thrown by wxSQLite3. Wrap the code in try/catch and print the exception message. It should tell you what's wrong. (if you don't know how to do that, search the wxSQLite3 sample for "catch (wxSQLite3Exception& e)") As the OP confirmed an exception was thrown d...

Try this: wxString file = openFileDialog.GetPath(); wxSQLite3Database* db = initDB(); db->AttachDatabase(file, wxS("dbtemp")); db->ExecuteUpdate(wxS("INSERT INTO main.clients SELECT * FROM dbtemp.clients;")); db->DetachDatabase(wxS("dbtemp")); The first parameter of method AttachDatabase is the file...

I must copy the rows from a one database to other. [...] Now i have the external temp.db with same type of clients table. I must add all objects in main database. As i see i must use the ATTACH key. https://www.sqlite.org/lang_attach.html I have no picture how i can do that. There is any example to...

So I have this SQL String I store in a variable: select distinct PartNumber from WEBSITE where PartNumber in (select PartNumber from WEBSITE where PartNumber != \"\" group by PartNumber having (COUNT(PartNumber) > 1)) order by PartNumber; This looks for duplicate item numbers in our DB and list any...

SELECT * from table WHERE lower(column) GLOB "*addTildeOptions(searchText)*" Like this I managed to get it running for specialised characters. But the problem I have now I would have a couple of characters which should be ignored by the select all together (no matter how often or when they appear),...

Try to convert the java code for c++ wxString addTildeOptions(wxString searchText) { wxRegEx mynew(_T("[aáàäâã]"),wxRE_BASIC); mynew.ReplaceAll(&searchText, _T("\\[aáàäâã\\]")) // searchText.ReplaceAll("[eéèëê]", "\\[eéèëê\\]") // searchText.replaceAll("[iíìî]", "\\[iíìî\\]") // searchText.replaceA...

Not even sure if regex is the only way. Just need a way to find it. Probably regular expression are not the only way. However, I don't know enough about languages like Hebrew to be able to give you further advice. SELECT * from table WHERE lower(column) GLOB "*addTildeOptions(searchText)*" But for ...

I would need a select, where it does not see a difference in hebrew if the vowel points are different, or more important if there are any sentence markers in hebrew in. The text is in unicode in a field with name wort, and a table called bibel. יֵּ֥לֶךְ יֵּ֣לֶךְ both should be found and not just on...

I didn't find special function for escaping strings in the documentation so I just replaced all occurances of "'" with "\\'". wxSQLite3 provides the class wxSQLite3StatementBuffer for this purpose. Please consult the SQLite documentation for detail information about supported formatting options. Ho...

This has always been a little confusing for me, but I don't talk about using a DLL build, but rather about the microsoft runtime libraries. I have the impression that the terms static and shared/DLL are a bit mixed up in this discussion. On the one hand, you can use static or shared/DLL C runtime l...