Hello, since i updatet from gb.db to db.db2 the order by in the sql statement dont work anymore, what i have to change?
I have also the problem, when i have a combobox and i open the popup (in the combobox), select a entry and then i enter in the field a text, the keypress event is not working, until i put the focus to another control and then i go back. The same problem i have in the IDE, from time to time, i need to select again the module or class, otherwise the keyboard is not working. I have this issue on Ubuntu 24.04 and on Ubuntu 24.10 (x86_64 and arm64). Anyone a idea what is the problem?
Thanks

I'll leave the database problem to those with better knowledge on that subject.

Regarding your "Click" problem, try  Public Sub ComboBox1_Activate() not Public Sub ComboBox1_Click(). I think that will help you.

Thanks, sorry i wrote wrong, key_release is not working, key_press works.

 give us an example of how you are doing the order by query.
I have had no problems at all with db2,
b

 I do not get any key_release issues with combobox

But I often find i have typed something in a class/module but it did not appear because the editor was not focused and i have to click on the document to use the keyboard.

This happens sometimes after hitting the "run" button to test a program. (and possibly other IDE forms opening then closing)
It's simply (annoyingly) after a test run the editor does not regain focus and needs to be clicked.

It maybe a toolkit issue , try the IDE (and your program) with QT and see if it still happens.
env GB_GUI=gb.gui.qt gambas3

With gb.db works, but with gb.db2 not.

Today Key_Press don't work with Key.UP and Key.DOWN, i need to put the code  in Key_Release to work? after Key_Release is worked out the Click Event is fired??.
I have a combobox with there i search in a gridlist the data, with up and down i scroll the gridlist.

Andreas_K said

Code (gambas)

1. Public Function ImportDB(sTable As String, sField1 As String, sField2 As String, Optional sWhere As String) As Boolean
2.  
3.       ssql = db.Subst("SELECT * FROM &1 " & sWhere & " ORDER BY '&2' ", sTable, sField1)
4.    Endif
5.  

With gb.db works, but with gb.db2 not.

Hello, I am not an expert, but I am currently experimenting with an SQL database.
So far I have no problems with gb.db2
But I immediately notice something in your code.
You have not quoted correctly in db.Subst.
If you want to substitute a table name, you have to put it in square brackets.

See /doc/db-quoting - Gambas Documentation

"If a substitution pattern in enclosed with square brackets, then the argument is supposed to be a table name, and the Connection.Quote method is used to correctly quote the table name into the result string. "

so you have to write


Try it out to see if this fixes the error.

Best regards
Poly

Hi Poly,
Just a best practice thing - I'd recommend NOT using the name 'sWHERE' as a variable as it's a SQL key word and it makes it somewhat confusing when you look at the statement.

Can you give me an example of what you would pass in sWhere please, as I can't quite make sense of your SQL statement.

I'm not an expert but I do write a lot of MySql / SQLite based applications in Gambas.

This is a perfect example of what happens when the original post contains two questions!

Hi Quincunxian

Quincunxian said

Can you give me an example of what you would pass in sWhere please, as I can't quite make sense of your SQL statement.

I have simply taken Andreas' example and tried to quote correctly.
The sWhere doesn't make sense to me in this context either, but he wrote that this example worked for gb.db.
That's why I assumed that it could just be a problem with the quoting. As explained in my link to Wiki.

But it is not.

The following works for me with gb.db and gb.db.form but not with gb.db2 and gb.db2.form


So I can confirm the problem.

why bother with .subst ?
I use sqlite not sql … is there a diffenance ?….   Try this :


Or maybe all the variables need to be in brackets >   [&3]

grayghost4 said

Try this :

Code (gambas)

1. rs = DB("SELECT * From" & Quote(Namen) & "WHERE" & Quote(Vorname) & " = " & Quote(Risa) " Order by " & Quote(Nachmame) & " DESC")  

Many thanks,

I I had to adapt your code a bit, but it doesn't work.


with gb.db2 I get: Typ missmatsch wanted DB, got String instead  
with gd.db I get: not a function

I think there is a problem with gd.db2 or it works differently.
I get even with the simplest form that works normally under gd.db, with gd.db2:

rs = DB.Subst("SELECT * FROM [&1]", "Namen")

the following error.

No such table: 'Name'

But I have to check this again in a programme without IDE. Because I use a data browser to display it.
That's why the code looks exactly like this for me:


Works perfectly with gd.db and gb.db.form but not with gb.db2 and gb.db2.form

Thank you very much for your attention.

Best regards
Poly

Or maybe all the variables need to be in brackets > [&3]   if that puts them in " " quotes.

edit … I see that does not work  

This is my code which work with both versions

In my case it recognises it as a table, but says it doesn't know this table.

So it is definitely a different behaviour due to the new component.
It may be that my code is somehow badly built, I will test this again in a very simple database without an IDE.
So far I can't say that this is a bug or error.

I will test your code immediately

Thanks Poly

This is the complete module "  

Hi Graygost

It works as you said, but then of course the DB for the string has to be removed.
This is also how it works for me with gb.db2



Thank you very much.

But then it is a bug or not.
So the substitution with Db.Subst does not work.
That shouldn't be the case, should it?

 how about trying to Quote the subitutions

Quote(&3) ….

also I dont think you need the " " around the varable name… that is what Quote() does

Your code works perfectly and the code I gave works with gd.db and is also described in the wiki exactly the same way.

/doc/db-quoting - Gambas Documentation

Of course it is nonsense that there are two asterisks ** , of course there is only one, which stands for all columns.

Therefore, I would now clearly say that it is a bug in the DB.Stubst function.
But it would be great if someone else could confirm this.


And I have to set the inverted commas in the quote functions, otherwise I get an error.

unknown identifier

Your code is brilliant. Thank you very much.

I got some of the substitutions working

also found you don't need the [ ]


but I can't get the third Subst to work

The only way that is working on my machine is:


Order by works only without " ' " (Apostrophe) and db.subst put this evertime, so its not working.

https://gambaswiki.org/wiki/doc/db-quoting with this i get only error, table not found….

Sorry for the two questions in one post.

Ah, the fundamental misunderstand I believe that you may have is that DB.Subst is like Subst. It's not, nor was it ever intended to be.
It is for quoting values in SQL clauses in a way that Gambas can submit properly quoted sql.
If you want to insert bare strings into your sql then you must do it in 2 (or more)  steps. Using Subst for the bare strings and using DB.Subst for actual values.

hth
b

Hi thatbruce

thatbruce said

Ah, the fundamental misunderstand I believe that you may have is that DB.Subst is like Subst. It's not, nor was it ever intended to be.
It is for quoting values in SQL clauses in a way that Gambas can submit properly quoted sql.

However, this does not explain why it is shown differently in the wiki and why it runs in gb.db but not with gb.db2

It may be that some people here are only interested in a certain code to make something work. Not for me. I thought we should all be interested in finding and reporting errors or misunderstandings in the wiki or bugs in the individual components.

So if
works for me fine with gb.db and gb.db.form, but not with gb.db2 and db.gb2.form, then something must have changed in the Db.Subst function in the two components.

But if this works for you, then it may also be due to my system.

I am using Devuan , x11 and Gambas 3.20.2

Best regards Poly