Do you really need a stored procedure? Seems to me that a simple query using a recordset object (or a command object) should be enough. What is the kind of process you want the SP to do?
>I would like to know how to do a stored procedure which can be constructed from a VB form. For example, the user choose the fields he wants, the conditions he wants, etc.
>
>I don't know how to write a stored procedure which allow that!
>
>Do you know?
>
>Thanks!
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com