Access / QueryDef (s)

[Benoît]

May any body can help me :

I want use AutoIt to use the method QueryDef. Can I do :

$adoCon = ObjCreate ("ADODB.Connection")

$adoCon.Open ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & $<DataBase Name>)

$adoRs = ObjCreate ("ADODB.Querydef")

< How de define or/and change a query whose name is Req01 >

$adoCon.Close

Is it a good begining ?

How use and what the synthaxe the object ADODB.Querydef ?

[Benoît]

A solution is probably closed to :

$adoCon = ObjCreate ("ADODB.Connection")

$adoCon.Open ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & $bdd)

$Numero = 123

$adoCommand = ObjCreate ("ADODB.Command")

$adoCommand.CommandText = "SELECT tableUn.numero FROM tableUn WHERE (((tableUn.numero)=" & $Numero & "))"

$adoCommand.Name = "req02"

;$adoCommand.CommandType = "adExecuteNoRecords" ; PROBLEM :-(

$adoCommand.Execute

$adoCon.Close

But it doesn't work anymore...