PureBasic Forums - English

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

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?

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

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

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$ + "...

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

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

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

ChrisR wrote: ↑Wed Sep 21, 2022 12:07 pm IceDesign has been updated in version 1.7.5

Excellent work!
Keep going!

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

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

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

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

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!

@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