Strings Limitation on Expression Editor

[byo]

Hi, all.

I'm a new user of MMF2. I've been a MMF 1.2 user a long time ago and I was a member of the old forum. I'm using the demo version B247 until my MMF2 arrives and I'd like to make my first request to the Clickteam team of developers:

Please make the expression editor accept more characters at once. I can't assign a global string with the values I want and I can't use ODBC properly because it requires long expressions (I've tested in other programming languages and ODBC should accept something like this at once:

"if not exists(select name from sysobjects where name = 'task' and type = 'U') create table task (taskCode int, taskShortDescription varchar(255), taskClient int, taskStartDate smalldatetime, taskEstimDate smalldatetime, taskPriority smallint, taskDetails varchar(255), taskEndDate smalldatetime"

If there's a workaround, please let me know. It's nice to be here in this community once again.

HAPPY NEW YEAR TO YOU ALL!!!!!! :grin:

[xyzzy]

you can just break the string up into something like:

"if not exists(select name from sysobjects where name = 'task' and type = 'U') create table task (taskCode int, taskShortDescription varchar(255), taskClient int," + " taskStartDate smalldatetime, taskEstimDate smalldatetime, taskPriority smallint, taskDetails varchar(255), taskEndDate smalldatetime"

[byo]

Thank you. That worked like a charm.
*gives beer*
Cheers!