Search found 856 matches

by utelle
Sun Jul 14, 2019 5:43 pm
Forum: Database Related
Topic: Another wxSQLite3 Installation Question
Replies: 17
Views: 132

Re: Another wxSQLite3 Installation Question

I tried it and wxSQLite3 can't be build with GCC 5.1.0. Unfortunately this is true for wxSQLite3 version 4.0.0 and above. The reason is that the SQLite encryption extension uses a Windows system function for generating random numbers, but the definition of that function is missing from the header f...
by utelle
Sun Jul 14, 2019 5:39 pm
Forum: Database Related
Topic: Another wxSQLite3 Installation Question
Replies: 17
Views: 132

Re: Another wxSQLite3 Installation Question

I actually have MinGW 8.2.0. But I had to resort to the MinGW 5.1.0 compiler that came with Code::Blocks to compile wxWidgets. Why? When installing Code::Blocks you can choose between a setup with and a setup without bundled C++ compiler. You should have used the setup without bundled compiler, and...
by utelle
Sun Jul 14, 2019 9:57 am
Forum: Database Related
Topic: Another wxSQLite3 Installation Question
Replies: 17
Views: 132

Re: Another wxSQLite3 Installation Question

Personally, I prefer to build wxSQLite3 as a separate library (either static or shared/DLL) and I'd recommend to follow that route. That's my problem, utelle: I don't know how to do this. Since you use a Mingw compiler you can use the makefile coming with wxSQLite3 to build wxSQLite3. This will req...
by utelle
Sun Jul 14, 2019 9:43 am
Forum: Database Related
Topic: Another wxSQLite3 Installation Question
Replies: 17
Views: 132

Re: Another wxSQLite3 Installation Question

In addition to what Ulrich (the author of wxSQLite3) said, forget what i wrote about just adding all the source files. I just tried it and this method doesn't work any more, at least not as easily. So you have to try to build wxSQLite3 "the hard way". I really wouldn't call it " the hard way ". Usi...
by utelle
Sun Jul 14, 2019 9:38 am
Forum: Database Related
Topic: Another wxSQLite3 Installation Question
Replies: 17
Views: 132

Re: Another wxSQLite3 Installation Question

Have you tried building the library through the makefile? https://github.com/utelle/wxsqlite3#install This should definitely work, since typically Code::Blocks is used together with a Mingw compiler version. Alternatively, you can just add all source files to your project: https://forums.wxwidgets....
by utelle
Sun Jul 14, 2019 9:33 am
Forum: Database Related
Topic: Another wxSQLite3 Installation Question
Replies: 17
Views: 132

Re: Another wxSQLite3 Installation Question

I copied the sqlite3.dll and wxsqlite3.cpp into my project folder. Since wxSQLite3 version 3.5.0 (released in January 2017) the SQLite3 library is an integrated part of wxSQLite3. This really helps to avoid version mismatches. Although it is still possible to use wxSQLite3 together with a SQLite3 D...
by utelle
Sun Jul 14, 2019 9:20 am
Forum: Database Related
Topic: Another wxSQLite3 Installation Question
Replies: 17
Views: 132

Re: Another wxSQLite3 Installation Question

For every reason you can think of, I'm not a Windows user. BUT...I have to use it for a time for work-related stuff. For me it is the other way around: most of the time I develop under Windows and seldom under other platforms like Linux. I installed Code::Blocks. I have to admit that I don't know m...
by utelle
Fri Jul 12, 2019 8:46 pm
Forum: wxCode
Topic: wxPdfDocument wich fonts can I use?
Replies: 8
Views: 93

Re: wxPdfDocument wich fonts can I use?

I added to my code wxPdfFontManager::GetFontManager()->RegisterSystemFonts(); And now all fonts are drawn without '?'-sign. The PDF looks right on Debian too. but after that I have plenty of warnings that some fonts can't be loaded. The problem is that the installed system fonts include also bitmap...
by utelle
Fri Jul 12, 2019 8:39 pm
Forum: wxCode
Topic: wxPdfDocument wich fonts can I use?
Replies: 8
Views: 93

Re: wxPdfDocument wich fonts can I use?

The fonts foder does exist, I use fonts folder from source files, I'm I right? Installed fonts usually reside in some system folder. Where exactly, depends on the actual operating system. If your application uses specific fonts, it is usually the best approach to provide the required font files tog...
by utelle
Fri Jul 12, 2019 4:27 pm
Forum: wxCode
Topic: wxPdfDocument wich fonts can I use?
Replies: 8
Views: 93

Re: wxPdfDocument wich fonts can I use?

With wxPdfDocument wich fonts can I use? wxPdfDocument supports the standard PDF fonts (Courier, Times Roman, Helvetica - each in 4 variants: normal/bold/italic/bold-italic; Symbol, and ZapfDingBats). Additionally fonts in the formats Type1, TrueType, and OpenType are supported. The fonts can be in...
by utelle
Sat Jul 06, 2019 1:59 pm
Forum: Database Related
Topic: wxsqlite3 - can it be used in a multi-threaded application
Replies: 7
Views: 311

Re: wxsqlite3 - can it be used in a multi-threaded application

We have the following lines in our application, and I noticed that when the DB size is very huge (a couple of GBs big), these lines take upto 2 minutes to execute. But, funnily, this happens only the first time the application is run. The next time it takes a few seconds only. In fact, this is not ...
by utelle
Fri Jun 28, 2019 10:15 pm
Forum: Database Related
Topic: wxsqlite3 - can it be used in a multi-threaded application
Replies: 7
Views: 311

Re: wxsqlite3 - can it be used in a multi-threaded application

Does wxSqlite3 open the DB in serialized mode by default? Yes, the serialized mode (THREADSAFE=1) is the default mode selected at compile time (unless you change the compile time options). That is, it is possible to select at runtime whether a database connection should use multi-thread threading m...
by utelle
Mon Jun 17, 2019 8:22 pm
Forum: wxCode
Topic: wxPdfDocument joining 2 PDF files. Is it possible?
Replies: 6
Views: 459

Re: wxPdfDocument joining 2 PDF files. Is it possible?

hello, I looked at templates.cpp file before posting. There are only 2 example functions templates1() and templates2() and both functions only open PDF file, add new page and then draw some image/text on new page. Could you, please, give some hint? Function templates2() extracts a page from an exis...
by utelle
Mon Jun 17, 2019 3:56 pm
Forum: wxCode
Topic: wxPdfDocument joining 2 PDF files. Is it possible?
Replies: 6
Views: 459

Re: wxPdfDocument joining 2 PDF files. Is it possible?

No. This is not completely true. From conversation in this issue : wxPdfDocument is a component for generating PDF documents. It is not a component for parsing, displaying or printing PDF documents. The mentioned issue is related to printing and previewing a PDF file. This is indeed not possible to...
by utelle
Tue Mar 19, 2019 9:21 pm
Forum: Database Related
Topic: complicated select
Replies: 5
Views: 369

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';