2. ASPRunnerPro General questions
  3. access sql into ASPRunner...
This topic is locked

access sql into ASPRunner...

 		12/5/2004 10:49:38 PM
ASPRunnerPro General questions
author

Can someone PLEASE translate this from MS Access into ASPRunner?
SELECT *

FROM Master2

WHERE (((Master2.Status)="Agriculture and Natural Resources Finance"));
Had I know WHERE queries were "not directly supported" I would not have slapped down $250 for this program!!!
501115 12/6/2004

Hi
Make a query in Access and use that as the data source, rather than using Access tables directly.
Sergey Kornilov admin 12/7/2004

Just create a query in MS Access on the top of this SQL statement and use this query as a datasource in ASPRunner.
501116 12/16/2004

Just create a query in MS Access on the top of this SQL statement and use this query as a datasource in ASPRunner.



Sergei,

if you use a access query, then is not possible to update the original table? It is any solution to see only part of the database and search with asprunner the partial database records + edit
D
 		dpkona 12/17/2004

Smacky:

That is why you had 30 days to try the software. With a little work on your part this software program will let you do just about anything.
Stop whining.
Sergey Kornilov admin 12/17/2004

Ran,
some queries are updatable like WHERE queries that pull data from the single table. Aggregate, union and join queries in most cases are not updatable.