Re: Delphi7 / ADO - 'Origin' property of TQuery blank


Tfields have an Organ property but I don't know of one for datasets.
The tfield.Orgin property of a query should reflect the base table where the
field came from. Why would you wan't to modify that?

With TADOQuery, the 'Origin' property for all fields are blank at design
time - this property NEVER reflects where the field originates. I've just
tried this again to make sure - dropped a new TADOQuery on a form, setup
the connection and a simple SQL query, double click on the query and add
all the fields -> none of them have the 'Origin' set. I always assumed
this was 'normal' behaviour ... uh ... isn't it?

Your right about the blank in the field Origin property. You had me confused
when you referred to Origin as a property of the tadoquery.
Try this code to get the value for the base table of a field
ADODataSet1.Recordset.Fields[1].Properties['basetablename'].Value;

--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • TADOQUery creates but does not free SysString
    ... I have a problem with TADOQuery. ... If I create a query containing a parameter ... procedure TForm1.Button1Click(Sender: TObject); ... var I: Integer; ...
    (borland.public.delphi.database.ado)
  • TAdoQuery parameters & empty strings
    ... all parameters values are taken from TEdit ... MyNameEdit.Text is empty i get an error (when i execute the query) ... it seems to be specific to the tadoquery component, ... and BDE it work fine (with bde i use param.asString for exemple, ...
    (borland.public.delphi.database.ado)
  • Re: connect to excel
    ... Once I get constructed the connection string, how do I specify the query in ... the TADOQuery? ...
    (borland.public.delphi.database.ado)
  • Update TADOQuery from a Select TADOQuery
    ... FROM `daterep` D, mfest` D1 ... I've got this code in a TADOQuery on a form and I ... The four fields I'm returning exist in Repdate. ... I'd like to fire an update query off this, ...
    (borland.public.delphi.database.ado)
  • Re: Programmatically changing the field formats for a table
    ... You can modify some properties of a field with SQL statements, ... Roger dot Carlson at Spectrum-Health dot Org ... > created using a query. ... > the resulting table does not keep the field formats of the ...
    (microsoft.public.access.tablesdbdesign)