"unique table" problem

I understand that if a TadoDataset's command text is made up of joined
tables that if one wishes to delete records via the dataset (or rather the
grid it's associated with) you have to set the Unique Table property to the
table where you want the delete to occur. I understand that this needs to
be done *after* the dataset is made active.

I've done this and it works fine in one place. In this one place in code,
the dataset's command text is explicitly set and made active each time a
master dataset's row changes. There is no actual master/detail set up
between these two datasets using the IndexFieldNames, MasterFields and
Parameters properties. The detail's command text is reset in code each time
the master moves to a different record (on the master grid's
FocusedRecordChange event).

Here's the problem. It doesn't work in the place where I have master/detail
datasets that are actually using the master/detail configuration with
IndexFieldNames, MasterField and Parameters. That dataset is made active
when the form opens. I set the Unique Table property to the appropriate
table in the form create event just below teh dataset is made active. When I
try to delete from the associated grid, I get an error as if the Unique
Table were not set. Is there a property in the detail dataset that I need to
set to make this work correctly? If not, do I need to reset the Unique Table
every time the master changes rows?

With this problem and the record pointer moving problem I posted a few
minutes ago, I'm wondering if I'd be better off just using brute force and
going back to the stored procedure method. I hope I don't have to do that
though. There must be a way to make this work as desired! :-)

Thanks,

Keith


.

Relevant Pages

  • Re: Ownership of PC routines
    ... Well, I get to do the first bashing to the component owner, ... I am the unfortunate one who has to guess *what* the command is ... Instinctively, I would call that the worst possible solution, having master ... address space own some vendor code. ...
    (bit.listserv.ibm-main)
  • Re: project BIG AppleCrate
    ... request page "123.123.123.123/NADAOPEN FILE ... webserver gets command, recognizes it as being for NadaNet. ... It sends the command over a serial connection to the Master ... the webpage used to control this internet enabled NadaNet could ...
    (comp.sys.apple2)
  • Re: My final word to Jeff
    ... Apostles are against his brethren using violence or killing and murdering ... When the Master informs us NOT to do something, by a commandment, what do ... 52 "Put away your sword," Jesus told him. ... saints will have the wisdom to patiently refrain and obey Christ's command ...
    (uk.religion.christian)
  • Re: [kde] due to compositing, probably ... Re: KDE 4.3 freezes too often now
    ... comfortable with the command line, ... distribution tools to manage that sort of stuff, as it does get complex, ... "Every nonfree program has a lord, a master -- ...
    (KDE)
  • Reservation about UART1 FIFO in C8051F34x in MCE mode
    ... F340 as slaves to one Cypress FX2LP as master. ... I had the slave's ISR pulse when it received anything and pulse ... when it received a command byte. ...
    (comp.arch.embedded)