Search found 6 matches

by Abeja
Mon Feb 04, 2019 8:09 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Connect Livecode to DB
Replies: 9
Views: 709

Re: Connect Livecode to DB

Hi there, thank you very much! The semicolon was the failure, now it works :D
by Abeja
Mon Feb 04, 2019 5:38 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Connect Livecode to DB
Replies: 9
Views: 709

Re: Connect Livecode to DB

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.
by Abeja
Mon Feb 04, 2019 8:57 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Connect Livecode to DB
Replies: 9
Views: 709

Re: Connect Livecode to DB

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 :mrgreen:
by Abeja
Sun Feb 03, 2019 8:20 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Connect Livecode to DB
Replies: 9
Views: 709

Re: Connect Livecode to DB

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.
by Abeja
Sun Feb 03, 2019 7:29 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Connect Livecode to DB
Replies: 9
Views: 709

Re: Connect Livecode to DB

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 * ...
by Abeja
Sun Feb 03, 2019 3:10 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Connect Livecode to DB
Replies: 9
Views: 709

Connect Livecode to DB

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

Go to advanced search