Hi all,

I'm trying to build a mass update to take a current set of records and export them to a text file. 

However, I've put in coding to tell the system when it's on the first record to write the header line, but ignore it for further records ... but it's repeating the header.  When I use Writeln to check my @formresultsetcurrentposition, it counts off correctly.  Can you see why this isn't working?

vHeaderDate = @right(("0" + @dom(@date)),2) + "/" + @left(@month$(@date),3) + "/" + @YEAR(@date)

vDataPath = "c:\sesame2\data\padexport\KNG_" + @right(("0" + @dom(vHeaderDate)),2) + @left(@month$(vHeaderdate),3) + @year(vHeaderdate) + ".txt"

vHeader = "HDR" + @right(("0" + @dom(@date)),2) + "/" + @right(("0" + @month(@date)),2) + "/" + @year(@Date) + @newline()

FileDelete(vDataPath)

vFileHandle = FileOpen(vDataPath)
FileSeek(vDataPath, 0)

if @FormResultSetCurrentPosition("Pmt Admin Screen") = 1 then FileWrite (vFileHandle,vHeader)

vDataLine = (LOTS OF CODE)

FileWrite(vFileHandle,vDataLine)
FileWrite(vFileHandle,@newline())

FileClose(vFileHandle)
 

That did it ... thanks Ray!