Can the parameter entry for scripts be enhanced to cope with multiple lines. Its a bit hairy reducing

SELECT _ID, _Name, _Status, _fkOrgType, FALSE AS _Zap, _Links,

(SELECT LIST(CAST(_ID AS VARCHAR))
FROM $DB$.Contacts X1
WHERE
_Links IS NOT NULL
AND
EXISTS(SELECT _ID FROM $DB$.Career  WHERE _fkcontacts = X1._ID AND _fkCompanies IN (SELECT _ID FROM $DB$.Companies WHERE _Status = 'Erase'))
) AS _ContactList,


(SELECT LIST(_Links,'')
FROM $DB$.Contacts X2
WHERE
_Links IS NOT NULL
AND
EXISTS(SELECT _ID FROM $DB$.Career  WHERE _fkcontacts = X2._ID AND _fkCompanies IN (SELECT _ID FROM $DB$.Companies WHERE _Status = 'Erase'))
) AS _ContactDocs

FROM $DB$.Companies WHERE _Status = 'Erase'


to a single line

Roy Lambert

Roy,

<< Can the parameter entry for scripts be enhanced to cope with multiple
lines. Its a bit hairy reducing >>

I'll see what I can do, but space is somewhat limited.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>I'll see what I can do, but space is somewhat limited.

Change from TEdit to TMemo but leave as a single line high?

Roy Lambert

Roy,

<< Change from TEdit to TMemo but leave as a single line high? >>

Yeah, but that's not going to do much good for the readability.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>Yeah, but that's not going to do much good for the readability.

It's more getting it in than reading it that concerns me. I can type it up in notepad or whatever, but reducing it to a single line means I can't edit it and there's a chance I'll crop a character (even if its only a space)

Roy Lambert