>Here is what I am trying to do- I have a foxpro app asking for some records from SQL. A stored procedure will fire and run the query and return the number or records found. An input parameter will tell the stored procedure how many records to return to FOXPRO in XML format. I need to know the number of records orginally returned by the query so I can inform the use they did not receive all the records requested and to add addtional information to the query to lessen the number of records returned. How to I add and retrieve in foxpro addtional info in the XML file...? Thanks in advance to all.

Why complicate things if you can add output parameter to a store procedure and return # of records in it.