need some advice...

[Playmaker]

I am writing a program in VB6 with SQL7 as database. I'm using ADODC. What I want to know is: What is the easiest or most practical way to filter data from a database. My program involves different clients and claim numbers and the end user needs to see data just for a particular client or claim number at any given time. For example, after they log in they choose which client they want to use and from that point on in the program, only that client's data should be viewable. Can anyone help?

Eddie

[danix]

The easiest way both syntactically and connection-wise is to use sql statements, although they can be slow when dealing with mass data.

------------------

[Bigley]

Set up stored procedures that expect a parameter such as 'client number' and then return data relative to that client, this keeps the work load on the server side.