Problem with update insert and select command (cont..)

"as ABG said, use AND instead of &&

do you have the columns Tee and Size in the table?

btw. you error message is displayed in the second Do it result, because you do not have any error handling in the GotResult event

if you later get the rowid back successfully, please note, that you also will get back the header row, which means the result will look like this

rowid

101

101 is just an example of a rowid.

you can extract the 101 from the example by using the split at block, just split at \n and you get a list with 2 items, then select the second item to get the rowid (in this case the 101) 

first try to get a vaild rowid back, then continue with the UPDATE statement

In continuation of this thread..

I corrected the And query but i get two results but not the row id.