Hi Fida,

The SQL string you passed to sqlprepare is to long.
Try to split it on parts:

=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')


>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?