Re: Forms 4.5 - Ordering by Non-DB field + Other Q's

> >1) Any ideas on a simple way to order records in a block (based on a
> >table) by a non-database field ?
>
> Easy? Surely you gest! You could write your own cursor and use
> decode in the select statement to achieve a different order. The
> order by would be based on the values returned by the decode function.
>
If you set the ORDERBY property for the block to null, you can programatically change the WHERE property. (SET_BLOCK_PROPERTY (block, DEFAULT_WHERE) )

You can add the order by to the end (fetch the current where by : GET_BLOCK_PROPERTY(block, default_where) ).

Hey Presto.

> >3) GPF's. What tools are available for detecting why these are occuring?
>
> I don't know of any. Probably GPF's (stands for Gates Pension Fund,
> doesn't it?) are due to your next question.
>
Most GPF's come from Resource problems OR dodgy code. I had many many GPF as a result of changing a library/function and not recompiling & generatnig *ALL* of the forms referencing this library.

> >4) Application also does not allow too many forms to be open at the same
> >time; what is a reasonable number of forms that you could expect to have
> >open at the same time (100Mhz, 32MB, WIN95)?
>
It depends on the data model and size of tables/forms & what you are doing. Are you also running PO7?

>
>

-- 
Paul Haigh  - paul_at_nailed.demon.co.uk
-------------------------------------------------------------------------
Genetics explains why you look like your father, and if you
don't, why you should.