PureBasic Forums - English

The Jaro-Winkler distance is a metric for measuring the edit distance between words.
It is similar to the more basic Levenshtein distance but the Jaro distance also accounts for transpositions between letters in the words.
With the Winkler modification to the Jaro metric, the Jaro-Winkler distance ...

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_USER = "user ...

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

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

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

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

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

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

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>" +
" <expensesClassificationsDoc>" +
" <ls ...

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

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!