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 field1.

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, "SELECT * ...

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 ...