LiveCode Forums.

Hi there, thank you very much! The semicolon was the failure, now it works

Hi,
thank you Form your answer! but I want to Select from my DB-table the attributes which are similar to the user's answer in field " Cityfield". Your example works perfectly because am already connected to the DB but this ist not what I need.

Hi,
yes, I have always used gDate which is a global vat´riable where I saved the user input of field "Date".
g Datefield is a Tipo. But thank you for trying

yes field "Cityfield" is there and has a script:
on mouseup
set the locktext of me to "false"
put "" into me
select before me
end mouseup
So The idea is that the user could inter a city's name in the field and after clicking the button it switches to the next card and dispalys the result in ...

Hi Klaus,
thnak you very much for your answer! Sorry no to be very precise.
I declared all the gVariables on top.Actually it is:

global gConnID
global gCityfield
global gDate
on mouseUp
put fld "Cityfield" into gCityfield
put fld "Date" into gDate
put revDataFromQuery(tab, return,gConnID ...

Hi,
I am new in Livecode programming and I am struggling :|
I have to connect a project in Livecode to SQlite DB which has worked well. The problem was when I wanted to select the elements from my DB-table which are similar to a field content in a card ( user input) it gives me an error.
This is my ...