When I run this command it highlights the IF Seek line and gives mer an error stating:
Alias is not found
I think it is something to do with opening the modacad and paths tables.
Here is my syntax to date:
SET DEFAULT TO 'C:\Pathproblem'
select paths
go top
scan
if seek(Paths.mainkey,'modacad', 'ModaCadOrderByMainKey')
replace modacad.paths with paths.path
endif
endscan
Many Thanks
Neil Lewis
IT R&D Manager
Velmore Ltd