Re: "unique table" problem

Try BetterADODataSet (http://betterado.hit.bg/), it has property
Unique_Table and will set it after activating dataset.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Keith G Hicks" <krh@xxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:42c0cdae$1@xxxxxxxxxxxxxxxxxxxxxxxxx
>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)
  • "unique table" problem
    ... I understand that if a TadoDataset's command text is made up of joined ... master dataset's row changes. ... FocusedRecordChange event). ... when the form opens. ...
    (borland.public.delphi.database.ado)
  • 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)