it has a Username title and userid value and a coded value like this:
Code: Select all
<option value="UserID">Username</option>
is because I need to do an insert based on the UserID into a database table.
The code I am using now to populate the option list is this:
Code: Select all
put revDataFromQuery(tab ,cr ,dbID ,tSQL) into tList
revCLoseDatabase(dbID)
if tList contains "revdberr" then return ""
set the rowDelimiter to cr
# the New... function below isn't implemented yet
put tList & cr & "-" into tList
set the text of button "Event" to tList