Hi Gerard,
I imagine that the server will have a table of workstations to be polled and that each workstation will have a shared folder by which the files can be accessed? If this is the case you could store the path to the file for each station in the table.
The pseudocode would then be
Select ListOfStations
Scan All
if file(ListOfStations.PathAndFile)
Do AppendStuff
endif
EndScan
Regards,
Liam
>Hi.
>Is there a way of Polling files on individual Workstations (connected in a LAN) to be polled from a server.
>
>At the end of each day, I need to Poll all the workstations caonnected (acting as Point of Sale Units) and append data into a Master table
>
>I know I can do thsi from each workstation, but I need more control so it would be preferable if it can be done from the server. The idea is that there would be a log of all alid connected workstations and code would be as follows:
>
>
>Use Master
>For i=1 to NumbeOfConnectedWorkstations
> Select Master
> Appe from WorkstatioonSlaveFile
> Delete all records from WorkstationSlaveFile
>EndFor
>
>Regards,
>
>Gerard
Liam O'Hagan
MCP VFP Desktop Apps