;**********************
;* RoboTask Task file *
;* Do not edit!       *
;**********************
 
[Root]
ActionAfterRun=INTEGER|0
Actions=FOLDER
Automat=INTEGER|-1
CatID=INTEGER|565106205
ContinueOnError=INTEGER|0
ExternalName=STRING|"Task238"
Hide=INTEGER|0
ID=INTEGER|1221458337
Name=STRING|"Exec SQL from text"
Priority=INTEGER|3
RunOnClose=INTEGER|0
RunOnStartup=INTEGER|0
ToLog=INTEGER|3

[Actions]
Action1=FOLDER
Action2=FOLDER
Action3=FOLDER
Action4=FOLDER

[Actions\Action1]
ActionID=STRING|"A_LOOP_TEXT"
Enabled=INTEGER|-1
Name=STRING|"Text Loop"
Params=FOLDER

[Actions\Action1\Params]
destvar=STRING|"TEXT_LINE"
line0=STRING|"""1-st value"",1,""1-st comment"""
line1=STRING|"""2-nd value"",2,""2-nd comment"""
line2=STRING|"""3-d value"",3,""3-d comment"""
linecount=STRING|"3"
sourcetext=STRING|"1"

[Actions\Action2]
ActionID=STRING|"A_EXECSQL"
Enabled=INTEGER|-1
Name=STRING|"SQL Query"
Params=FOLDER

[Actions\Action2\Params]
connectionstring=STRING|"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test\test.mdb;Mode=ReadWrite|Share Deny None;Persist Security Info=False"
override=STRING|"0"
password=STRING|"2005621642221612164019088"
sql=STRING|"""insert into table1 (field1,field2,field3) values "",""('{Text_Line(0)}', {Text_Line(1)}, '{Text_Line(2)}')"""

[Actions\Action3]
ActionID=STRING|"A_LOOP_END"
Enabled=INTEGER|-1
Name=STRING|"End Loop"

[Actions\Action4]
ActionID=STRING|"A_VARIABLES_REMOVE"
Enabled=INTEGER|-1
Name=STRING|"Remove variable ""TEXT_LINE"""
Params=FOLDER

[Actions\Action4\Params]
varname=STRING|"TEXT_LINE"