after a loooong time I have begun to play with Livecode again. So here is my question :
The result of
Code: Select all
put "SELECT * FROM table1" into resultTable
put revDataFromQuery(, , gConID, resultTable) into tmpResult
answer tmpResult
This way I can't really work with repeat for each line l in tmpResult. Is there a way to prevent the linebreak within a record from a database table?R1Value1 R1Value2 R1Value3
R1Value4 R1Value5
R2Value1 R2Value2 ...
Or alternatively, if I throw each value of each record into an own variable, would this be insufficient regarding performance?
Code: Select all
put "SELECT qty FROM table1" into rQty
put "SELECT type FROM table1" into rType
put "SELECT symbol FROM table1" into rSymbol
put revDataFromQuery(, , gConID, rQty) into tmpQty
put revDataFromQuery(, , gConID, rType) into tmpType
put revDataFromQuery(, , gConID, rSymbol) into tmpSymbol