Re: About deleting.
From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 03/25/05
- Next message: ercan: "Re: create access table with ado sql (cannot change table properties)"
- Previous message: Brian Bushay TeamB: "Re: smalldatetime overflow error"
- In reply to: kolja2003: "About deleting."
- Next in thread: kolja2003: "Re: About deleting."
- Reply: kolja2003: "Re: About deleting."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 24 Mar 2005 20:23:11 -0600
>I get result dataset. I updates fields of table Items, everything works OK.
>Then I try to delete record.
>For my wonder I get records of 2 tables Items&Stock deleted. I didn't want
>to change table Stock so I want to delete only in table Items.
>How to do this? I need to change SQL or there are more fine solution?
Yes you have to set the "Unique Table" property to the table you want the Delete
to affect
ADODataSet.Properties['Unique Table'].Value:='Name of a table';
This property must be set after the table has opened
-- Brian Bushay (TeamB) Bbushay@NMPLS.com
- Next message: ercan: "Re: create access table with ado sql (cannot change table properties)"
- Previous message: Brian Bushay TeamB: "Re: smalldatetime overflow error"
- In reply to: kolja2003: "About deleting."
- Next in thread: kolja2003: "Re: About deleting."
- Reply: kolja2003: "Re: About deleting."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]