Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Balance amt using SQL from Parent-Child and GrandMaster
Message
 
To
07/12/2004 06:51:38
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
Miscellaneous
Thread ID:
00966900
Message ID:
00967457
Views:
19
Hi

>It is not heavy, you only need stored procedure with input and output parameters
>
>Something very simple
>
>CREATE PROCEDURE TEST_PROC (
>    IN_1 DOUBLE PRECISION,
>    IN_2 DOUBLE PRECISION)
>RETURNS (
>    OUT_1 DOUBLE PRECISION)
>AS
>begin
>    out_1 = case
>               when ( in_1 > in_2 ) then in_1 - in_2
>               when ( in_1 is null or in_2 is null) then 0
>               else 0 end ;
>  /* Procedure Text */
>  suspend;
>end
>
That is it and I use it as SELECT TestProc(t.Var1, t.Var2) AS MyFldName,....?

Thanks a lot for the precise code.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform