How to save one line of code (select command)?

Hi

Does any concise-conscious programmer (spss) know how to shorten that code preferably including the execute statement in the select command.

Thanks.

Toby



select if(hospid < 200 & hospid ~= 49 & hospid ~= 109).
execute.
.

Relevant Pages

  • Re: Update Query Confirmation
    ... I am assuming that it is because the SQL statement is ... not sure how to refer to it in the execute statement. ... > Precede your DoCmd.RunSQL command with this code step to turn them ... >> Because it is an update query it asks for confirmation every time it ...
    (microsoft.public.access.queries)
  • Re: where does 129 mean in conn.execute sql, , 129
    ... and saw almost all execute statement have options 129 ... The third parameter of the ConnectionExecute method is the options ... 128 = adExecuteNoRecords which indicates that the command does not return ...
    (microsoft.public.inetserver.asp.db)
  • Re: Command Vs Connection Object
    ... CommandType arguments in the connection's Execute statement. ... are passed to the implicit Command object. ... >> method to execute the statement, in which case an implicit Command ...
    (microsoft.public.inetserver.asp.db)