Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter
Message
From
08/05/2007 14:00:36
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Title:
CursorAdapter
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01223509
Message ID:
01223509
Views:
65
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
Next
Reply
Map
View

Click here to load this message in the networking platform