Hello,

I try to run a SQL-query from a script, but I don't see any results in the table or drawing. If I directly run the query (which I created with my script) by opening the query and running it, it does select the objects.

dim qry

if comps.itemByName("SLQuery") <> -1 then comps.remove("SLQuery")

Set qry = actDoc.NewQuery("SLQuery")

qry.Text = "SELECT * FROM [Netwerk Toedeling Origineel] WHERE [Categorisering] = ""Connector"" "

qry.Run()

comps("Netwerk Toedeling Origineel").open

app.messagebox qry.isvalid

I hope someone can tell me what I am doing wrong.

Martijn

Change your Selection Query to an Update Query on intrinsic Field [Selection (I)]. See:

17367

Manifold-L 1

Manifold-L 2

Manipedia

Thanks a lot!