SQLite Issue

Dave Cragg dcragg at lacscentre.co.uk
Tue Dec 27 03:54:17 EST 2005


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



More information about the use-livecode mailing list