Hi Mark..
Thanks for the reply...
What i really want to do is
1) Make the server process the sql
2) ***1*** is how it is right now (but this does local processing)
3) ***2*** is what "i suppose" i have to use to get the server to do the processing.
4) The problem is : I only got so far with the statement and when i compile it...i get an error "Unrecognised phrase/keyword"
Thanks
Fida
***1***
>SELECT Assets.asnum, Assets.sub, Assets.aexistnum, Assets.asdes,;
> Assets.asser, Assets.aloc, Assets.adep, Assets.price, Assets.invoice,;
> Assets.acost, Assets.Trans_sold, Locate.locphone, Locate.person, Locate.exist, Udep.desc1;
> FROM baud!locate ;
> INNER JOIN baud!assets;
> ON Locate.locnum = Assets.aloc;
> INNER JOIN baud!udep ;
> ON Udep.dep = Assets.adep ;
> WHERE Assets.adep = madep;
> AND Assets.astyp = mastyp;
> AND Assets.aloc = mloc;
> AND (Assets.trans_sold = " " .or. Assets.trans_sold = "I") ;
> ORDER BY Assets.adep, Assets.aloc, Assets.asnum;
> INTO TABLE temp.dbf
>>
>>the above code works fine.
>>
>>i have tried to use the sqlprepare() command but with no success..this is as far as i got :
>>
***2***
>>=sqlprepare(gnConnHandle,'select Assets.asnum, Assets.sub, Assets.aexistnum, Assets.asdes, Assets.asser, Assets.aloc, Assets.adep, Assets.price, Assets.invoice, Assets.acost, Assets.Trans_sold, Locate.locphone, Locate.person, Locate.exist, Udep.desc1 from assets,locate,udep WHERE assets.adep = madep ' ,'temp.dbf')
>>
>>Can anyone please help with this?
>
>
Did you intend to use SQLPrepare() with a SQL statement that is different from the one above it?
Wannabe FoxPert!!!