>As per your suggestion, I generate a SQL-command as follows:
>
>

>	SELECT SoMain.*, SosUb.ICode, SosUb.qntymaj, SosUb.qntymin,;
>	       SosUb.RateMaj, SosUb.RateMin,;
>	       PCode.full_Name, pcode.address, pcode.tel1, pcode.tel2, pcode.tel3, ;
>	       Icode.full_desc, icode.unit ;
>	  FROM SoMain;
>	  RIGHT JOIN SosUb ON SoMain.SoNo == SosUb.SoNo;
>	  LEFT JOIN PCode ON SoMain.PCode == PCode.PCode;
>	  LEFT JOIN Icode ON SosUb.Icode  == Icode.Icode;
>	  WHERE BETWEEN(SoMain.date, dt1, dt2) INTO CURSOR cSomain
>

>
>In Network environment, the actual data is lying in (K:\FAS) directory and I want to fetch data from there. But I am facing a problem to put the drive letter. Kindly let me know where to put the drive letter in the above SQL command.
>
>Thanks - Saif

How in your application you access your data? I would just set path to your DATA directory and make sure that PATH to local DATA directory is not set. In this case you would pick your data.

You can also do it like this:

lcPath = set('path')
set path to K:\myData  && remove path settings and only use path to data directory
select ...

set path to &lcPath && restore original path