| || |
Results Set from SQL Execution
User (email@example.com) posted:
When I do a db_execute_sql where does the result set get stored, and any ideas
on how to get at it ???
Thanks for your assistance.
Re: Results Set from SQL Execution
User (firstname.lastname@example.org) posted:
Straight from the Help files.
writes the record set into a text file delimited by tabs.
db_write_records ( session_name, output_file [ , headers [ , record_limit ]
session_name The logical name of the database session.
output_file The name of the text file in which the record set is written.
headers An optional Boolean parameter that will include or exclude the
column headers from the record set written into the text file.
record_limit The maximum number of records in the record set to be written
into the text file. A value of NO_LIMIT (the default value) indicates there
is no maximum limit to the number of records in the record set.
The db_write_records writes the record set of the session_name into an
output_file delimited by tabs.
Notes: You must use a db connect statement to connect to the database before
you can use this function. You must use a db execute query statement to
execute a query before you can use this function.
QA Automation Team
910-675-9117 ext 4080