Indexing by clicking field header

taniarto jeannica

unread,

Nov 14, 2011, 4:36:56 AM11/14/11

to

Dear All,
Can we sorting a field on the browse box? Such if we clicking the
header of the field the data will sorted automatic

Thanks

Hans Kjaergaard

unread,

Nov 14, 2011, 5:36:01 AM11/14/11

to

On Mon, 14 Nov 2011 01:36:56 -0800 (PST), taniarto jeannica
<jtan...@gmail.com> wrote:

>Dear All,
>Can we sorting a field on the browse box?

Yes.

>Such if we clicking the
>header of the field the data will sorted automatic

I use handcoding (traping of headerclick) and QUEUE, then it is just
to choose a sort order.

But things may depend on your version of Clarion.

/Hans

Z S

unread,

Nov 14, 2011, 7:52:26 AM11/14/11

to

On 14 нов, 11:36, Hans Kjaergaard <hans.k2tek...@post5.tele.dk> wrote:
> On Mon, 14 Nov 2011 01:36:56 -0800 (PST), taniarto jeannica
>

> <jtania...@gmail.com> wrote:
> >Dear All,
> >Can we sorting a field on the browse box?

> >Such if we clicking the
> >header of the field the data will sorted automatic

Hi Taniarto.
There is example in clarion 6: HowTo-ABC -> Browses -> abcbrws.app
Look at Browse Employees - With column header sorting

Zoran.

taniarto jeannica

unread,

Nov 15, 2011, 4:34:21 AM11/15/11

to

Dear Zoran,

It says (PDBY.$$$)Error: Assert:%Fixclassname: cannot find class
Graphclass
ABCBRWS.B1$ Error:Assert:: %Fixclassname: cannot find class
Graphclass

Could you tell me the solution..

thanks

Z S

unread,

Nov 16, 2011, 2:58:23 AM11/16/11

to

Dear Taniarto.
1. SV Graph class must be registered in Clarion for using graph
controls. So, start Clarion, do not open any app, go to Setup,
Template Registry, click on Register and open svgraph.tpl on Clarion
template folder.
2. Certainly, for column header sorting you do not have to use graph
class. Open your app and appropriate procedure, go to tab Actions for
your list, check "Enable Sort Header" in Extended Option tab. In
addition you can customize sort behavior for every column.

I hope it helps.
Zoran.

taniarto jeannica

unread,

Nov 17, 2011, 11:15:57 PM11/17/11

to

Dear Zoran,
1. For Sv graph does it include on Clarion Package we bought? or
should we buy again for the template?
2. For the index header it's work thanks a lot. But if they were date
format it show error " invalid data type " my database is SQL Server
do you have any suggestion for the error?

Thanks

Z S

unread,

Nov 18, 2011, 3:17:11 AM11/18/11

to

Dear Taniarto.
1. Check out if there is svgraph.tpl on Clarion Template folder.
2. I do not know what is the reason for getting this error, but it is
important how did you define date in Clarion DCT?
In PostgreSQL which I use, there must be defined "mydate_str" (for
example), as string and "mydate_grp" (for example), as group:
mydate_str STRING(8)
mydate_grp GROUP,PRE(),OVER(mydate_str)
mydate_date DATE
mydate_time TIME
END

Note that mydate_grp must be placed OVER mydate_str which means that
it use same memory space as mydate_str.
On Clarion side, in templates and in source code, you have to use
mydate_date and mydate_time!!!
On SQL server, or in SQL queries, you have to define and use
mydate_str. In PostgreSQL it is string(8), I do not know what it is
for MSSQL Server
I do not know if it will help.

Regards from Zoran.