Hi Sergey...
Thanks for the prompt reply...
Your suggestion works 100%
Thanks
Fida
>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?
Wannabe FoxPert!!!