LiveCode Forums.

Here is a great resource;
http://www.w3schools.com/sql/default.asp
From that, this works
SELECT * FROM Customers WHERE CustomerID=1;
But you have to have a unique element in the row.
The example table looks like
CustomerID CustomerName ContactName Address City PostalCode Country
Where the ...

Simon wrote:That says gName is empty.
Check it in the variable watcher.

Simon
Edit; Remember that gName must be declared as a global everywhere it is used.

I got it to work! Thank you so much for your help! Is there any chance you know how to return a row of data from SQLite? Instead of a column?

Hi Erica,
You see how tName (gName) is outside of the quotes?
Has to be.

Simon
Hi Simon,
gName is outside of the quotes:
put "SELECT * FROM ingredients where name =" && gName & ";" into tSQLQuery
put revDataFromQuery(tab,return,gDatabaseID,tSQLQuery) into field "Outcome"

When I breakpointed ...

Hi erical12,
Try this;
put "SELECT * FROM ingredients where name =" && tName & ";" into tSQLQuery
And double check your location
on mouseUp
answer file "Select your DB"
put it
end mouseUp

Simon
Edit... sorry missed your last question
I use the same connection as you have except I have spaces ...

HA, WAIT!
It should read: specialFolderPath(" Documents ")
With a trailing S ! Looks like this could be it :D


My problem is that tDatabaseID is not a number--I fixed "Documents" and relocated my variables. I wrote an if statement to test if tDatabase was a number, and it's not... How do I fix ...

I've been struggling to get my database to connect to a SQLite database I have.

I have my specialFolderPath and I put it into a variable but when I look under the variables tab, tDatabasePath is empty. Why is it empty? I'm still relatively new to LiveCode so I might be missing something big.

When ...