By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,948 Members | 1,975 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,948 IT Pros & Developers. It's quick & easy.

Stored Procedure Return Column Names

P: n/a
Hi
Just adding some sprocs to a large access 2002 project to enhance
speed and stability. Using SQL server 2000 and Access 2002
I have some recordset based sprocs that will return multiple rows, is
there any way of getting the column names back from the sproc into
Access without defining each in the sproc as a field and then doing a

SELECT @a = A,
@b = b,
etc

Otherwise it comes back as an array and the columns are meaningless in
the code (rsttemp(0), rsttemp(1), etc

Probably just trying to save myself some typing but best to check :)

Cheers all
Shaun
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.