CODEWITHSUNDEEP
intersystems-cache
AaronS
AaronS

Reputation: 435

Can't update specific columns? Only large string columns?

I'm trying to run some simple update statements on Cache 2008. Loging into the web portal. I'm able to run queries like:

update testspace.clients 
set requires_attention = 'Yes'
, notes = 'testsdfsd'
where id = '1||CPL62549.001'

The web portal runs and looks like it updated things but when I do a select statement requires_attention is updated but notes isn't.

Both fields are of type string. The only difference is notes is MAXLEN = 32700.

I've tested this on other columns in other tables. Any string column with MAXLEN = 32700 wont let me update it. Seems odd. Perhaps this is a coincidence and something else is going on. Seems strange that I can update some fields of a record but not others.

any ideas?

I'm new to cache but have experience with SQL Server, Oracle, MySQL, etc.

Upvotes: 0

Views: 155

Answers (1)

Brandon Horst
Brandon Horst

Reputation: 2070

Strings in Cache are limited to 32000 characters. Setting the MAXLEN to a number greater than that is going to cause problems.

Set the MAXLEN to 32000 and it should be fine.

Upvotes: 1

Related Questions