>I have tried:
>
>getDrawingDataString = "Select * From drawmstrp Left Outer Join drawmext1 On drawmstrp.dm_drawing_number = drawmext1.dmdrawno Left Outer Join drawmext3 On drawmstrp.dm_drawing_number = drawmext3.dmdrawno
>
>(to Add) And drawmstrp.dm_pending_change = drawmext3.prevchng
>
> Where drawmstrp.dmdrawno = '" + PadR(whatDrawingNumber,12) + "'"
>
>But I get an error 'Command contains unrecognized phrase/keyword.'
I think you hit 255 characters literal string limit. Divide it if you'd do with a single string. For SQL2000 there are easier ways to construct an SQL. ie:
text to m.getDrawingDataString textmerge noshow
Select * From drawmstrp
Left Outer Join drawmext1 On drawmstrp.dm_drawing_number = drawmext1.dmdrawno
Left Outer Join drawmext3 On drawmstrp.dm_drawing_number = drawmext3.dmdrawno
And drawmstrp.dm_pending_change = drawmext3.prevchng
Where drawmstrp.dmdrawno = '<<PadR(whatDrawingNumber,12)>>'
endtext
Cetin