>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
I think it is risky to hard-code the location (drive and directory). Perhaps later you move the data to another location - and have to change the location in hundreds of places.
Better do something like
set path to ..., k:\fas
to ensure that the data is found there. The SET PATH would be required only once, in the startup program.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)