Search found 940 matches

by utelle
Fri Jul 03, 2020 5:35 pm
Forum: Database Related
Topic: Problems building wxWidgets 3.0.5 and sqlite 3.31 (amalgamation)
Replies: 25
Views: 186

Re: Problems building wxWidgets 3.0.5 and sqlite 3.31 (amalgamation)

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...
by utelle
Fri Jul 03, 2020 3:09 pm
Forum: Database Related
Topic: Problems building wxWidgets 3.0.5 and sqlite 3.31 (amalgamation)
Replies: 25
Views: 186

Re: Problems building wxWidgets 3.0.5 and sqlite 3.31 (amalgamation)

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...
by utelle
Fri Jul 03, 2020 1:53 pm
Forum: Database Related
Topic: Problems building wxWidgets 3.0.5 and sqlite 3.31 (amalgamation)
Replies: 25
Views: 186

Re: Problems building wxWidgets 3.0.5 and sqlite 3.31 (amalgamation)

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...
by utelle
Fri Jul 03, 2020 9:26 am
Forum: Database Related
Topic: Problems building wxWidgets 3.0.5 and sqlite 3.31 (amalgamation)
Replies: 25
Views: 186

Re: Problems building wxWidgets 3.0.5 and sqlite 3.31 (amalgamation)

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...
by utelle
Thu Jul 02, 2020 9:05 pm
Forum: Database Related
Topic: Problems building wxWidgets 3.0.5 and sqlite 3.31 (amalgamation)
Replies: 25
Views: 186

Re: Problems building wxWidgets 3.0.5 and sqlite 3.31 (amalgamation)

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 ...
by utelle
Fri Jun 12, 2020 7:33 am
Forum: Database Related
Topic: Crach inserting same objects in wxSqlite3
Replies: 5
Views: 416

Re: Crach inserting same objects in wxSqlite3

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...
by utelle
Sun Jun 07, 2020 5:17 pm
Forum: Database Related
Topic: How to copy tables between databases?
Replies: 3
Views: 359

Re: How to copy tables between databases?

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...
by utelle
Thu Jun 04, 2020 8:48 am
Forum: Database Related
Topic: How to copy tables between databases?
Replies: 3
Views: 359

Re: How to copy tables between databases?

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...
by utelle
Wed May 27, 2020 2:50 pm
Forum: wxCode
Topic: Suddenly having an odd issue with wxSqlite3...
Replies: 1
Views: 373

Re: Suddenly having an odd issue with wxSqlite3...

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...
by utelle
Sun Apr 19, 2020 7:35 am
Forum: Database Related
Topic: regex select
Replies: 7
Views: 1094

Re: regex select

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),...
by utelle
Sun Apr 12, 2020 8:17 am
Forum: Database Related
Topic: regex select
Replies: 7
Views: 1094

Re: regex select

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...
by utelle
Sun Apr 12, 2020 8:12 am
Forum: Database Related
Topic: regex select
Replies: 7
Views: 1094

Re: regex select

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 ...
by utelle
Sat Apr 11, 2020 10:00 pm
Forum: Database Related
Topic: regex select
Replies: 7
Views: 1094

Re: regex select

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...
by utelle
Sun Mar 22, 2020 7:30 pm
Forum: wxCode
Topic: Escaping string in wxSqlite3
Replies: 2
Views: 977

Re: Escaping string in wxSqlite3

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...
by utelle
Tue Mar 10, 2020 3:52 pm
Forum: Compiler / Linking / IDE Related
Topic: wxbase29u.lib expected in wx313 project
Replies: 7
Views: 424

Re: wxbase29u.lib expected in wx313 project

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...