LiveCode Forums.

Code: Select all

put "SELECT " & round(amount,2) & " FROM prlabordist" into dbCommand

Code: Select all

put "select round(amount,2) as amount from prlbordist" into dbCommand

Code: Select all

put "SELECT round(amount,2) FROM prlabordist" into dbCommand

Code: Select all

put "SELECT " & round(amount,2) & " FROM prlabordist" into dbCommand

Code: Select all

   put revdatafromquery(tab,cr,dbID,"select *  from prlabordist") into tData -- initial query
-- if its empty, don't bother to run do anything else   
if tData is not empty then 

-- set up a string to update the right field based on the primary key (id)
      put "UPDATE prlabordist SET amount = [[tAmount]] WHERE id=[[tId]]" into tSql
-- since the query was done using a tab as one of the delimiters, specify it here
      set the itemdelimiter to tab

-- to speed things up if there is a huge number or rows you can do a begin and commit segment.
-- the only issue would be that if one update in the list fails, they all fail. 
-- But its HUGELY faster to do it this way if there are lots of rows
      revexecutesql dbID,"BEGIN" 

-- loop through the data, 1 line at a time, parse the data, and execute an update for each. 
      repeat for each line tLine in tData
         put item 1 of tLine into tId -- split the data up
         put round(item 2 of tLine,2) into tAmount -- round the value and put it in a var
         revexecutesql dbID,merge(tSql) -- merge the current values into the sql string and execute
      end repeat
      revexecutesql dbID,"COMMIT" -- all lines have been sent, go ahead and commit.   

-- as mentioned you could drop the BEGIN and COMMIT lines and it would still work, but would not be as fast. 
   end if
end mouseUp