Subject | Grid sorting not working |
---|---|
Author | Joe Martinez |
Post date | 2003-05-26T23:25:42Z |
I'm (for the first time) trying to implement TIB_Grid sorting by clicking
on the column headers.
The grid is connected to a TIB_Datasource, which is connected to a TIB_Query.
Here is the SQL:
select serialmake,serialmodel,serialnumber,serialcost,serialdaterec,serialnotes
from serials
OrderingItems
========================
Make=SERIALS.SERIALMAKE
Model=SERIALS.SERIALMODEL
SerialNum=SERIALS.SERIALNUMBER
DateReceived=SERIALS.SERIALDATEREC
Cost=SERIALS.SERIALCOST
Notes=SERIALS.SERIALNOTES
OrderingLinks
========================
Make=ITEM=1
Model=ITEM=2
SerialNum=ITEM=3
DateReceived=ITEM=5
Cost=ITEM=4
NotesITEM=6
When I click on a column heading, nothing happens. I've checked the
OrderingItemNo property, and it never changes from 0, no matter what column
header I click on.
What am I doing wrong? Is there something else I need to do to enable this?
-Joe
on the column headers.
The grid is connected to a TIB_Datasource, which is connected to a TIB_Query.
Here is the SQL:
select serialmake,serialmodel,serialnumber,serialcost,serialdaterec,serialnotes
from serials
OrderingItems
========================
Make=SERIALS.SERIALMAKE
Model=SERIALS.SERIALMODEL
SerialNum=SERIALS.SERIALNUMBER
DateReceived=SERIALS.SERIALDATEREC
Cost=SERIALS.SERIALCOST
Notes=SERIALS.SERIALNOTES
OrderingLinks
========================
Make=ITEM=1
Model=ITEM=2
SerialNum=ITEM=3
DateReceived=ITEM=5
Cost=ITEM=4
NotesITEM=6
When I click on a column heading, nothing happens. I've checked the
OrderingItemNo property, and it never changes from 0, no matter what column
header I click on.
What am I doing wrong? Is there something else I need to do to enable this?
-Joe