Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT Optimization BUG or Limit ?
Message
 
 
To
05/05/2003 09:39:48
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00784112
Message ID:
00784900
Views:
21
>Hi Sergey,
>
>It is true, as always the documentation puts the hands ahead.
>
>No reference is made variable and property, or ref/value parms pass mode.
>
>I can uses function(@var).
>
>What means "supposedly forbidden manipulation" ??? for one argument of the philosophy, very many, but for a developer, nothing!
>
>Any bug it can be "supposedly forbidden manipulation".
>
>They had to write :
> "on SELECT-SQL command any variable or property is supposed costant, and UDF is supposed determinist" ( see MSQL )

Hi Fabio,

It would be very good if VFP help was as good as MS SQL Server Books Online but it isn't. In many cases you've to exercise your own judgment on what is intended use of some of VFP features and what is not. IMO, UDF's should not have side efefcts, like altering variables outside of there body. It get even worse with UDF in selects because ther's no guaranty how many times UDF can be called and at what point in SQL processing.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform