This is in a mass update? If so, there are all sorts of issues here.

1. The first line is a FileClose. You have not opened a file yet.

2. If this is in a mass update, it runs for each record. This means that you are deleting the file and redumping your entire database for each record.

3. vFileGo is a local variable, so it does not keep it's value as you move from record to record.

...and so on.

This code looks like it dumps the database all at once, but you say you have it in a mass update. This would indicate that you are trying to write the values for each record one at a time. Could you explain what you are trying to do, and when? I'm not sure what to suggest until I know for sure if this is a single record or multi-record process.

Did you take my Integration class? If so, look at the sample code on page 15 of the coursebook.

How often do you need to do this?
What do you do with the resulting text file?

Try something like this.

var vFile as Int
var vFileName as String
var vData as String

	vFilename = "c:\sesame\dumpit.txt"
	If FileExists(vFilename)
	{
		FileDelete(vFilename)
	}
	vFile = FileOpen(vFilename)
	If vFile > -1
	{
		FileSeek(vFile, 0)
		vData = @XLookupSourceListAll(@FN, "=;/=", "KEY", "KEY;First;Last")
		If Not @Error
		{
			FileWrite(vFile, vData)
		}
		FileClose(vFile)
	}

 

This sample works with the Customers database. You'll need to change the field names to match yours.