Sign in to follow this  
Followers 0
tn04462

selecting a sub query in autoit?

3 posts in this topic

#1 ·  Posted (edited)

i been trying to select a query in my script because it contains the modified version of the description from ms database but I can't run the query for some reason.

the query name : sub-desc2 - i've tried with and without brackets []

the field is: 8el

#include <access.au3>

$adSource = "data.accdb"

$oADO = _dbOpen($adSource)

$sQuery="select * from sub-desc2"

$result= $oADO.Execute($sQuery)

MsgBox(0,"",$result.Fields( "8el" ).Value )

$result= $oADO.Execute($sQuery)^error

Edited by tn04462

Share this post


Link to post
Share on other sites



>"C:Program Files (x86)AutoIt3SciTE..autoit3.exe" /ErrorStdOut "C:Scriptsturbolisterpulldesc.au3"

We intercepted a COM Error!!

err.description is: Syntax error in FROM clause.

err.windescription is:

err.lastdllerror is: 0

err.scriptline is: 7

err.number is: 80020009

err.source is: Microsoft Office Access Database Engine

err.helpfile is:

err.helpcontext is: 5003131

C:Scriptsturbolisterpulldesc.au3 (8) : ==> Object referenced outside a "With" statement.:

MsgBox(0,"",$result.Fields( "8el" ).Value )

MsgBox(0,"",$result.Fields( "8el" )^ ERROR

>Exit code: 1 Time: 2.942

Share this post


Link to post
Share on other sites

is it possible to select a subquery? i can't find any post that had an example . any help please?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0