Hi Edward,

You didn't answer second part of my question: what exactly doesn't work in ODBC? Until you do, I can give you only generic advice:
- Make sure that you have the latest version of VFP ODBC driver installed: 6.01.8629.01
- Uncheck "Fetch Data In Background" option (if it's checked) in DSN because it could cause some problems with queries.
- Don't use ALLTRIM() in queries on table fields. It could produce unexpected results.

>>>can somebody point me to resources outlining the difference on SQL capability between native VFP and VFP ODBC ?
>>>i have problems sending SQL statements that work in VFP.exe but not in ODBC
>>
>>VFP ODBC driver was last time updated in VFP6 so it should be compatible with VFP6. Can you post your select statement and tell what exactly doesn't work in ODBC?
>
>hello sergey, appreciate your response
>here it is, a garment business transaction that keep track of status on tables PO, DR & Payment
>

>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 )
>
>i've been doing this quite a lot and successful but this particular MULTIPLE JOIN seems not to be working