function sort order

[JEM]

I am using Access 2003 ADP with SQL Server 2005. Just upgraded from
SQL 2K. I have a combo box on the form where the row source is a user
defined function. Now that I'm working with 2005, the ORDER BY does
not work. What is the quickest/best way to fix this? Is it best to
change this to a stored procedure? Thanks for any advice.

Jenn

 

[David W. Fenton]

I am using Access 2003 ADP with SQL Server 2005. Just upgraded
from SQL 2K. I have a combo box on the form where the row source
is a user defined function. Now that I'm working with 2005, the
ORDER BY does not work. What is the quickest/best way to fix
this? Is it best to change this to a stored procedure? Thanks for
any advice.

I can't quite figure out why you'd use a user-defined function
instead of a SQL statement as the rowsource.

 

[JEM]

I inherited the database from another consultant. The records that
appear in the combo box need to be filtered based on the form's
record. He used a function to accomplish this.

 

[a a r o n . k e m p f]

David;

SQL UDFs are extremely powerful.

If you don't know what they do, then why don't you STFU and go and
play with your baby-sized databases?

Thanks

-Aaron