passing parameters?

Results 1 to 2 of 2

Thread: passing parameters?

  1. #1
    Join Date
    Dec 1969

    Default passing parameters?

    have access database trying to insert info into. Keep getting error: Too few parameters. Expected 2. I have two stored procedures- CheckOwnerProc which requires 2 parameters(verifies username & password)then the second, InsertPropProc, inserts 36 parameters into the CheckownerProc recordset. I have made sure number of parameters are equal in InsertPropProc. I believe I am recieving this error because I cannot call the CheckOwnerProc which requires 2 parameters through the InsertPropProc. Is this true? Is there a way to pass parameters to a procedure that is called from another procedure. Any ideas or suggestions are appreciated. Here is shorten version of code: CHECKOWNERPROC SELECT OwnerInfo.UserName, OwnerInfo.UserPassword,... FROM OwnerInfo LEFT JOIN PropRecordset ON OwnerInfo.PropertyID = PropRecordset.PropertyID WHERE OwnerInfo.UserName = [(@UserName)] AND OwnerInfo.UserPassword = [(@UserPassword)]; INSERTPROPPROC INSERT INTO CheckOwnerProc ( PropertyAddress, City, State, ... ) SELECT [@PropertyAddress], [@City], [@State], [@ZipCode], ...
    Maine Medical Marijuana Dispensaries
    Last edited by Jay; 04-16-2011 at 01:08 AM.

  2. #2
    Join Date
    Dec 1969

    Default RE: passing parameters?

    often means you've spelled a field name or two wrong. I can't tell which ones from here

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts