Execute SQL Statement now has Character Limit.

Posted By Tebasaki over 10 years ago

I have a nice long statement that creates an appointment when a field is no longer null; and it was a healthy piece of code in 6.2. We've recently upgraded to 7.2b and now it seems that I'm limited to 255 characters. How do I increase the SQL statement box character limit so I can put a decent piece of code in there?

0 Toby.Prince over 10 years ago

If you are not using internet explorer for admin features, use internet explorer for admin features.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tebasaki over 10 years ago

Yeah, it's IE10
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Toby.Prince over 10 years ago

Make sure it is in compatibility view, I just tested this on my IE 10, and it works as expected.

community.sagecrm.com/.../download.aspx
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Toby.Prince over 10 years ago

You cannot login?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tebasaki over 10 years ago

It worked! It wouldn't let me add the URL individually so I just checked the box to allow all sites in compatibility mode and it worked!

Thank you, kind sir.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tebasaki over 10 years ago

The only downside is that I can't login if I have compatibility mode on. So I pretty much have to be at the screen I need to change, and then switch to compatibility view and hope it doesn't log me out.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tebasaki over 10 years ago

It acts up intermittently, but I can easily turn on and off compatibility to get where I need. No worries.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage CRM

Execute SQL Statement now has Character Limit.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING