store procedure

[shaomwang]

I use a code behind a search form to get sql sentence like below:
strSql = "SELECT *"
strSql = strSql & "FROM [CLAIM]"
strSql = strSql & (" where " & Mid(varMyWhere, 6) & ";")

How to pass entire sql sentence as parapeter to store procedure? Or only where clause to store procedure?

 

[MHM]

Do you need to create a "stored procedure" on an MS-SQL-server? Or do you just want to pass that SQL-string to a queryDef?

Normally you use SQL to do:

set RecordSet=myDatabase.OpenRecordset(strSQL)

Does this help?