>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
What that code gives to you (with first SELECT command):
IF NOT YoutCA.CursorFill()
AERROR(laError)
MessageBox(laError[1,2])
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.