SQLite Issue

[Dave Cragg]

On 27 Dec 2005, at 04:52, Scott Kane wrote:
> I'm getting the result "It"
> rather than the value of the field (in the example
> below the field is called "edName").
>
>   --> COLLECT name AND email
>   put "name,email" into tColumnItems
>   repeat for each item I in tColumnItems
>     --ask question "New value for column: " & I
>     put Field "edName" into i
>     --if it is empty or the result is "cancel" then exit to top
>     put "'" & cleanSQL(it) & "'" & "," after tRowData
>   end repeat

Is the "item variable" a lowercase "L" or an uppercase "i"?

Anyway, you should try one of the follwing:

   put "'" & cleanSQL(i) & "'" & "," after tRowData

or

   put field "edName" into it

or

   get field "edName"

Cheers
Dave