Hi All,

I'm rewriting some inherited code which has a lot of queries and within these queries many fields selection (sometimes more than 100 fields). So the code is very unreadable. I want to store the fields in a table memo field (velden) and rewrite the queries with macro substition, for example

locate for tabel.kind = "mutbdrg"
cQuery = cQuery = "select " + alltrim(Velden) + "from mutbdrg_verloop" 
&cQuery

But I get an error which I don't understand (command contains unrecognized phrase/keyword). For testing I have stored one field in the memo :"estkst;". When I assign cQuery to _cliptext and paste the result in the command window, it works but with a macro it fails. Am I doing something wrong?

_cliptext gives the following:

select estkst;
from mutbdrg_verloop 

Thanks beforehand