MasterchiefJB wrote:
The code works very well but rather than answering the result I would like to list the result in a list field.
And the search field should display every available mod entry instead of Mod1,Mod2, Mod3 (I am currently trying to figure out how to do this... no idea yet...
).
by default, a revselect returns columns separated by tab and record separated by return.
so, in your case, put this script into a button :
on mouseup
global gConnectionID
-- will return all the records from the table mods
put "SELECT ModName,UploadDate from mods" into tSQL
put revDataFromQuery(, , gConnectionID, tSQL) into theResult
-- tells LiveCode to separate items by "tab"
set itemdelimiter to tab
-- this is the list field
put empty into fld "search"
--the loop to put first item of each line of the SQL query into our list field
repeat with i = 1 to the number of lines of theResult
put item 1 of line i of theResult & CR after fld "search"
end repeat
end mouseup
To display one record, it's exactly the same idea. create several fields
make a revselect to read the record you want and then use "item" like :
put item 1 of theResult into field "modname"
put item 2 of theResult into field "updateDate"
