>Dear Sir,
>
>I have a table entitled "errors" contained following fields
>
>Date, time,errno,message,lineno
>
>I want to show only last record in text file, c:\error.txt,
>but the data of every field must show in new line for example
>
>31/12/2004
>10:00:00
>1200
>field not found
>3
>
>What should I do?
>Please help
>
>Thanks in advance

select 0
use errors
go bottom
local lnHandle,ix
lnHandle = fcreate("c:\error.txt")
for ix=1 to fcount()
  =Fputs(m.lnHandle,transform(eval(field(m.ix))))
endfor
=fclose(m.lnHandle)
use

Cetin