setrow

beasscript-logo-small  

endoflive

setrow=<row>

 

sets the cursor to the specified row

 

Example for a subselect command:

 

for loop = 1 to <rowcount>

 setrow=<loop>

 sql=select itemname,u_me_verbrauch from oitm where itemcode=N'<art1_id>'

 setitem=itemname=<wert1>

 setitem=u_me_verbrauch=<wert2>

next

 

setrow is triggering the event rowfocuschanged and set the cursor outside from open-event.

This is very slow.

 

You can deactivate the trigger with

setredraw=false

 

Example

setredraw=false

for loop = 1 to <rowcount>

 setrow=<loop>

 // ...

next

setredraw=true

 

Best way: Work with item-object

setredraw=false

for loop = 1 to <dw_1.rowcount>

  //...

  dw_1.item.itemname:[ll_loop].value=<wert1>

  dw_1.item.u_me_verbrauch:[ll_loop].value=<wert2>

next

setredraw=true

 

See

setredraw