not very SMART windows

[Norman Biggar]

I have a smartwindow with sdo, sdb and navigation toolbar.

The user is able to re-sort the data in the browser as per their requirements.

This is done by reopening the browser query "FOR EACH RowObject BY ....".

The navigation toolbar by definition, however, works on the database query. e.g. "FOR EACH Customer ....".

Because they work on different queries, this means that reopening the browser query does not reflect in the First,Prev,Next,Last status on the toolbar.

Other than reopening the SDO query, thus increasing network traffic, can anyone suggest a method for realigning the navigation toolbar with the browser query?

 

[mra]

Hi Norman!

I'm completely new to ADM so please forgive me if I make an idiot of myself.

Changing the query from outside the ADM model won't work, you have to use a smartfilter object, or call the setQueryWhere function in some other way. To open the query you have to call openQuery. How this is accomplished I'm not really shure of.

Both are part of the query.p SmartObject.


Regards
Mike

 

[Norman Biggar]

By much experimentation and randomly hitting buttons, the following seems to achieve the desired result.

APPLY "HOME" TO ip-hBrowse.
PUBLISH 'fetchPrev' FROM hNavigate.
APPLY "END" TO ip-hBrowse.

hQuery:REPOSITION-TO-ROWID(rRowid) NO-ERROR.

Where ip-hBrowse is the browser on the SDB, hQuery is the query associated with the browser("FOR EACH RowObject BY ....") and hNavigate is the navigation panel/toolbar associated with the database query("FOR EACH Customer").

Unless someone can find a better method, or give me an excellent reason not to use it..........................