Subject Re: [IBO] Re: Searching and column aliases
Author Geoff Worboys
> How can I use the Ordering functions then? In your example, what
> would be the entries for the OrderingLinks property? I tried putting
> in a fully qualified column name but it does not work e.g.

> a.Name=1
> b.Name=2

> Furthermore, when you refer to the 'Fields* definitions' property,
> are you referring to the FieldsDisplayLabel property? I cannot set
> different labels for both the 'Name' fields. They seem to share the
> same label. On the 'ColumnAttributes' tab in the TIB_Query property
> editor, only one column is displayed (Name), instead of two.

There are several Fields* properties that are very useful for dynamic
queries (I know because I do this a lot).

I just tried the following...

SQL:
SELECT DEPARTMENT.DEPT_NO
, DEPARTMENT.DEPARTMENT
, EMPLOYEE.LAST_NAME
, EMPLOYEE.DEPT_NO
FROM DEPARTMENT
JOIN EMPLOYEE
ON DEPARTMENT.DEPT_NO=EMPLOYEE.DEPT_NO

OrderingItems:
Employee Dept=EMPLOYEE.DEPT_NO
Department=DEPARTMENT.DEPT_NO

OrderingLinks:
EMPLOYEE.DEPT_NO=1
DEPARTMENT.DEPT_NO=2

FieldsDisplayLabel:
DEPARTMENT.DEPT_NO=Dept No
EMPLOYEE.DEPT_NO=Empl Dept


This worked as expected. I did notice that there was a problem with
the dataset property editor - it does not add the table name into the
Fields* properties. But if you manually enter the table names before
the fields the editor does respect them, as does other processing.


So from this, I can only say - if you continue to have problems we
will need more specifics. I do think this is the way to do it, it is
the way IBO was designed to be used.

--
Geoff Worboys
Telesis Computing