RE: running query from script

Abner — Fri, 04 Jan 2008 06:26:54 GMT

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

RE: running query from script

Lorne — Fri, 04 Jan 2008 10:46:11 GMT

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

RE: running query from script

Abner — Tue, 15 Jan 2008 00:08:18 GMT

Thanks a lot!

Manifold Community Site: running query from script

RE: running query from script

RE: running query from script

RE: running query from script