This may sound stupid, but in your web page front-end are you using ASP with oledb or are you using a FoxPro application object. If you are using oledb you do know to take out the semicolons. Can you post your query string from your web page code?

Tim Boccaleri


>
>SELECT D.dr_no,A.po_no,A.desc,D.rate,B.percent ;
> FROM dr_etc A ;
> JOIN po_other C ON A.po_no =C.po_no ;
> JOIN delivery D ON A.ctrl_no=D.ctrl_no ;
> JOIN payetc B ON ;
> STR(D.dr_no)+STR(A.po_no)+STR(A.job_no)+A.desc=;
> STR(B.dr_no)+STR(B.po_no)+STR(B.job_no)+B.desc;
> WHERE ALLT(C.kind)='FABRIC' AND A.job_no=101571;
>ORDER BY 1,2,3
>
>
>works perfectly under VFP IDE
>but not through SQL PassThrough using ODBC ( from a web page front end )

>Endward,

>In addition to Sergey's comments, it really shouldn't matter but you might >try specifying the LEFT or INNER join keyword. Also, it's probably too late >now but "Desc" is a terrible field name (I assume for "description"). Just >try to INDEX ON Desc DESC TAG Desc.
>Cindy Winegarden