I'm writing a VBScript program to read a text file and pass the text record to the database to update tables. A stored procedure will parse the text and update the tables. After the text record is processed, the stored procedure (or function) will return a value to the VBScript program. Based on the return value, I'll know if the input record needs to be corrected and resubmitted. This is a batch job. I'd like to pass two parameters to the database. The first would contain the text record. The second would be used for a return value from the stored procedure or function. I don't need to get a recordset back. I just need a message telling me if errors were found or if the job was completed successfully.
I've tried sending two parameters, one as input with the text needed for the select statement, and the other as output (which didn't work) and return value (which didn't work either).
Here are my questions:
What is the correct way for setting up and using these parameters? What are the values of the parameter attributes that I need to send for each parameter?
Is it possible to get back a parameter (return value) that is not in the form of a recordset?
Is there a way of sending the command to execute a function instead of a stored procedure? There doesn't appear to be a CommandType for a function. Can I use adCmdStoredProc for a function?
Must the recordset be associated with a table? Can it be associated with a view?

Is this a SQL Server database? I'm basing my response from a SQL Server database perspective. You can return a parameter. SQL Server has a keyword "OUTPUT". For the parameter, you can specify that the parameter direction be output instead of input (default). If you need to return an integer value, SQL Server has this by default (@RETURN_VALUE), which you return a value by "return <number>" in the stored procedure. If a stored procedure, the command type must be adCmdStoredProc (4).

You can associate a recordset with a view; the recordset doesn't care what the source is as long as it returns record data, which a view does.

Hope this helps,

Brian Mains

Brian,
Thanks for your help.
Everything is working like a charm!
Barbara Heidecker