I don't remember all of them. I confess that I was suffering a bit from information overload. One was that the functions may be referenced from SQL Server commands while procedures may not. That one definitely makes sense to me. I can ask him to give me some more detail, if you like. He is someone whose opinion I respect quite a bit, which is why I wanted to raise the issue.
>>BLG is the Mere Mortals Business Layer Generator. Referencing stored procedures is one of the enhancements in version 2.4.
>>
>>>>I have been working with someone who is a more experienced SQL programmer than I. He suggested that I use functions rather than procedures for single table returns. When I use functions rather than procedures the code compiles without any problem. However, I notice that the BLG does not list the functions. Will using functions cause problems down the line? Thanks.
>>>
>>>What is BLG and this is an interesting statement, I'd like more information about it.
>
>
>I think that the advice to use funcitons over stored procs is a bit off the mark. Could you post the reasons why that statement is made?
Linda Harmes
HiBit Technologies, Inc.