Browse on Foreign Data 1

[Petepall]

Hi,

I have a browse Clarion 6.1 with multiple tabs and the table used is Inscription (INS.

The browse list has a field from a client file (CLI:Name)

and i would like to sort and locate from CLI:Name using a locate(CLI:Name).

I tried a solution from Google search at this following URL
but did not worked.

http://groups.google.ca/group/comp....nk=gst&q=incrementallocator+#7326b5e1b83140f4

Thanks...

 

[ShankarJ]

Hi!

If I understand correctly, you have a Browse based on INSCRIPTION (Primary Table) linked to CLIENT table (secondary/related table) and the different Tabs are different Sort Orders. To achieve what you want you need to add another Tab, add that Tab value to the "Conditional Behavior" section of Browse Properties and set up the Browse to use NO Key but the additional Sort Column as +CLI:Name. Please be prepared for slow performance as CLIENT is the Secondary Table.

Regards

 

[Petepall]

Hi ShankarJ

Thanks for the reply,

If i understand very well, this is not a good way of doing things...


What are the other options of doing it.

Thanks for your time.

 

[ShankarJ]

Hi!

No, it is not a bad way of doing things but it may have performance issues as it is left to the View engine to optimize and that sometimes is not good enough for ISAM tables. If your back end database is SQL, then it is not a problem at all as the optimization is done on the SQL database. I would suggest you try it out and see how it performs as performance depends on the database size and the hardware you have.

If the performance is not acceptable ::

Assuming that there is INS:ClientID which is the linking column between INSCRIPTION & CLIENT you can ::

1. Sort on the key using INS:ClientID although this may give you a sorting by Client but not in alphabetic order of Client Name. You can possible range limit it to one Client and have a separate Browse on CLIENT to choose the client.

2. Store the first ten non-space characters of the Client Name in INSCRIPTION and define a key on that column + ClientID and use that key for sorting.

Do you know that you can enable Column Header sorting in C6.1? It is available as a setting on Extended Browse Properties.

Regards

 

[ShankarJ]

Hi!

Or ::

3. Create a new browse with CLIENT as the Primary and INSCRIPTION as the secondary table for the Browse. This will work only if all INSCRIPTION rows have a ClientID i.e. link to CLIENT.

Regards