LiveCode Forums.

Code: Select all

repeat with y = 1 to the number of words of yourstring
put word y of yourString into field fieldReference
end repeat

Code: Select all

on closeField
-- check the global connection ID to make sure we have a database connection
global gConnectionID
if gConnectionID is not a number then
   answer error "Please connect to the database first."
   exit to top
end if

-- edit these variables to match your database & table
-- this assumes a table called Table1 with 3 fields
put "tracker" into tTableName
put "trackerjob, trackercert" into tFields
put fld "jobn" into tJobN
put fld "certn" into tCertN

-- construct the SQL - the :1, :2 & :3 placeholders in the SQL will be filled by variables in the revExecuteSQL line
put "INSERT INTO " & tTableName & " (" & tFields & ") VALUES (:1, :2)" into tSQL

-- send the SQL to the database, filling in the placeholders with data from variables
revExecuteSQL gConnectionID, tSQL, "tJobN", "tCertN"

-- check the result and display the data or an error message
if the result is a number then
   answer info "New record added."
else
   put "SELECT * FROM " & tTableName & " WHERE trackercert=" & tCertN into tSQL
   -- query the database
    put revDataFromQuery(Tab, cr, gConnectionID, tSQL) into tData
    -- check the result and display the data or an error message
    if item 1 of tData = "revdberr" then
        answer error "There was a problem querying the database:" & cr & tData
    else
        put item 1 of tData into field "view"
    end if
end if
end closeField

Code: Select all

else
        put item 1 of tData into field "view"
    end if
end if
end closeField

Code: Select all

...
set itemdel to TAB ## !!!
put "job,certn,name_of_field_3" into tFieldNames

## MUCH easier than to type -> put "sdsdsd" & TQB & "sdsdsd" & TAB & "xcxcxc" & TAB & "xcxcxc"... :-D
replace "," with TAB in tFieldNames

## Now loop through the record from database:
repeat with i = 1 to the num of items of myData
  put item i of myData into fld (item i of tFieldNames)
end repeat
...

Code: Select all

put revDataFromQuery(Tab, cr, gConnectionID, tSQL) into tData
to
put revDataFromQuery(Comma, cr, gConnectionID, tSQL) into tData

Code: Select all

put item 1 of tData into field "view"

Code: Select all

put item 1 of tData into field "jobn"
put item 1 of tData into field "certn"
put item 1 of tData into field "field3"