Jump to content

Recommended Posts

Hallo guys!

iam have connected my Access database into my Autoit script

and iam haveing a problem reading the data after i made the Update statemen

its just shows me the last value

iam assume its because the variable $adoRs stays after the Update on the last value.

any idea how to move $adoRs to the first value?

or maybe iam assuming wrong and its somthing else?


including code:

$dbname = "D:\NoteMe.mdb"
$tblname = "Dt_url"
$query = "SELECT * FROM "& $tblname
Local $title
$adoCon = ObjCreate("ADODB.Connection")
$adoCon.Open("Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & $dbname)
$adoRs = ObjCreate ("ADODB.Recordset")
$adoRs.CursorType = 1
$adoRs.LockType = 3
$adoRs.Open ($query, $adoCon)
$adoRs.Fields("url").value = "www.b.co.il"

while not $adoRs.EOF
$title = $adoRs.Fields("url").value
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
  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...