Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
function sort order
2 views
Skip to first unread message
JEM
Jun 21, 2010, 5:46:55 PM6/21/10
to
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.
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
Jun 21, 2010, 9:12:24 PM6/21/10
to
JEM <Je...@JEMConsulting.org> wrote in
news:e04ab9d6-5516-481b...@3g2000vbg.googlegroups.com:
news:e04ab9d6-5516-481b...@3g2000vbg.googlegroups.com:
I can't quite figure out why you'd use a user-defined function
instead of a SQL statement as the rowsource.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
JEM
Jun 21, 2010, 11:07:34 PM6/21/10
to
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.
appear in the combo box need to be filtered based on the form's
record. He used a function to accomplish this.
On Jun 21, 9:12 pm, "David W. Fenton" <XXXuse...@dfenton.com.invalid>
wrote:
a a r o n . k e m p f @ g m a i l . c o m
Jul 6, 2010, 2:16:43 PM7/6/10
to
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
On Jun 21, 6:12 pm, "David W. Fenton" <XXXuse...@dfenton.com.invalid>
wrote:
0 new messages