Newbie having SQL select problems with array in 2.5.8

[Ruslan Zasukhin]

On 1/2/08 11:26 PM, "Walton Sumner" <wsumner at im.wustl.edu> wrote:

> Here is a snippet of code that works only when the extra line is present:
> 
> function updateTable pName,pFieldList,pArray
>     local tKey, tCursor, tCount, tSQL, tItem, tValues, i, tResult
>     if pArray[1] = "" then return "Error: empty key value in array"
>     put "SELECT * FROM" && pName && "WHERE" && item 1 of pFieldList \
>          into tSQL
> 
>    --THIS IS THE EXTRA LINE:
>     replace ":1" with "'" & pArray[1] & "'" in tSQL

I do not see

    where in tSQL was specified  :1  ?

Actually can be the same effect of spaces

   put "SELECT * FROM " && pName && " WHERE " && item 1 of pFieldList \
                    ^^^^^^^^^^^^^^^^^^^^^^^^^


-- 
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]