>
>But, when I tried to use it in SPT. I got an error message saying unrecognized phrase/keyword ???
>
>SQLEXEC(nhandle, ' my sql statement ' , 'invc_cursor' )
>
>If I replace all the fields that I want with SELECT * FROM all is ok. Is there a specific way to choose the desired fields ?
>
In addition to Stephen's answer, I'd also double check to make sure you're spacing is correct when you add together the multiple segments. For example:
lcSQL1 = "SELECT * FROM"
lcSQL2 = "MyTable WHERE"
^^^ You need a space between FROM and MyTable