> I'm able to execute an INSERT INTO or DELETE
> FROM query from a script, but not a simple SELECT
> query. The SELECT query runs OK in the interface.
> Is there something different about scripting a
> non-action query?
Could you show your code?
Running a query that returns a table, such as a SELECT query is indeed different from running a query that performs some action and does not return anything, such as an INSERT or DELETE query, in that you have to process the resulting records. You can access the resulting records returned by a query via the Table property of the relevant Query object.
If the query you are trying to run selects drawing objects, are you expecting the call to Query.Run to select the objects as well? The automatic selection of objects returned by queries is a purely UI thing that is done after the query has run by the table window. To achieve the same effect, either do Query.Table.Open, or rewrite the SELECT query into an equivalent UPDATE query, which would set the Selection (I) column for the objects you want to select to True.
--
Adam Wachowski
Manifold Development Team
_______________________________________________
Manifold-l mailing list
Manifold-l@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/manifold-l
Advertisers
Poll
What's driving interest in the cloud computing at your organization?
