Search found 417 matches

by thanos
Tue Mar 05, 2024 2:55 pm
Forum: Coding Questions
Topic: MySQL database codepage problems
Replies: 8
Views: 263

Re: MySQL database codepage problems

This works for me MySQL 8.0.32 with defaults, using SET NAMES utf8 or not does not matter for me, probably because defaults. test.txt $EPWNYMIA|ΓΡΙΒΑΣ ΒΑΣΙΛΕΙΟΣ» test.pb EnableExplicit UseSQLiteDatabase() UseMySQLDatabase() #DB_FILE = "test.db" #DATA_FILE = "test.txt" #MYSQL_USE...
by thanos
Tue Mar 05, 2024 12:15 pm
Forum: Coding Questions
Topic: MySQL database codepage problems
Replies: 8
Views: 263

Re: MySQL database codepage problems

Fred wrote: Tue Mar 05, 2024 10:48 am Please post some code reproducing the issue, or we can't really help
Fred , do you need the sqlite database?
by thanos
Tue Mar 05, 2024 11:12 am
Forum: Coding Questions
Topic: MySQL database codepage problems
Replies: 8
Views: 263

Re: MySQL database codepage problems

Please post some code reproducing the issue, or we can't really help EnableExplicit UseSQLiteDatabase() UseMySQLDatabase() #SQLITE_DB = 10 #MYSQL_DB = 11 Structure dbColumn ColumnIndex.i ColumnName.s ColumnType.i ColumnSize.i EndStructure Macro FixApostrophe(Text) ReplaceString(ReplaceString(Text, ...
by thanos
Tue Mar 05, 2024 10:41 am
Forum: Coding Questions
Topic: MySQL database codepage problems
Replies: 8
Views: 263

Re: MySQL database codepage problems

Fred wrote: Tue Mar 05, 2024 10:20 am BLOB are binary field, it shouldn't handle any conversion. Is it only the display which is wrong or the stored value ?
The stored value also
by thanos
Tue Mar 05, 2024 10:18 am
Forum: Coding Questions
Topic: MySQL database codepage problems
Replies: 8
Views: 263

MySQL database codepage problems

Hello to all. I tried to convert a SQLite database to MySQL. Everyghing was correct except the text in BLOB fields. Instead of $EPWNYMIA|ΓΡΙΒΑΣ ΒΑΣΙΛΕΙΟΣ» in MySQL the value stored is $EPWNYMIA|ΓΡΙΒΑΣ ΒΑΣΙΛΕΙΟΣ» I also tried to convert the text with CONVERT('" + String$ + "...
by thanos
Wed Dec 13, 2023 6:45 pm
Forum: General Discussion
Topic: 2023 is almost over, is there a PureBasic Report Writer yet?
Replies: 11
Views: 1664

Re: 2023 is almost over, is there a PureBasic Report Writer yet?

In some cases you can not avoid it. The Pyrex Suite is the only third party component I am using in my ERP. Invoices, reports, receipts, accounts, stock reports, statistic reports etc.all done with Pyrex Suite. For the conversion follow the infratec's suggestions. The pbPDF-Module by Thorsten1867 i...
by thanos
Tue Dec 12, 2023 10:53 am
Forum: General Discussion
Topic: 2023 is almost over, is there a PureBasic Report Writer yet?
Replies: 11
Views: 1664

Re: 2023 is almost over, is there a PureBasic Report Writer yet?

The Pyrex Suite (ArticReports and its print engine) is the best you could think of. With a minimal code you can do amazing things. I assume, thanos, that Pyrex Suite is a PureBasic application then? I just searched for it and I only found references to PureBasic and the Pyrex cooking bowls too, whi...
by thanos
Mon Dec 11, 2023 9:37 pm
Forum: General Discussion
Topic: 2023 is almost over, is there a PureBasic Report Writer yet?
Replies: 11
Views: 1664

Re: 2023 is almost over, is there a PureBasic Report Writer yet?

Hello. The Pyrex Suite (ArticReports and its print engine) is the best you could think of. With a minimal code you can do amazing things. I am using it as the report system in my commercial selling ERP and I don't have the slightest shortage. The only downside is that its interface is a bit outdated...
by thanos
Wed Oct 26, 2022 9:05 pm
Forum: Applications - Feedback and Discussion
Topic: IceDesign GUI designer
Replies: 572
Views: 137370

Re: IceDesign GUI designer

ChrisR wrote: Wed Sep 21, 2022 12:07 pm IceDesign has been updated in version 1.7.5
Excellent work!
Keep going!
by thanos
Fri Oct 14, 2022 7:37 am
Forum: Coding Questions
Topic: Extract list from XML
Replies: 4
Views: 409

Re: Extract list from XML

StarBootics wrote: Fri Oct 14, 2022 5:42 am Hello thanos,
You have to do it the hard way like this :
...
Best regards
StarBootics
It works, so it is perfect!
I tried with the same logic with you , but without success with the sublevels.
Thank you very much!
Best regards

Thanos
by thanos
Thu Oct 13, 2022 10:47 pm
Forum: Coding Questions
Topic: Extract list from XML
Replies: 4
Views: 409

Re: Extract list from XML

Thanks for your response Very very difficult in PB. I see If you look at the help of InsertXMLList() you will find that all members of the list needs the xml tag <element> If you have any chance use JSON. There is no chance, except if i wrote from scratch a xml2json converter in PB The structures ar...
by thanos
Thu Oct 13, 2022 8:16 pm
Forum: Coding Questions
Topic: Extract list from XML
Replies: 4
Views: 409

Extract list from XML

Hello. I took correctly the structure of <expensesInvoiceClassification> but i can't extract the list from the <invoicesExpensesClassificationDetails> key. EnableExplicit #XML = 0 #XML_TEXT = "<?xml version='1.0' encoding='utf-8'?>" + "<RequestedDoc>" + " <expensesClassifica...
by thanos
Fri Apr 08, 2022 12:57 pm
Forum: Coding Questions
Topic: REPORTS
Replies: 22
Views: 2269

Re: REPORTS

I took to using PurePDF after years of using SROD's excellent Arctic Reports. Once i'd put the initial effort in on my first report, all my other reports were put together pretty quickly and I haven't looked back since. That's not to say there are some things in PurePDF that seem to be missing, but...
by thanos
Thu Apr 07, 2022 8:20 am
Forum: Coding Questions
Topic: REPORTS
Replies: 22
Views: 2269

Re: REPORTS

holzhacker wrote: Wed Apr 06, 2022 6:27 pm If you want to produce your own reports, check out this VecVi module. He is very good.

viewtopic.php?f=12&t=69804
It is amazing module!
I didn't knew it.
Thank you very much for the info!
by thanos
Wed Apr 06, 2022 11:56 am
Forum: Coding Questions
Topic: REPORTS
Replies: 22
Views: 2269

Re: REPORTS

@Mark56us
I know it!
But if I am not wrong the discussion was about a report engine (with design, preview etc.)
A full reporting tool more or less, like the nxReport