> Hi,

> I have a very interesting situation.

> Let's say I have 2 tables

> Table1
> Key
> Name
> Rent

> Table2
> Key
> Source
> Rent

> and I am using following SQL statement

> select T1.Name, T2.Rent
> from Table1 T1, Table2 T2
> where T2.Key = T1.Key

> and it works just fine. But when I am adding "order by Rent" it acts pritty
> strange. Even though I specified that I am using T2.Rent it will actually
> sort by T1.Rent

> Thanks!
> Hayk

> Jeff,

> This is what is says in Help about Origin

> Origin is only assigned at design time by the Fields editor, and only when
> the field component is used by a TQuery object.

> Hayk

> Jeff Overcash (TeamB) wrote:
> > You are mistaken.  This code

> > procedure TForm1.Button1Click(Sender: TObject);
> > begin
> >   IBDataSet1.Close;
> >   IBDataSet1.SelectSQL.Text := 'select * from employee';
> >   IBDataSet1.Open;
> >   ShowMessage(IBDataset1.FieldByName('dept_no').Origin);
> > end;

> > Correctly displays EMPLOYEE.DEPT_NO.  You must not be on a current
> > version of IBX, but this was put in nearly a year ago IIRC.  If you
> > are persisting TFIelds at design time the Origin won't change
> > (nothing changes).

> Your example is correct, but I have said about the case when teh fields are
> created design time ie persistent fields, note this in my post.

> Bojidar Alexandrov wrote:

> > Jeff Overcash (TeamB) wrote:
> > > You are mistaken.  This code

> > > procedure TForm1.Button1Click(Sender: TObject);
> > > begin
> > >   IBDataSet1.Close;
> > >   IBDataSet1.SelectSQL.Text := 'select * from employee';
> > >   IBDataSet1.Open;
> > >   ShowMessage(IBDataset1.FieldByName('dept_no').Origin);
> > > end;

> > > Correctly displays EMPLOYEE.DEPT_NO.  You must not be on a current
> > > version of IBX, but this was put in nearly a year ago IIRC.  If you
> > > are persisting TFIelds at design time the Origin won't change
> > > (nothing changes).

> > Your example is correct, but I have said about the case when teh fields
are
> > created design time ie persistent fields, note this in my post.

> Persisted TFields never change their values.  That is the whole point in
> persisting them at design time.  The Origin is also filled out when
persisting
> them at design time.  Once persisted though the TField values set are
never
> changed unless you explicitly do so.

> --
> Jeff Overcash (TeamB)
>       (Please do not email me directly unless  asked. Thank You)
> The correct way to punctuate a sentence that starts: "Of course it is
> none of my business but ~" is to place a period after the word "but".
> Don't use excessive force in supplying such a moron with a period.
> Cutting his throat is only a momentary pleasure and is bound to get
> you talked about.   (RAH)

> Jeff,

> I just checked and you are right, both IBDataSet and IBQuery are automaticly
> populating Origin field.

> Now is it something that was implemented during past year or so? Cause that
> part of my code doesn't have Origin filed populated and it was originally
> writen more that a year ago.