Hi,

this is my code

set rsQuery = new ADODB.RecordSet
rsQuery.Open "SELECT person.*, book.* FROM persons, books WHERE person.id 
= book.id",db, adOpenDynamic, adLockOptimistic
rsQuery.MoveLast
y = rsQuery.RecordCount
rsQuery.AddNew
rsQuery!id = y + 1
rsQuery!name = txtName
...
rsQuery.Update
rsQuery.Requery

But then the error 3265 occurs saying he can't find "rsQuery!id".
How do I solve this and why do I get this error in the first place?
Because the 2 id's have the same name?

Greetingzzz
Snowball

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1EC5F.BC34CDF0
Content-Type: text/plain

try selecting only one id field from either book or person..

-----Original Message-----
From: Snow Ball [mailto:snowballeke@y...]
Sent: Thursday, April 25, 2002 10:46 AM
To: ActiveX_Data_Objects
Subject: [activex_data_objects] Error 3265: Item not found


Hi,

this is my code

set rsQuery = new ADODB.RecordSet
rsQuery.Open "SELECT person.*, book.* FROM persons, books WHERE person.id 
= book.id",db, adOpenDynamic, adLockOptimistic
rsQuery.MoveLast
y = rsQuery.RecordCount
rsQuery.AddNew
rsQuery!id = y + 1
rsQuery!name = txtName
...
rsQuery.Update
rsQuery.Requery

But then the error 3265 occurs saying he can't find "rsQuery!id".
How do I solve this and why do I get this error in the first place?
Because the 2 id's have the same name?

Greetingzzz
Snowball

That did the trick!!
The error is gone
But then of course the next problem :-)
The new person is added in the database, but when i navigate through the 
persons the newly added person is not there :-)

Try:

rsQuery("person.id") = y +1
rsQuery("name") = txtName

Better yet would be use an UPDATE query instead.. it will more efficient and
faster.

-- Tomm


> -----Original Message-----
> From: Snow Ball [mailto:snowballeke@y...]
> Sent: Thursday, April 25, 2002 2:46 PM
> To: ActiveX_Data_Objects
> Subject: [activex_data_objects] Error 3265: Item not found
>
>
> Hi,
>
> this is my code
>
> set rsQuery = new ADODB.RecordSet
> rsQuery.Open "SELECT person.*, book.* FROM persons, books WHERE person.id
> = book.id",db, adOpenDynamic, adLockOptimistic
> rsQuery.MoveLast
> y = rsQuery.RecordCount
> rsQuery.AddNew
> rsQuery!id = y + 1
> rsQuery!name = txtName
> ...
> rsQuery.Update
> rsQuery.Requery
>
> But then the error 3265 occurs saying he can't find "rsQuery!id".
> How do I solve this and why do I get this error in the first place?
> Because the 2 id's have the same name?
>
> Greetingzzz
> Snowball

Of course you can not see. Try this:

 rsQuery("person.id") = y +1
rsQuery("book.id") = y +1
rsQuery("name") = txtName

.....Futuh



> Try:
>
> rsQuery("person.id") = y +1
> rsQuery("name") = txtName
>
> Better yet would be use an UPDATE query instead.. it will more efficient
and
> faster.
>
> -- Tomm
>
>
> > -----Original Message-----
> > From: Snow Ball [mailto:snowballeke@y...]
> > Sent: Thursday, April 25, 2002 2:46 PM
> > To: ActiveX_Data_Objects
> > Subject: [activex_data_objects] Error 3265: Item not found
> >
> >
> > Hi,
> >
> > this is my code
> >
> > set rsQuery = new ADODB.RecordSet
> > rsQuery.Open "SELECT person.*, book.* FROM persons, books WHERE
person.id
> > = book.id",db, adOpenDynamic, adLockOptimistic
> > rsQuery.MoveLast
> > y = rsQuery.RecordCount
> > rsQuery.AddNew
> > rsQuery!id = y + 1
> > rsQuery!name = txtName
> > ...
> > rsQuery.Update
> > rsQuery.Requery
> >
> > But then the error 3265 occurs saying he can't find "rsQuery!id".
> > How do I solve this and why do I get this error in the first place?
> > Because the 2 id's have the same name?
> >
> > Greetingzzz
> > Snowball
>
>