Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unusual substitution syntax
Message
From
19/01/2004 07:30:09
 
 
To
19/01/2004 07:17:59
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00867888
Message ID:
00868077
Views:
27
Agnes,

I think we agree totally.

>Tore,
>
>how to say ...
>
>Again, I was just kidding about Fabios 'BUG' threads and the use on RECNO in SELECT SQL.
>
>I have followed the thread you mentioned and Fabio's 'BUG' threads very well.
>If you are satisfied with the result of your thread, it's o.k.. I still have the feeling of to loud "BUG" in thread titels. And to much things that may be seen in a differnt way after a deeper look.
>
>There is a strong remark on help not to use RECNO(cAlias) in joined SELECT. There is also a remark about UDF's and working areas.
>Other members point out not to use it in this thread.
>Fabio insist to use it on message#868023.
>
>It is not you or me who starts bug thread every time something is not as expected.
>
>Agnes
>>Hi Agnes
>>
>>No, I don't think you words were to hard, but you sent them to the wrong guy. :-)
>>
>>>Tore,
>>>
>>>may words are to hard. I was only kidding. ::)
>>>
>>>Agnes
>>>>Hi Agnes
>>>>
>>>>To be fair to Fabio, he has not cried 'bug' in this case. I sent him a message last summer and asked him not to cry 'bug' so often, and I think he is doing much better in that respect. Most of Fabio's thread show weird behaviour in some form or another, and very often he has very good points.
>>>>
>>>>My own opinion is that one shall never, never use the word bug UNLESS it is proven without any doubt that it really is a bug. In 99% of the cases it is wrong use, wrong or misleading text in help, or misreading/misintepretation of help.
>>>>
>>>>>Fabio,
>>>>>
>>>>>
>>>>>from Helpfile SELECT SQL, section remark:
>>>>>
>>>>>Be careful when using, in join conditions, functions such as DELETED( ), EOF( ), FOUND( ), RECCOUNT( ), and RECNO( ), which support an optional alias or work area. Including an alias or work area in these functions might yield unexpected results. SELECT doesn't use your work areas; it performs the equivalent of USE ... AGAIN. Single-table queries that use these functions without an optional alias or work area will return proper results. However, multiple-table queries that use these functions — even without an optional alias or work area — might return unexpected results.
>>>>>
>>>>>
>>>>>It's up to you to use it. But please, do use the favor not to cry 'bug' if it stop working sometimens.
>>>>>
>>>>>Agnes
Previous
Reply
Map
View

Click here to load this message in the networking platform