Mrbaseball34
Programmer
Got this script:
and it is supposed to modify this SQL file (DBUpdate0008.sql):
However, the lines are not changed when I display the file after the loop.
Stepping through, I see that the value of %LINE% is getting set correctly.
What am I doing wrong?
Code:
item: Set Variable
Variable=INAPPDIR
Value='c:\temp'
end
item: Read/Update Text File
Variable=LINE
Pathname=c:\DBUpdate0008.sql
Flags=00000001
end
item: Set Variable
Variable=LINE
Value=Ucase$(LINE)
Flags=00100000
end
item: If/While Statement
Value=InStr(LINE, ":INAPPDIR" )
Flags=00001101
end
item: Parse String
Source=%LINE%
Pattern=:InAppDir
Variable1=LEFT
Variable2=RIGHT
Flags=00000010
end
item: Set Variable
Variable=LINE
Value=%LEFT% %INAPPDIR% %RIGHT%
end
item: End Block
end
item: End Block
end
item: Display ReadMe File
Pathname=c:\DBUpdate0008.sql
Title=g
end
Code:
UPDATE SYMSPROCESS
SET Command = :INAppDir + '\Bin\SendOrder.exe'
WHERE Process_Key = 700
UPDATE SYMSPROCESS
SET Command = :INAppDir + '\Bin\PriceManager.exe'
WHERE Process_Key = 800
UPDATE SYMSPROCESS
SET Command = :INAppDir + '\Bin\DTSWImport.exe'
WHERE Process_Key = 900
Stepping through, I see that the value of %LINE% is getting set correctly.
What am I doing wrong?