ODBC expression is too complex message???

[Wingamez]

I am getting this error in the expression editor while trying to enter this SQl command:
"SELECT DISTINCT dbo_issue.id AS id, dbo_issue.name AS issue, dbo_priority.name AS priority, dbo_severity.name AS severity FROM dbo_issue, dbo_priority, dbo_severity WHERE dbo_issue.priorityid = dbo_priority.id AND dbo_issue.severityid = dbo_severity.id AND dbo_project.name = '"+Edit text$( "Combo Box" )+"'"
I don't see it as "too complex"....should I?

[Jeff]

I think we would need Francois to comment on this problem.
Most likely due to a limit in the expression editor on the number of characters.

I wonder if he can bump it up?

[Francois]

String in the expressions are limited to 255 characters. By splitting the string in two, it works.
Note: strings in memory are not limited!

[Wingamez]

How do I split the string? thanks

[Anders]

"hello there this is a really long string"

"hello there this is " + "a really long string"

<img src="/center/images/graemlins/smile.gif" alt="" />

[DJFuego]

But if you have a string in the expression editor that is longer than the expression editor can handle what then?

[Anders]

I don't know the limits of what it can handle, but you could probably do something like this:

set string object to: "Some strings "
set string object to: Alterable String("String") + "are so long "
set string object to: Alterable String("String") + "that they need to "
set string object to: Alterable String("String") + "be split up."

Send the string to the ODBC object.

[DJFuego]

Good answer.