Get stored procedure results for unknown fields

I've designed a database with a lot of stored procedures. I want to show result fields for each stored procedure in my program (which is written in Delphi) when the user chooses the stored procedure from a list and I don't know specifically which stored procedure is chosen. How can we insert results of a stored procedure whose result fields are unknown?

    Requires Free Membership to View

    Login

The programming library you are using to access the database will likely give you access to the metadata or schema of the returned data. For example, if you are using ADO.NET you can access the columns collection associated with the DataReader to get info on what came back.

This was first published in September 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top