Newbie having SQL select problems with array in 2.5.8 - resolved

[Ruslan Zasukhin]

On 2/2/08 5:59 PM, "Sumner, Walt" <WSUMNER at im.wustl.edu> wrote:

Hi Sumner,

> The spaces are OK here because the double ampersands insert a space between
> the concatenated strings:
> put "SELECT * FROM" && pName && "WHERE" && item 1 of pFieldList \
>                       ^^^^^^^^^^^^^^^^^^
> 
> However, there was no space before the colon (":1") in this statement:
> 
>> Without the extra line, tSQL looks something like this:
>> 
>> SELECT * FROM ICD_Term WHERE Code=:1
> 
> ("Code=:1" came from pFieldList)
> 
> Adding a space between "=" and ":" resolves the problem.

Strange. I do not see why this should take difference.

We need check this ...


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]