function sort order

  • Thread starter Thread starter JEM
  • Start date Start date
J

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
 
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.
Click to expand...

I can't quite figure out why you'd use a user-defined function
instead of a SQL statement as the rowsource.
 
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.
 
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
 
Back
Top