Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
External procedure doesn't work?
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01121048
Message ID:
01121099
Views:
7
The problem is resolved after I updated the structure of the local database on that PC.

>Hi everybody,
>
>In my class I reference two functions which are now in Stored Procedure.
>I've added External Procedure command and I compiled my project locally without getting compilation errors. However, when we do it from the different PC and build this project to network drive under different name, we're still getting UNKNOWN functions errors.
>
>Here is my code in the method:
>
>external procedure GetEmployeesQueuesInfo
>do case
>case m.tcField = 'cuserid'
>	=GetAllUserLinks('c_AllUsersWithLinks')
>	=GetEmployeesQueuesInfo(this.dEnteredDate, 'c_Count1')
>
>	select cUserId, sum(iAccounts_count) as iAccounts_count, ;
>		sum(yBalance) as yBalance ;
>		from c_Count1 ;
>		INNER join c_AllUsersWithLinks ;
>		on c_Count1.cUsGrLink_pk = c_AllUsersWithLinks.cUsGrLink_pk ;
>		into cursor c_count readwrite ;
>		group by 1
>	index on cUserId tag cUserId
>	use in c_Count1 && not used anymore
>
>case m.tcField = "cusgrlink_pk"
>	=GetEmployeesQueuesInfo(this.dEnteredDate, 'c_Count')
>endcase
>
>Do you know, what could be wrong?
>
>Thanks in advance.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform