Multiple DatabaseUpdate inside DatabaseQuery issue

Just starting out? Need help? Post your questions and find answers here.
User avatar
Fangbeast
PureBasic Protozoa
PureBasic Protozoa
Posts: 4795
Joined: Fri Apr 25, 2003 3:08 pm
Location: Not Sydney!!! (Bad water, no goats)

Re: Multiple DatabaseUpdate inside DatabaseQuery issue

Post by Fangbeast »

Wow! 2023 and I have to strip rtf code again the old fashioned way.

Funny thing too, I loaded the database with fields containing rtf data into SqliteExpertPersonal and tried to display a field and it doesn't even show the data, just the rtf encoding. Guess my tools have not kept pace with development.
Amateur Radio/VK3HAF, (D-STAR/DMR and more), Arduino, ESP32, Coding, Crochet
User avatar
Fangbeast
PureBasic Protozoa
PureBasic Protozoa
Posts: 4795
Joined: Fri Apr 25, 2003 3:08 pm
Location: Not Sydney!!! (Bad water, no goats)

Re: Multiple DatabaseUpdate inside DatabaseQuery issue

Post by Fangbeast »

Bugger me sideways with a fresh halibut. My trick of using the editorgadget to strip rtf data from a database record no longer works. Not in 6.02 anyway so I guess it's the brick wall for my face for now.
Amateur Radio/VK3HAF, (D-STAR/DMR and more), Arduino, ESP32, Coding, Crochet
Oso
Enthusiast
Enthusiast
Posts: 595
Joined: Wed Jul 20, 2022 10:09 am

Re: Multiple DatabaseUpdate inside DatabaseQuery issue

Post by Oso »

Is it that we can't display RTF within EditorGadget in 6.02 and beyond, or that we just can't paste RTF into it?
User avatar
Kuron
Addict
Addict
Posts: 1626
Joined: Sat Oct 17, 2009 10:51 pm
Location: Pacific Northwest

Re: Multiple DatabaseUpdate inside DatabaseQuery issue

Post by Kuron »

Fangbeast wrote: Sun Oct 01, 2023 5:44 am Bugger me sideways with a fresh halibut.
And people wonder why anthropologists study the mating habits of Fangles. :shock:
Best wishes to the PB community. Thank you for the memories. ♥️
User avatar
Fangbeast
PureBasic Protozoa
PureBasic Protozoa
Posts: 4795
Joined: Fri Apr 25, 2003 3:08 pm
Location: Not Sydney!!! (Bad water, no goats)

Re: Multiple DatabaseUpdate inside DatabaseQuery issue

Post by Fangbeast »

Oso, the data worked once my tired brain figured out to use beta 9 and which was the right flag to use.

But somewhere during the import, some strange characters must have made it into the imported database (Standard GetDataBaseString etc, nothing fancy) and at least 15 records are not being retrieved by the new program as if there is something invisible in some of the record fields.

Looked up the faulty records but SqliteExpert Personal is showing nothing strange that should not be there in each fields.

/me throws a dessicated Halibut in Kuron's general direction
Amateur Radio/VK3HAF, (D-STAR/DMR and more), Arduino, ESP32, Coding, Crochet
Oso
Enthusiast
Enthusiast
Posts: 595
Joined: Wed Jul 20, 2022 10:09 am

Re: Multiple DatabaseUpdate inside DatabaseQuery issue

Post by Oso »

Fangbeast wrote: Sun Oct 01, 2023 9:03 am Oso, the data worked once my tired brain figured out to use beta 9 and which was the right flag to use.
Ah, got it. I'd assumed you were referring to this related topic from last week, about RFT in the EditorGadget... viewtopic.php?t=82554
Fangbeast wrote: /me throws a dessicated Halibut in Kuron's general direction
I thought I saw something flying past the office window earlier :D
Post Reply