Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Severe situation on bug
Message
From
30/07/2001 13:20:32
 
 
To
30/07/2001 13:14:40
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00537068
Message ID:
00537309
Views:
26
>>
>>The behavior of the count as to know wether or not if will fire an error is unpredictable. This is what I came up with.
>>
>>Also, when it goes into the error handler, it will proceed on the code as is and will ignore the RETURN TO clause.
>>
>
>Michel,
>
>I have found that the error will not fire if the currently selected table does not have any records. IOW, VFP is going from left to right, and never looks at the FOR statement because it knows it is going to return zero records.
>
>Is your CONTACT table populated with records?

You're right. I just added a record in a test table and I got the error. Yes, Contact does contain some records. So, this is why we got the error.

But, on some occasions, we might issue a COUNT on an empty table. So, we need to find a way to force the error to kick in every time.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform