>I'm trying to write some code which will Open a Table and Perform a SQL Statement On it using Paramters passed in, so nothing is Hardcoded/set at Design Time.
>
>My problem arrises when I try to use a SELECT statement, specifying the Fields I want to Select and the fields I wish to Compare in my WHERE Clause. If I pass a variable, (containing the field Name), it doesn't work, eg.
>
>SELECT m.MyField FROM m.MyTable INTO CURSOR curSQLCursor WHERE m.MyField LIKE 'Z%'
>
Try:
SELECT (m.MyField) FROM (m.MyTable) INTO CURSOR (curSQLCursor) WHERE (m.MyField) LIKE 'Z%'
I discussed this in detail in a thread yesterday.
>In the above Statement, it treats m.MyField as a Literal, instead of substituting it for the Value held by the m.MyField Variable.
>
>Any help appreciated.