function sort order


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
 
Ad

Advertisements

D

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.
 
J

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.
 
Ad

Advertisements

A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top