Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Function call in SQL not finding the function
Message
From
12/05/2004 11:36:32
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
11/05/2004 15:25:58
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00902947
Message ID:
00903204
Views:
16
and in addition to what Sergey says, if this function can be used in other parts of your system, store it in its own .PRG, and replace the function line with an LPARAMETERS statement.

>The first line is part of a SQL statement, the second is the first line of the function in the same prg. Both are inside the same DEFINE CLASS and ENDDEFINE lines. I get an error on the SQL that the PlanCount program is not found. Not sure why it cannot be found.
>
>
>PlanCount(IDNum, PlanID, EligEmps) AS EligEmps, ;
>
>FUNCTION PlanCount(tIDNum, tPlanID, tAmount)
>
Previous
Reply
Map
View

Click here to load this message in the networking platform