Search found 5 matches

by Mikofig
Thu Mar 07, 2019 4:08 pm
Forum: Databases
Topic: Importing from an SQL database into a table field
Replies: 3
Views: 2470

Re: Importing from an SQL database into a table field

Thank you very much Klaus, that worked as intended. Though how does the use of CR fix the issue?
by Mikofig
Thu Mar 07, 2019 3:43 pm
Forum: Databases
Topic: Importing from an SQL database into a table field
Replies: 3
Views: 2470

Importing from an SQL database into a table field

I have been trying to import rows from a database into a table in order to create a scoreboard. I have managed to import the data but it only gets displayed in one row of the table rather than two rows even though I specified a return after the data. I have a field (Searchvalues) that contains the s...
by Mikofig
Thu Feb 07, 2019 3:41 pm
Forum: Talking LiveCode
Topic: Returning a value from an SQL query
Replies: 5
Views: 1608

Re: Returning a value from an SQL query

Thank you very much, everything works fine now
by Mikofig
Thu Jan 31, 2019 3:37 pm
Forum: Talking LiveCode
Topic: Returning a value from an SQL query
Replies: 5
Views: 1608

Re: Returning a value from an SQL query

put "SELECT COUNT(*) FROM scores" into tSQL
revExecuteSQL gConnectionID, tSQL
if the result is a number then
put it into temp
put "00000" + temp into ScoreID
else
answer"nope"
end if
answer ScoreID
by Mikofig
Thu Jan 31, 2019 3:07 pm
Forum: Talking LiveCode
Topic: Returning a value from an SQL query
Replies: 5
Views: 1608

Returning a value from an SQL query

I am using MAMP in order to connect to an SQL database. I can connect just fine but the problem arises when I try to execute my query. I am trying to perform a count(*) query on a table and return the value but every time I run it the result is "OK" which apparently counts as a number because it cau...

Go to advanced search