How do you run an event procedure on the server?

[Betacon]

I have a large table on an SQL Server 2000. I have an update form on the Client populated with data from that table. I have an involved Find event procedure (activated with a button on the form) which is to repopulate the form with the data of the matching record. When I use a link to the server table, the Find routine is very slow. While I know how to run queries on the server (and even pass-through queries), this Find procedure does not lend itself well to translation into a query. What is the best way to have the actual searching done on the server so as to speed up the process

Thanks.

 

[CSmith]

Hi,

Just wondering if you have your index (or indices) included in your
pass-through SQL call along with a good / fast filtering tool like the In
clause (not the Where clause)?

--
Calvin Smith
http://www.CalvinSmithSoftware.com - Automation Code
http://www.SpanglesNY.com - Fendi, Prada, Von Dutch, etc - 60% off

I have a large table on an SQL Server 2000. I have an update form on the

Client populated with data from that table. I have an involved Find event
procedure (activated with a button on the form) which is to repopulate the
form with the data of the matching record. When I use a link to the server
table, the Find routine is very slow. While I know how to run queries on the
server (and even pass-through queries), this Find procedure does not lend
itself well to translation into a query. What is the best way to have the
actual searching done on the server so as to speed up the process?