| || |
Where is the record set?
where WR load the record set created after execute a SQL statement?, We can't access it.
We don't now where is the record set of the result.
Re: Where is the record set?
WR works in a slightly different way to other scripting langauges, like VBscript. However I think the following will help you
# Open the database
# Define the query
query = "select * from [Account Transactions]
# Execute the query
db_execute_query(ACCESS_SESSION, query ,record_count);
# This line sets the data, and is in effect # the recordset
# The first Parameter here is the db
# session, the second is the row and the
# third is the column name
EffIntDate = db_get_field_value(ACCESS_SESSION, "#0", "EffIntDate");
# Disconnect from the database