[thelist] ADO cursor - best solution for count and page throughprocedure

Adriano Castro ad at netvisao.pt
Wed Mar 31 09:29:17 CST 2004


> Joshua said:
>
> It's good to question new ideas.  That being said, I assure you,
> performing the filtering on the server through the use of a stored
> procedure is the way to go.
> (...)

Although I never tried it I can't help but agree with u.


> You are right in that it won't work for you with Access.  Have you
> considered upgrading to MSDE?  It's free and has the same features as SQL
> Server 2000.

Yes, I have. But it's not my call so... I gotta work with what I've got.
Also, if we were to migrate it to MSDE I don't believe it would be just
because of this small application and, in particular, this small
procedure/code I'm trying to sort out with this discussion. It's really a
very small application and an even smaller piece of code.


More information about the thelist mailing list