Re: how to show that there is a detail record

Brian Bushay TeamB wrote:

excuse my dumbness, but I cannot find a way to create a field, which only contains the information that there are detail datasets or not. I need more explanation or a snipplet if possible.

In the IDE right click on your dataset.
Choose to add all field. These are your existing fields from the SQL query you
wrote. Next right click and create a new field. This will be your calculated
field. Next write an OnCalc fields event for this dataset.
In the code for this event check if the fields joined from the detail table have
values then detail dataset has data. Set the value of the calculated field
accordingly
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
Brian,

Thank you, very helpful, but how can I do this during run time? Because I/the user can use slightly different databases. I read the commandtext from an ini-file when the program opens the database.

Thank you very much

Detlef Ross
.

Relevant Pages

  • Re: Cache Size and AsyncFetch
    ... Brian Bushay TeamB wrote: ... form set with the tables via an ADOConnection. ... Asnyc fetching is incompatible with serverside cursors and also with Delphi data ...
    (borland.public.delphi.database.ado)
  • Re: how to deal with multiple result sets in D6 ADO?
    ... Or do you need to extract data and stuff it into a TStrinGrid ... When you run sp_help in the Query Analyzer, ... Brian Bushay TeamB wrote: ...
    (borland.public.delphi.database.ado)
  • Re: TADOQuery master-details
    ... Brian Bushay TeamB wrote: ... >>My program is to extract athletics results from an access database. ... >>TDataSource - DataSourceAV ...
    (borland.public.delphi.database.ado)
  • Re: TADOQuery master-details
    ... Brian Bushay TeamB wrote: ... >>My program is to extract athletics results from an access database. ... >>TDataSource - DataSourceAV ...
    (borland.public.delphi.database.ado)
  • Re: ADO Connection in a Service App
    ... Brian Bushay TeamB wrote: ... Not associated with a trusted SQL Server Connection ... When I run the same service as an application the connection works fine. ...
    (borland.public.delphi.database.ado)