EAP -> notes truncated value from API SQL Query (255 chars)

[Guillaume]

Hi,

In a VbScript, I set a local variable with the content from t_objectproperties.notes which I get by calling Repository.SQLQuery(SQL).
The script works well with a DBMS but not with an EAP: I figured out that the returned value is truncated after 255 chars.

Is this a known issue with EAP? Is there a workaround?

thanks

[qwerty]

Tagged Values have always been limited to 255 bytes. I guess you once changed your real database to have the limit removed (on your own risk). Now, that's what you get...

q.

[Geert Bellekens]

Yes, a known issue.

There is actually a difference between the SQL server database format and the .eap database format.

I once reported it as a bug, but I got the "it's a feature, not a bug" response 

Geert

[Guillaume]

Thanks for your replies. The tagged values store the definition of DB Views generated by EA via a DB Reserve.
So the full query is generated without any restriction on the number of chars.

It works ok if I use the API Object method as an alternative to queries (will use that..).