>>Ok, could you please post the statement again? Does it work as expected in
>>SQL Server? Any other relevant info?
>
>lcCommand = "select * from tgccodDocArm a LEFT OUTER JOIN tgcCodArm b ON
>b.c_codigo=a.c_armazem where a.c_codigo = '" + tcID + "'"
>llOK = .oData.GetRecordSet(toRS, lcCommand)
>
>
>With Query Analyser it works.
>
>The only thing is that, i create a blank recordset with the struture from the table tgcCodDocArm, before i pass them to this select then in this recordset i want to join the tgcCodArm.
>
>João
What if you try to create blank RS with the full expected structure? Also instead of a and b try aa and bb in your select command.
If it's not broken, fix it until it is.
My Blog