Re: how do I keep the query result when I switch to design view?

zwasdl@xxxxxxxxx wrote:
It does make sense, I wanna switch between design/sql and data view so
I can revise a query based on the previous data. and I only want the
updated resultset when I need to.

pietlinden@xxxxxxxxxxx wrote:
What you're asking doesn't make sense. A query is a *definition* of a
resultset, and *not* the results themselves. If you want to save the
information somewhere,you'll have to write them to a table or
something. In short, no. once you close the query or return to design
view, the dataset is no longer available.


Makes sense to me as well, and perhaps you know as I do that some environments save query results in new and separate windows from the SQL, allowing you to toggle back and forth. Alas, Access does not work this way.

--
Smartin
.

Relevant Pages

  • Re: data type error in my query
    ... the resultset returned the same value for comments. ... FROM dbo.tblWeblog as W1 LEFT OUTER JOIN dbo.tblUserComments as C ... > If blogID is a unique identifier for rows of tblWeblog, ... If I strip out W.blogComment the query runs fine. ...
    (microsoft.public.sqlserver.programming)
  • Re: When do selects execute for multiple resultsets
    ... SQL Server executes each query and stops when its ... When the first resultset is ... The CommandTimeout is measured from the time you execute the query until the ...
    (microsoft.public.dotnet.framework.adonet)
  • refreshing a window
    ... the query is processed, the results do not come up at the bottom until ... private JTextField output, input, input1, input2, input3; ... ResultSet resultSet; ...
    (comp.lang.java.programmer)
  • Re: Cant get JDBC to work from Java to MySQL
    ... ResultSet rs = stat.executeQuery("SELECT draw_date FROM ... but process int 'ball_1' ... (Java, Stack trace, and table description - stack trace from the code ... SQL Exception:Unexpected exception encountered during query. ...
    (comp.lang.java.programmer)
  • Re: Cant get JDBC to work from Java to MySQL
    ... ResultSet rs = stat.executeQuery("SELECT draw_date FROM ... (Java, Stack trace, and table description - stack trace from the code ... compiles and prints! ... SQL Exception:Unexpected exception encountered during query. ...
    (comp.lang.java.programmer)