D. Richard Hipp wrote:
> On Jun 12, 2008, at 11:08 PM, Jeff Godfrey wrote:
>
>> dbMem eval {select distinct(owner) from lockinfo order by owner} {
>> <do something with $owner>
>> }
>>
>> That works correctly in my original app using 3.4.2, but complains
>> that
>> there is no such variable "owner" when using 3.5.9.
>>
>
> Solution 1:
>
> dbMem eval {SELECT DISTINCT owner FROM lockinfo ORDER BY owner} {
> puts $owner
> }
>
> Solution 2:
>
> dbMem eval {SELECT DISTINCT(owner) AS owner FROM lockinfo ORDER BY
> owner} {
> puts $owner
> }
>
> Solution 3:
>
> dbMem eval {SELECT DISTINCT(owner) FROM lockinfo ORDER BY owner} {
> puts ${(owner)}
> }
>
Thanks for the quick solution. I've adjusted my code accordingly. So,
do you consider this a buglet or more just the closing of a gap that
shouldn't have existed in the first place? It's interesting that the
original code works outside of a proc in 3.5.9, but not inside...
Again - thanks.
Jeff
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
