2. ASPRunnerPro General questions
  3. Query question
This topic is locked

Query question

 		1/28/2008 2:07:42 PM
ASPRunnerPro General questions
author

Is it possible to edit a query that selects fields from two tables? Or can such select querys only be used to display data? The help page states below, but I don't understand what that means and if it allows editing records. Thanks.
*If your query for some reason doesn't work create view/query in your database and use this query as a datasource in ASPRunner.

  1. Run MS Access and create new query. Switch to SQL view.
  2. Type your SQL query there.
  3. Save this query as qryNewQuery.
  4. Run ASPRunner and use qryNewQuery as datasource table.*
Sergey Kornilov admin 1/28/2008

In most cases it's not possible.
ASPRunnerPro is only able to edit one physical table at once.
501309 2/4/2008

Gottcha. Thanks for clearing that up, Sergey.

In most cases it's not possible.

ASPRunnerPro is only able to edit one physical table at once.