Hi,
first I’m new to Base, but I worked a lot with SQL, Basic… (use windows 11, try with DEV 25.8.3.1 and 25.8)
For testing some stuff I create a small table just with an Id (bigInt, auto) and wert (text) and put some lines of data.
Then I try to get access from basic to that table. Didn’t work (what ever the reason is/was)
Next I go to the database (name “Typ”) itself and play a bit with SQL:
select * from “Typ” worked as expected
select “id” from “Typ” worked as expected
select “wert” from “Typ” worked as expected
select “wert” from “Typ” where “id” = 1 worked as expected
select “wert” from “Typ” where “wert” = “Airport” (this exist in the DB)
and I get
Column not found: Airport in statement [select “wert” from “Typ” where “wert” = “Airport”
I tried some variants of that, but no chance. Every time I try to use the second column (wert) in the command I got and “Column not found”-Error.
Where is my problem here? I guess I’m just to stupid, but every example I found did exactly the same.
Database definition:
Thank you for any good tip to solve that 
Georg
ps: sorry for my english, I’m native german