<No Subject Supplied>

>I am exploring using SPL to store functions that preform specific tasks and >return a result. These fuctions i currently store in a library. I am >hoping that by making them SPL code that I can save the time a 4GL uses to >verify the SQL's involved in the task. What i am having trouble doing is >getting the SQL procedure to execute and return a value. >sample code block that i am currently trying: >main >define v float >define s char(40) >let s = "execute procedure p() into v" >prepare e_SPL from s >execute e_SPL >display v >end main >help! >thanks I think you will find that the only way this works (at least with 4.12 or earlier) is as follows: define v flaot prepare e_SPL from "execute procedure p()" declare e_SPLcur CURSOR FOR e_SPL foreach e_SPLcur into v ..... end foreach Mark Denham BBC London, UK Mark.Denham@bbc.co.uk