The problem is the LEFT OUTER JOIN, I think. Just use LEFT JOIN or otherwise play around with that. I had this problem awhile back and it was just the use of the word OUTER that messed it up, if I remember correctly.
>Hi All -- I tried creating a CursorAdapter class with a SQL statement similar to:
>
>SELECT t1.*, t2.* FROM t1 LEFT OUTER JOIN t2 on t2.t1_fk = t1.pk
>
>When I run the CursorFill() method on an instance of the class, I get nothing. When I change the SQL to:
>
>SELECT t1.*, t2.* FROM t1, t2 WHERE t2.t1_fk = t1.pk
>
>From this SQL statement I get results. SET ENGINEBEHAVIOR is 90 (tried in 70, 80 and 90), so I am fairly sure it is not that. However, I am at a loss and wondering if any of you might know what's wrong.
>
>Thanks in advance,
>Larry Rix