The automatic formatting that I see is mainly about adding spaces or applying capital letters to certain keywords. I have no formatter installed, nor something else for that purpose.

I also noticed a difference : when using the ODBC driver to get data into Microsoft Access, MAXLEN determines the length of a text field.

This is also true when connecting to a view. Moreover, when you use a stored procedure as one of the fields in the view, the result is limited to 50 characters in case MAXLEN is not specified.

For example, if I define a method like this :

ClassMethod SomeStringPrep(plnput1 As %String,  pInput2 As %String) As %String [ SqlProc ]

the output will be truncated to 50 characters (at the ODBC client, not in the Caché portal). Resolve this restriction by specifying MAXLEN :

ClassMethod SomeStringPrep(plnput1 As %String,  pInput2 As %String) As %String(MAXLEN=1000) [ SqlProc ]

Hello Nikita,

Thank you for the very helpfull webterminal. Yet it surprised me that I lost my "favorites" somehow. Though, I cannot reproduce it. I assume the favorites are normally stored on the server?

If I may suggest a feature : for me it would be nice to be able to search through the commands that you entered during the session. A bit like the possibilities you have when using a Linux command prompt.

Thanks again for the tool,
regards,
Marc