nima
asked on
Unique table and deleting a join recordset
Hi;
In VB6. I've an ADO recordset which its recordsource is like this:
Select *.Document , AccountName.Accounts From Documents Left Join Accounts
On Document.AccountID=Account .AccountID
How can I delete a record in document without deleting its AccountID in
Accounts?
I heard about Unique Table but I don't know how it works.
My data base is Access, I did something like this:
ADOdc1.Recordset.Propertie s("Unique Catalog") = strDBFileName
ADOdc1.Recordset.Propertie s("Unique Table") = "Document"
but after deleting a record I get this:"unique table is nonexistent or not
completely specified."
What's wrong here?
Thanks in advance
In VB6. I've an ADO recordset which its recordsource is like this:
Select *.Document , AccountName.Accounts From Documents Left Join Accounts
On Document.AccountID=Account
How can I delete a record in document without deleting its AccountID in
Accounts?
I heard about Unique Table but I don't know how it works.
My data base is Access, I did something like this:
ADOdc1.Recordset.Propertie
ADOdc1.Recordset.Propertie
but after deleting a record I get this:"unique table is nonexistent or not
completely specified."
What's wrong here?
Thanks in advance
ASKER
Thanks! I know that. It was an example, I've to do it using this properties.Anything else?
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
- PAQ'd and pts refunded
Please leave any comments here within the
next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !
Nic;o)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try
DELETE * FROM Documents
WHERE ((([Documents].AccountID)=
99 being the recordid you wish to delete