| View previous topic :: View next topic |
| Author |
Message |
Davide Pasqualini
Guest
|
 Posted: Wed Jun 07, 2006 7:19 pm Post subject: Deleting records |
 |
|
I'm getting a lot of troubles trying to delete a single record from a
TADOQuery or TADODataSet containing an SQL SELECT with LEFT JOIN because get
an error.
Have I to use a separate TADOQuery per executing the DELETE command or what
else ?
Thanks in advance |
|
| Back to top |
|
 |
Darren
Guest
|
| Posted: Wed Jun 07, 2006 7:23 pm Post subject: Re: Deleting records |
|
|
You need to specify the "unique table" property. This is exposed if you use
tBetterAdoDataset
"Davide Pasqualini" <bytetech (AT) libero (DOT) it> wrote in message
news:4486e000$1 (AT) newsgroups (DOT) borland.com...
| Quote: | I'm getting a lot of troubles trying to delete a single record from a
TADOQuery or TADODataSet containing an SQL SELECT with LEFT JOIN because
get an error.
Have I to use a separate TADOQuery per executing the DELETE command or
what else ?
Thanks in advance
|
|
|
| Back to top |
|
|
Brian Bushay TeamB
Guest
|
| Posted: Fri Jun 09, 2006 7:03 am Post subject: Re: Deleting records |
|
|
| Quote: | I'm getting a lot of troubles trying to delete a single record from a
TADOQuery or TADODataSet containing an SQL SELECT with LEFT JOIN because get
an error.
Have I to use a separate TADOQuery per executing the DELETE command or what
else ?
Thanks in advance
You need to set the ADO property "unique Table" to the table in the join that |
you want the delete to occur on
ADODataSet.Properties['Unique Table'].Value:='Name of a table';
It is best to set this in the table BeforeDelete event
--
Brian Bushay (TeamB)
Bbushay (AT) NMPLS (DOT) com |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
