Search found 842 matches

by utelle
Tue Mar 19, 2019 9:21 pm
Forum: Database Related
Topic: complicated select
Replies: 5
Views: 301

Re: complicated select

Wolfgang wrote:
Tue Mar 19, 2019 1:53 pm
Is there a way to not show duplicates?
Sure. Just add the key word distinct, for example:

Code: Select all

select distinct w1.book, w1.chapter, w1.verse from words w1, words w2
    where w1.book=w2.book and w1.chapter=w2.chapter and abs(w1.vers-w2.vers) <= 3
      and w1.word='test' and w2.word='me';
by utelle
Tue Mar 19, 2019 9:16 pm
Forum: Database Related
Topic: problem with update
Replies: 4
Views: 118

Re: problem with update

Solved with wxInt16 test = oldt.Replace("'", "''"); Sqlite printf did not work It would work if used correctly. There is a difference in the format codes %q and %Q . As described in the SQLite format code Q documentation, "The %Q substitution type also puts single-quotes on both ends of the substit...
by utelle
Mon Mar 18, 2019 7:03 am
Forum: Database Related
Topic: complicated select
Replies: 5
Views: 301

Re: complicated select

Here a small sample word book chapter vers test 1 1 1 me 1 1 1 test 1 1 2 not 1 1 2 me 2 1 1 test 2 1 1 How would a select look like if I need to find all occourences where word="test" and word="me" and book,chapter and verse are the same. Meaning finding all verses where test and me is in it. If y...
by utelle
Wed Mar 06, 2019 2:55 pm
Forum: wxCode
Topic: wxPdfDoc worning on MAC OSX stattic linking
Replies: 3
Views: 221

Re: wxPdfDoc worning on MAC OSX stattic linking

hello. Thank you for your time and full explanations I rebuilded wx3.1.3 and I don't have that warning anymore my options are: ../configure --enable-unicode --with-osx_cocoa --with-macosx-version-min=10.14 --with-macosx-sdk=/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Develo...
by utelle
Wed Mar 06, 2019 7:56 am
Forum: wxCode
Topic: wxPdfDoc worning on MAC OSX stattic linking
Replies: 3
Views: 221

Re: wxPdfDoc worning on MAC OSX stattic linking

If I link my somelib.dylib with libwxcode_osx_cocoau_pdfdoc-3.1.a staticcaly, then I get this annoying warning ||warning: direct access in function 'wxLogger::~wxLogger()' from file '/usr/local/lib/libwxcode_osx_cocoau_pdfdoc-3.1.a(pdftemplate.o)' to global weak symbol 'wxStringToNumHashMap_wxImple...
by utelle
Tue Feb 19, 2019 11:11 am
Forum: C++ Development
Topic: Database to show with changing column width
Replies: 37
Views: 1143

Re: Database to show with changing column width

I want the width of the column seperate in each row. That's impossible in any list based control and it sounds like a horrible GUI anyway. And i still don't think you need (or even want) this. Can you make a scribble or something of what you have in mind? Why I cannot quickly think of a better way,...
by utelle
Fri Feb 01, 2019 9:17 am
Forum: Database Related
Topic: wxSQLite3Database* h_dbi[1024] = new wxSQLite3Database();
Replies: 4
Views: 437

Re: wxSQLite3Database* h_dbi[1024] = new wxSQLite3Database();

With additional informatin like strongs numbers, versenumbers chapter book, and everything inseperate fields, it easily grows to 40mb. And that is for just one translation, furthermore, dictionaries easily go up to 100mb per dictionary. So what?! The theoretical size limit for a SQLite database is ...
by utelle
Fri Feb 01, 2019 8:43 am
Forum: Database Related
Topic: wxSQLite3Database* h_dbi[1024] = new wxSQLite3Database();
Replies: 4
Views: 437

Re: wxSQLite3Database* h_dbi[1024] = new wxSQLite3Database();

I would need something similar to: wxSQLite3Database* h_dbi[1024] = new wxSQLite3Database(); In principal you could allocate an array of wxSQLite3Database objects with the following statement: wxSQLite3Database* h_dbi = new wxSQLite3Database[1024](); // Open first connection h_dbi[0].Open(...); How...
by utelle
Tue Jan 29, 2019 11:38 am
Forum: Database Related
Topic: wxsqlite3 in eigenes Projekt einfügen
Replies: 14
Views: 513

Re: wxsqlite3 in eigenes Projekt einfügen

Additional info: The sqlite3secure was not able to compile without errors: Severity Code Description Project File Line Suppression State Error C1083 Cannot open include file: 'unicode/utypes.h': No such file or directory sqlite3libicu d:\wxwidgets-3.1.2\1own\hadevarim\wxsqlite3-master\sqlite3secure...
by utelle
Tue Jan 29, 2019 11:26 am
Forum: Database Related
Topic: wxsqlite3 in eigenes Projekt einfügen
Replies: 14
Views: 513

Re: wxsqlite3 in eigenes Projekt einfügen

Hi Wolfgang, ... and I wrote in german as I did know utelle is from Germany, and I hoped to get an answer from him, Tend to go to the creator. Yes, I'm from Germany, but I use English almost every day. And usually I'm quite responsive, although I don't check the wxForum daily. Did remember now, that...
by utelle
Mon Jan 28, 2019 6:00 pm
Forum: Database Related
Topic: wxsqlite3 in eigenes Projekt einfügen
Replies: 14
Views: 513

Re: wxsqlite3 in eigenes Projekt einfügen

Hallo Wolfgang, in der ersten Antwort auf Deine Anfrage hat ONEEYEMAN zu recht daruf hingewiesen, dass es sich hier um ein Englisch-sprachiges Forum handelt. In Zukunft bitte auf Englisch schreiben, wenn Du hier Antworten bekommen möchtest. Im folgenden ein paar Anmerkungen - ausnahmsweise auf Deuts...
by utelle
Wed Jan 09, 2019 10:08 pm
Forum: Announcements and Discoveries
Topic: ANN: wxPdfDocument 0.9.7 released
Replies: 0
Views: 258

ANN: wxPdfDocument 0.9.7 released

Version 0.9.7 of wxPdfDocument has been released. This version is compatible with wxWidgets 2.8.12, 3.0.x, and 3.1.x. Sample PDF files created with wxPdfDocument can be found here . Although this release is mainly a bug fixing release, a few useful improvements were also added (see below). What's ne...
by utelle
Sat Dec 15, 2018 9:02 am
Forum: wxCode
Topic: wxSQLIte3 from sources...
Replies: 13
Views: 2023

Re: wxSQLIte3 from sources...

Hello. This time i am trying to compile minimal last download version from sources in windows 10. But i am taking error ... C:\wxsqlite3\sqlite3secure\src\chacha20poly1305.c|347|undefined reference to `[email protected]'| SystemFunction036 corresponds to RtlGenRandom , a function that is part of ...
by utelle
Fri Dec 14, 2018 1:11 pm
Forum: Announcements and Discoveries
Topic: ANN: wxSQLite3 4.4.0 released
Replies: 0
Views: 428

ANN: wxSQLite3 4.4.0 released

Version 4.4.0 of wxSQLite3 has been released. It supports version 3.26.0 of SQLite . This version is compatible with wxWidgets 2.8.12, wxWidgets 3.0.x, and wxWidgets 3.1.x. What's new in this release Upgrade to SQLite version 3.26.0 Added support for the SQLCipher 4 database format Note : SQLite3 bi...
by utelle
Mon Nov 05, 2018 2:33 pm
Forum: Database Related
Topic: Need help on wxsqlite3.4.2.0
Replies: 3
Views: 1013

Re: Need help on wxsqlite3.4.2.0

I have downloaded wxsqlite3.4.2.0 and is facing the following problems: 1. I am unable to access database created in the earlier version (3.3.5.0) even if the database is not encrypted (i.e. password = ''). My code (lazarus freepascal, with zeolib database component) is as follows: ZConnection1.Dis...