V obshem probleam sv sledueshem
kaim brzom mozhno programnim putem sdelatj parametrizirovannij zapros k
Access 2000


Dim rsPosition As ADODB.Recordset
Set rsPosition = New ADODB.Recordset
Dim strSQL As String
Dim prm As ADODB.Parameter
Dim cmdPosition As ADODB.Command
Set cmdPosition = New ADODB.Command
rsPosition.LockType = adLockOptimistic
rsPosition.CursorType = adOpenDynamic
rsPosition.CursorLocation = adUseServer
cmdPosition.ActiveConnection = Module1.conAis
cmdPosition.CommandType = adCmdText
Set prm = cmdPosition.CreateParameter("pos_descr", adChar, adParamInput, 50)
cmdPosition.Parameters.Append prm
prm.Value = DataCombo1.Text
strSQL = "select base_salary from position where position_description=pos_descr"
cmdPosition.CommandText = strSQL
Set rsPosition = cmdPosition.Execute


v rezultate oshibka Too few parametrs expected one ?

V cehm mozhet bitj delo ?