Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid Subscript Reference Error
Message
From
26/02/2005 04:37:15
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6 SP3
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00990628
Message ID:
00990850
Views:
20
>>I don't say that you are incorrect fully, but the point is the EOF(), nothing other,
>>and i don't see the EOF() word into your message.
>>Of course a EOF() record is a empty/blank record,
>> but a empty/blank record can to be a not EOF() record,
>>then empty/blank is not equivalent to EOF().
>>
>>If you don't want look into my repro code, it is a your problem.
>
>Fabio,
>
>Now it's not the deleted first record anymore but EOF() vs a blank record? It's sad to watch how you're trying to get out of the corner you put yourself with your statement, "No, it do a evaluation at the current record...". My code shows that you're mistaken. Your code again proves my point but substitutes blank record with EOF(). The end result is the same. So stop playing with words, admit your mistake and get over it.

Sergey,

exist a case ( a bug ) ( with another SQL command )
where VFP evaluate the Field into the current wa ( not into the sql members aliases );
if the current record is at EOF() ( and EOF() is the point !)
it eval empty values; but effectively my answer is not clear.

Play with words ?

When you write blank/empty record, you write a different concept:
- if a developer written this:
aelect .... 1/numericField   .....
and exists a empty numericField value within the table,
then the overflow is correct and it is a developer issue,
but if VFP evaluate the expression at EOF() then it is a VFP issue.

And another case is when a table is empty,
in this case record 1 is EOF().

Words are concepts.

But is your answer clear ? Explain it the pol.fr_type = 0 origin ?
For me not,
because you always speaks about records effective within to the tables,
and in these Rich it is sure to have all values pol.fr_type # 0 within to the records
(also in the deleted records ).
Therefore the fact that VFP evaluate the first record or empty/blank records do not explain why pol.fr_type = 0, because don't exists empty/blank records in this case.

The correct and definitive answer is:
When VFP it analyzes the SELECT, 
it can evaluate EOF() records.
Game Over with 1=1 ?

Fabio
Previous
Reply
Map
View

Click here to load this message in the networking platform