gb.db2 Order by

[grayghost4]

I just updated to the latest fedora 41 kernel Gnome
Gambas 3.20.2 ... fresh install
still no joy

[grayghost4]

There is a bug in the new gb.db2 the line below produces the results shown

Print DB.Subst("delete from [&1] where '&2' = &3 ", sFileName, sFileField, sFileIndex)

delete from ['bkaccts'] where ''accname'' = 'newAcc88'
and produces a error

while gb.db outputs this

delete from "bkaccts" where "accname" = 'newAcc88'
and works as expected

[Poly]

Hi Grayghost4

There is a bug in the new gb.db2 the line below produces the results shown

Thank you very much for the confirmation and all your efforts.
I don't have a Bug Tracker-Account yet, but would make one if no one else can or wants to do it.

Greetings Poly

[grayghost4]

I have no clue how to find or use the bugtracker

[gbWilly]

I have no clue how to find or use the bugtracker

https://gambaswiki.org/bugtracker

I didn't test but it might well be a bug.

And be aware:
- Subst is part of core gb
- db.subst is part of gb.db and now gb.db2 componet and is a different ballgame meant for substitution specifically aimed at sql based databases.

[grayghost4]

I attempted several time to register at the bug tracker .... unsuccessful .... seems there is a bug there also

maybe I will get several email by the weekend

[thatbruce]

Well, you both are correct. I can now confirm the bug (or maybe even more bugs) in DB2. I was having difficulty convincing myself they were here as the symptoms didn't happen with a postgres database. Hence my grumpy comments about "it does what it says it does". Sorry.
Now, as regards the bug tracker. (greyghost, did you get my PMs?) and for everyone else ... gmail is blocking the registration confirmation email from the Gambas bugtracker server, if you register with a gmail account you'll never get it. Today, I registered again with another mail account from another free mail provider and got the confirmation in seconds.
regards
b

[grayghost4]

yes, I did use a gmail.com account and never received a reply .
But if you file a report I don't need a error tracker account

[Poly]

Hi thatbruce

Hence my grumpy comments about "it does what it says it does". Sorry.

That is a beautiful character. Thank you.
You didn't actually say anything bad, but as I'm not an IT specialist and am currently familiarising myself with Gambas, I was a bit confused.
I'm all the more pleased that you can now confirm the error and have apologised for your grumpy comments.

Great community, many thanks to you all.

[Poly]

Hi Grayghost4

But if you file a report I don't need a error tracker account

I have just written my first bug report. I hope it is understandable.