New to Zen

[ChrisB]

Hi - Further to our migration to Cache from Pick, I have now just started using Zen and am trying to setup a Zen Page for one of our existing files (following the MV tutorial) and when trying to View the Web Page I get this error highlighted below. Any help on what this means and how to resolve it  would be appreciated. It appears in the documentation which I am unable to follow.

Thanks Chris

 

ERROR #5540: SQLCODE: -12 Message: A term expected, beginning with either of: identifier, constant, aggregate, $$, (, :, +, -, %ALPHAUP, %EXACT, %MVR %SQLSTRING, %SQLUPPER, %STRING, %TRUNCATE, or %UPPER^ SELECT TOP ? ID , Code , DESC

SOURCE ELEMENT: %ZEN.Component.tablePane (personTable)

[oppod...@googlemail.com]

Try to Test the query in managementportal. Shouldn't be a Zen related problem.
Is there a column named desc? Have you tried "desc" ?

[htg]

DESC is an SQL reserved verb.
to use it a column name write it quoted "DESC"

[ChrisB]

Hi and thanks for the help. Changed the class property name of Desc to AccDesc and it all worked ok,

[peter cooper]

Hi Chris

 

The SQL that is driving the tablepane is incorrect somehow

Would need to see yr full code to help

 

Peter

--
You received this message because you are subscribed to the Google Groups "InterSystems: Zen Community" group.
To post to this group, send email to InterSys...@googlegroups.com
To unsubscribe from this group, send email to InterSystems-Z...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/InterSystems-ZEN?hl=en
Zen Community Terms and Conditions: http://groups.google.com/group/InterSystems-ZEN/web/community-terms-and-conditions

[ChrisB]

Hi Peter,

 

Thanks but have resolved the problem. One of the class properties I was using was named Desc but have since renamed it and all works,

 

Chris

[peter cooper]

Hee Hee

 

My naming convention has all properties beginning with a “p” (for poperty) so I would call it “pDesc” or “pTable” this way it avoids any SQL reserved word clashes

 

BTW you can always change the SQL name of a property with the “SQLNAME” property parameter

So you can say

Property DESC as %String (SQLNAME=”somthingelse”);

 

But then you have the issue that you have to remember two different names according to if you are using the object or SQL projections – I prefer my way :}