Search found 932 matches

by utelle
Wed May 27, 2020 2:50 pm
Forum: wxCode
Topic: Suddenly having an odd issue with wxSqlite3...
Replies: 1
Views: 45

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: 826

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: 826

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: 826

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: 826

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: 868

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: 297

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...
by utelle
Tue Mar 10, 2020 12:25 pm
Forum: Compiler / Linking / IDE Related
Topic: Build wxWidgets 3.1.3 with VS2019
Replies: 8
Views: 359

Re: Build wxWidgets 3.1.3 with VS2019

A fresh download of wxW313 and wxS451 together with your configuration advise worked like a charm! Good to hear. The only thing I couldn't properly set in the setup props was the distinction between static and shared libraries, because unfortunately I need both. I used to having them in seperate di...
by utelle
Mon Mar 09, 2020 9:27 pm
Forum: Compiler / Linking / IDE Related
Topic: Build wxWidgets 3.1.3 with VS2019
Replies: 8
Views: 359

Re: Build wxWidgets 3.1.3 with VS2019

I built several wxWidget versions with several Visual Studio versions on Windows10 now, but to be honest: I had the privilege of using the project files that come with wxWidgets for vs users. Now I run into a problem compiling wxSqlite 4.4.6 (from utelle) with wxWidgets 3.1.3 MD: The build files fo...
by utelle
Sun Mar 08, 2020 8:27 am
Forum: wxCode
Topic: Construct sqlcipher sqlite files for minimal.
Replies: 7
Views: 671

Re: Construct sqlcipher sqlite files for minimal.

Suppose i have the code bellow ... wxSQLite3Database* initDB(void) { wxString testDBName = wxS("dub.db"); wxSQLite3Database* db = new wxSQLite3Database(); db->Open(testDBName); if (!wxFileExists(testDBName)) { db->UserAdd(wxS("user"), wxS("pswd"), true); db->UserLogin(wxS("user"), wxS("pswd")); db-...
by utelle
Tue Feb 25, 2020 11:29 am
Forum: wxCode
Topic: Construct sqlcipher sqlite files for minimal.
Replies: 7
Views: 671

Re: Construct sqlcipher sqlite files for minimal.

There is a practical example to construct for example sqlcipher-1.1.8-testkey.db or other file? Well, in principle the minimal sample shows you, how to set up a specific encryption scheme, and if you open a new database (instead of an existing one), you can create your own encrypted database. The f...
by utelle
Sun Feb 23, 2020 6:11 pm
Forum: wxCode
Topic: Construct sqlcipher sqlite files for minimal.
Replies: 7
Views: 671

Re: Construct sqlcipher sqlite files for minimal.

Can add this library to wxSQLite3 lib to have the ability to construct cipher databases? The SQLite encryption extension coming with wxSQLite3 supports all SQLCipher encryption schemes from version 1 up to version 4. That is, you don't need the SQLCipher library to be able to create, read and write...
by utelle
Sun Feb 23, 2020 4:20 pm
Forum: wxCode
Topic: Construct sqlcipher sqlite files for minimal.
Replies: 7
Views: 671

Re: Construct sqlcipher sqlite files for minimal.

How i can construct sqlcipher-1.1.8-testkey.db file? As i see with minimal all sqlcipher files don't construct from scratch but there are in samples folder. There is a way to make these files? Those SQLCipher test database files are included for convenience. They were simply copied from the [SQLCip...
by utelle
Sun Feb 16, 2020 11:03 pm
Forum: Database Related
Topic: WxWidgets 3.1, Windows, codeblocks and MySQL
Replies: 9
Views: 1452

Re: WxWidgets 3.1, Windows, codeblocks and MySQL

I'm creating the database from scratch so I can choose the architecture. I usually use Mysql with phpmyadmin but it's ok to use any other solution. Which database architecture should be chosen heavily depends on the needs of your application. If a central database is required for all users of your ...
by utelle
Thu Feb 13, 2020 2:26 pm
Forum: wxCode
Topic: wxSQLite3 minimum sample output errors
Replies: 7
Views: 541

Re: wxSQLite3 minimum sample output errors

I am using Ubuntu 16.04, gcc 5.4.0 and GLIBC 2.23 All components are rather old. However, this might not be the reason for seeing the Glib messages. I found this post in the wxWidgets forum reporting similar problems - the post is very old (about 14 years) and affects a different, much older wxWidg...