Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cartesian join produces 0 records
Message
From
31/01/2006 19:01:00
Alan Harris-Reid
Baseline Data Services
Devon, United Kingdom
 
 
To
31/01/2006 02:27:50
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01091514
Message ID:
01092131
Views:
17
Hello Fabio,

>>
>>SELECT * FROM Cursor1
>>
>>SELECT * FROM Cursor2
>>
Sorry, I made a mistake in my last reply to you. SELECT * FROM Cursor2 resulted in 0 records, even though Cursor2 contained one record. However, the original record was totally empty (had just been APPENDed), and this is probably the cause of the problem. As soon as I filled one field with 'real' data the SELECT resulted in one record.

I will have to remember this problem for future use. (BTW in answer to your last qn., I am using VFP8 SP1)

Regards,
Alan
Previous
Reply
Map
View

Click here to load this message in the networking platform