v11 List Box sorting

[Chip Scheide]

Im am looking at other list boxes - and seeing the same problem I asked
about the other day.

That is : Sorting of list box rows on displayed related data.

ex:
List box displaying invoice line items
list box columns include price, quantity and item description.

Item description is NOT stored in the line items table but is in the
product table, and is displayed from that related table.  Sorting on
the item description gives what appears to be random sort results.

any ideas?  
List box is selection based
List box is dynamically defined (ie it changes based on the current
form page/tab)
v11.4
OSX 10.4.11
**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Kenneth Spence-2]

Chip,

See my post "List Box Sort Strange behavior"  and see if what solved  
my problem fixes yours.  My List Boxes were arrays but maybe the same  
thing applies.

Ken
On Oct 28, 2009, at 12:52 PM, Chip Scheide wrote:

> Im am looking at other list boxes - and seeing the same problem I  
> asked
> about the other day.
>
> That is : Sorting of list box rows on displayed related data.
>
> ex:
> List box displaying invoice line items
> list box columns include price, quantity and item description.
>
> Item description is NOT stored in the line items table but is in the
> product table, and is displayed from that related table.  Sorting on
> the item description gives what appears to be random sort results.
>
> any ideas?
> List box is selection based
> List box is dynamically defined (ie it changes based on the current
> form page/tab)
> v11.4
> OSX 10.4.11
> **********************************************************************
> Get the speed and power of 4D v11 SQL
> before upgrade prices increase - http://www.4d.com
>
>
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4D.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4D_Tech-Unsubscribe@...
> **********************************************************************

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Chip Scheide]

Thanks for the pointer -
but these list boxes are dynamic - in this case columns are added left
to right (1 -> ?)
ie in design there are NO columns.

code that manages column & header naming:
$This_Column_Number:=Get number of listbox columns($Listbox->)+1  
`column being added
$Column_Name:="Col"+$List_Box_Name+String($This_Column_Number)  
`reference name for the colum - 'col'+listbox name+# etc
$Header_Name:="Hed"+$List_Box_Name+String($This_Column_Number)  
`reference name for the header button

All columns are defined on the fly.  This is a part of my problem.  I
cant just turn off 'sortable' for the column, then dump the appropriate
code into place to do the sort.

This is partially since 4D will not allow me to access
(programatically) the property 'Sortable' on a column -- if Im wrong
Ill be happy to be corrected.

This is also why I started the Survey thread.


On Wed, 28 Oct 2009 16:48:48 -0600, Kenneth Spence wrote:

> Chip,
>
> See my post "List Box Sort Strange behavior"  and see if what solved
> my problem fixes yours.  My List Boxes were arrays but maybe the same
> thing applies.
>
> Ken
> On Oct 28, 2009, at 12:52 PM, Chip Scheide wrote:
>
>> Im am looking at other list boxes - and seeing the same problem I asked
>> about the other day.
>>
>> That is : Sorting of list box rows on displayed related data.
>>
>> ex:
>> List box displaying invoice line items
>> list box columns include price, quantity and item description.
>>
>> Item description is NOT stored in the line items table but is in the
>> product table, and is displayed from that related table.  Sorting on
>> the item description gives what appears to be random sort results.
>>
>> any ideas?
>> List box is selection based
>> List box is dynamically defined (ie it changes based on the current
>> form page/tab)
>> v11.4
>> OSX 10.4.11
>> **********************************************************************
>> Get the speed and power of 4D v11 SQL
>> before upgrade prices increase - http://www.4d.com
>>
>>
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4D.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4D_Tech-Unsubscribe@...
>> **********************************************************************
>
> **********************************************************************
> Get the speed and power of 4D v11 SQL
> before upgrade prices increase - http://www.4d.com
>  
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4D.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4D_Tech-Unsubscribe@...
> **********************************************************************
>

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Kenneth Spence-2]

I haven't done this but can't you turn the column sorting off by  
setting  the header variable to 0.  I was just reading this in the  
Language manuel on page 862

The value of the variable related to the column header allows you to  
manage additional
information: the current sort of the column (read) and the display of  
the sort arrow.
• If the variable is set to 0, the column is not sorted and the sort  
arrow is not displayed;


Ken

On Oct 29, 2009, at 8:17 AM, Chip Scheide wrote:

> Thanks for the pointer -
> but these list boxes are dynamic - in this case columns are added left
> to right (1 -> ?)
> ie in design there are NO columns.
>
> code that manages column & header naming:
> $This_Column_Number:=Get number of listbox columns($Listbox->)+1
> `column being added
> $Column_Name:="Col"+$List_Box_Name+String($This_Column_Number)
> `reference name for the colum - 'col'+listbox name+# etc
> $Header_Name:="Hed"+$List_Box_Name+String($This_Column_Number)
> `reference name for the header button
>
> All columns are defined on the fly.  This is a part of my problem.  I
> cant just turn off 'sortable' for the column, then dump the  
> appropriate
> code into place to do the sort.
>
> This is partially since 4D will not allow me to access
> (programatically) the property 'Sortable' on a column -- if Im wrong
> Ill be happy to be corrected.
>
> This is also why I started the Survey thread.
>
>
> On Wed, 28 Oct 2009 16:48:48 -0600, Kenneth Spence wrote:
>> Chip,
>>
>> See my post "List Box Sort Strange behavior"  and see if what solved
>> my problem fixes yours.  My List Boxes were arrays but maybe the same
>> thing applies.
>>
>> Ken
>> On Oct 28, 2009, at 12:52 PM, Chip Scheide wrote:
>>
>>> Im am looking at other list boxes - and seeing the same problem I  
>>> asked
>>> about the other day.
>>>
>>> That is : Sorting of list box rows on displayed related data.
>>>
>>> ex:
>>> List box displaying invoice line items
>>> list box columns include price, quantity and item description.
>>>
>>> Item description is NOT stored in the line items table but is in the
>>> product table, and is displayed from that related table.  Sorting on
>>> the item description gives what appears to be random sort results.
>>>
>>> any ideas?
>>> List box is selection based
>>> List box is dynamically defined (ie it changes based on the current
>>> form page/tab)
>>> v11.4
>>> OSX 10.4.11
>>> **********************************************************************
>>> Get the speed and power of 4D v11 SQL
>>> before upgrade prices increase - http://www.4d.com
>>>
>>>
>>> 4D Internet Users Group (4D iNUG)
>>> FAQ:  http://lists.4d.com/faqnug.html
>>> Archive:  http://lists.4D.com/archives.html
>>> Options: https://lists.4d.com/mailman/options/4d_tech
>>> Unsub:  mailto:4D_Tech-Unsubscribe@...
>>> **********************************************************************
>>
>> **********************************************************************
>> Get the speed and power of 4D v11 SQL
>> before upgrade prices increase - http://www.4d.com
>>
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4D.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4D_Tech-Unsubscribe@...
>> **********************************************************************
>>
> **********************************************************************
> Get the speed and power of 4D v11 SQL
> before upgrade prices increase - http://www.4d.com
>
>
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4D.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4D_Tech-Unsubscribe@...
> **********************************************************************

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com


4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Doug Cottrill]

Chip,

Are the relations automatic for the related one tables in question?
I have seen this sort of thing outside of list boxes when sorting
across tables.  If you set AUTOMATIC RELATIONS (TRUE) and
the relationship exists, the sort will work.  If automatic relations are
turned off (and not set in design) the sort fails.  Since you are using
fields in the list box it may be the same issue.

>Im am looking at other list boxes - and seeing the same problem I asked
>about the other day.
>
>That is : Sorting of list box rows on displayed related data.
>
>ex:
>List box displaying invoice line items
>list box columns include price, quantity and item description.
>
>Item description is NOT stored in the line items table but is in the
>product table, and is displayed from that related table.  Sorting on
>the item description gives what appears to be random sort results.
>
>any ideas?
>List box is selection based
>List box is dynamically defined (ie it changes based on the current
>form page/tab)
>v11.4
>OSX 10.4.11
>**********************************************************************
>Get the speed and power of 4D v11 SQL
>before upgrade prices increase - http://www.4d.com
>  
>
>4D Internet Users Group (4D iNUG)
>FAQ:  http://lists.4d.com/faqnug.html
>Archive:  http://lists.4D.com/archives.html
>Options: https://lists.4d.com/mailman/options/4d_tech
>Unsub:  mailto:4D_Tech-Unsubscribe@...
>**********************************************************************

--
Doug Cottrill
PTM Software, LLC

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Chip Scheide]

No the relations are not automatic.

I have tried turning them on (Set auto relations(true))
with no improvement.

I have tried running my own sort (by catching On Header Click, and On
After Sort -- I figured out why they werent generating an event - my
fault) bu still no good.

I *think* the issue is the automatic sort is 'overriding' my coded sort.

I have to play with this some more

On Thu, 29 Oct 2009 11:43:13 -0400, Doug Cottrill wrote:

> Chip,
>
> Are the relations automatic for the related one tables in question?
> I have seen this sort of thing outside of list boxes when sorting
> across tables.  If you set AUTOMATIC RELATIONS (TRUE) and
> the relationship exists, the sort will work.  If automatic relations are
> turned off (and not set in design) the sort fails.  Since you are using
> fields in the list box it may be the same issue.
>
>> Im am looking at other list boxes - and seeing the same problem I asked
>> about the other day.
>>
>> That is : Sorting of list box rows on displayed related data.
>>
>> ex:
>> List box displaying invoice line items
>> list box columns include price, quantity and item description.
>>
>> Item description is NOT stored in the line items table but is in the
>> product table, and is displayed from that related table.  Sorting on
>> the item description gives what appears to be random sort results.
>>
>> any ideas? List box is selection based
>> List box is dynamically defined (ie it changes based on the current
>> form page/tab)
>> v11.4
>> OSX 10.4.11

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Chip Scheide]

On Thu, 29 Oct 2009 08:36:12 -0600, Kenneth Spence wrote:

> I haven't done this but can't you turn the column sorting off by
> setting  the header variable to 0.  I was just reading this in the
> Language manuel on page 862
>
> The value of the variable related to the column header allows you to
> manage additional
> information: the current sort of the column (read) and the display of
> the sort arrow.
> • If the variable is set to 0, the column is not sorted and the sort
> arrow is not displayed;

my reading of this is different then yours, I read this to mean that
the header variable gives the programmer a mechanism to determine *IF*
the column has been sorted by the user, not as an activation of the
sorting of the column. Hence the (design) property 'Sortable'.

I read this to mean:
if the header variable is 0 (zero) then the column is unsorted
if the header variable is 1 it is sorted in ascending order
if the header variable is 2 it is sorted in descending order

>
> On Oct 29, 2009, at 8:17 AM, Chip Scheide wrote:
>
>> Thanks for the pointer -
>> but these list boxes are dynamic - in this case columns are added left
>> to right (1 -> ?)
>> ie in design there are NO columns.
>>
>> code that manages column & header naming:
>> $This_Column_Number:=Get number of listbox columns($Listbox->)+1
>> `column being added
>> $Column_Name:="Col"+$List_Box_Name+String($This_Column_Number)
>> `reference name for the colum - 'col'+listbox name+# etc
>> $Header_Name:="Hed"+$List_Box_Name+String($This_Column_Number)
>> `reference name for the header button
>>
>> All columns are defined on the fly.  This is a part of my problem.  I
>> cant just turn off 'sortable' for the column, then dump the appropriate
>> code into place to do the sort.
>>
>> This is partially since 4D will not allow me to access
>> (programatically) the property 'Sortable' on a column -- if Im wrong
>> Ill be happy to be corrected.
>>
>> This is also why I started the Survey thread.
>>
>>
>> On Wed, 28 Oct 2009 16:48:48 -0600, Kenneth Spence wrote:
>>> Chip,
>>>
>>> See my post "List Box Sort Strange behavior"  and see if what solved
>>> my problem fixes yours.  My List Boxes were arrays but maybe the same
>>> thing applies.
>>>
>>> Ken
>>> On Oct 28, 2009, at 12:52 PM, Chip Scheide wrote:
>>>
>>>> Im am looking at other list boxes - and seeing the same problem I asked
>>>> about the other day.
>>>>
>>>> That is : Sorting of list box rows on displayed related data.
>>>>
>>>> ex:
>>>> List box displaying invoice line items
>>>> list box columns include price, quantity and item description.
>>>>
>>>> Item description is NOT stored in the line items table but is in the
>>>> product table, and is displayed from that related table.  Sorting on
>>>> the item description gives what appears to be random sort results.
>>>>
>>>> any ideas?
>>>> List box is selection based
>>>> List box is dynamically defined (ie it changes based on the current
>>>> form page/tab)
>>>> v11.4
>>>> OSX 10.4.11

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Sheldon King-2]

I've just run across the same issue. It appears (in my case anyway) that
relational sorts don't work period, either in a list box (I'm using a named
selection based LB) or in code. However relational searches work fine.

This code
QUERY([Objects_Relations];[Objects_Relations]ORels_ParentRSN=$vORels_ParentRSN_L;*)
QUERY([Objects_Relations]; & ;[Objects]Objct_Type=$vObjct_Type_L)
works fine and returns the proper records in the [Objects_Relations] table

This code

USE NAMED SELECTION("nsObjctChildren")
ORDER BY([Objects_Relations];[Objects]Objct_Type;<)
COPY NAMED SELECTION([Objects_Relations];"nsObjctChildren")

appears to do absolutely nothing

it functions the same whether using Set Automatic Relations or not.

If I've read the Doc's correctly this should work. I'm at a loss :-(

Note: We are using 11.4HF6 though.

--
The man who smiles when things go wrong has thought of someone to blame it
on. - Robert Bloch
--

Sheldon King
King Computer Consulting
918-413-4330
sgking@...
www.seokcc.com
**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Sheldon King-2]

I have managed to work around my problem and "manually" sort my data. Not
the greatest way because if I had a large selection of records I imagine it
could be kinda slow. But it should deal pretty well with dynamic columns. If
anyone would like me to share I would be more than happy to.

On Thu, Oct 29, 2009 at 12:57 PM, Sheldon King <sgking@...> wrote:

> I've just run across the same issue. It appears (in my case anyway) that
> relational sorts don't work period, either in a list box (I'm using a named
> selection based LB) or in code. However relational searches work fine.
>
> This code
>
> QUERY([Objects_Relations];[Objects_Relations]ORels_ParentRSN=$vORels_ParentRSN_L;*)
> QUERY([Objects_Relations]; & ;[Objects]Objct_Type=$vObjct_Type_L)
> works fine and returns the proper records in the [Objects_Relations] table
>
> This code
>
> USE NAMED SELECTION("nsObjctChildren")
> ORDER BY([Objects_Relations];[Objects]Objct_Type;<)
> COPY NAMED SELECTION([Objects_Relations];"nsObjctChildren")
>
> appears to do absolutely nothing
>
> it functions the same whether using Set Automatic Relations or not.
>
> If I've read the Doc's correctly this should work. I'm at a loss :-(
>
> Note: We are using 11.4HF6 though.
>
> --
> The man who smiles when things go wrong has thought of someone to blame it
> on. - Robert Bloch
> --
>
> Sheldon King
> King Computer Consulting
> 918-413-4330
> sgking@...
> www.seokcc.com
>
>

--
The man who smiles when things go wrong has thought of someone to blame it
on. - Robert Bloch
--

Sheldon King
King Computer Consulting
918-413-4330
sgking@...
www.seokcc.com
**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Chip Scheide]

Please


On Thu, 29 Oct 2009 15:24:44 -0500, Sheldon King wrote:

> I have managed to work around my problem and "manually" sort my data. Not
> the greatest way because if I had a large selection of records I imagine it
> could be kinda slow. But it should deal pretty well with dynamic columns. If
> anyone would like me to share I would be more than happy to.
>
> On Thu, Oct 29, 2009 at 12:57 PM, Sheldon King <sgking@...> wrote:
>
>> I've just run across the same issue. It appears (in my case anyway) that
>> relational sorts don't work period, either in a list box (I'm using a named
>> selection based LB) or in code. However relational searches work fine.
>>
>> This code
>>
>>

QUERY([Objects_Relations];[Objects_Relations]ORels_ParentRSN=$vORels_ParentRSN_L;*)

>> QUERY([Objects_Relations]; & ;[Objects]Objct_Type=$vObjct_Type_L)
>> works fine and returns the proper records in the [Objects_Relations] table
>>
>> This code
>>
>> USE NAMED SELECTION("nsObjctChildren")
>> ORDER BY([Objects_Relations];[Objects]Objct_Type;<)
>> COPY NAMED SELECTION([Objects_Relations];"nsObjctChildren")
>>
>> appears to do absolutely nothing
>>
>> it functions the same whether using Set Automatic Relations or not.
>>
>> If I've read the Doc's correctly this should work. I'm at a loss :-(
>>
>> Note: We are using 11.4HF6 though.
>>
>> --
>> The man who smiles when things go wrong has thought of someone to blame it
>> on. - Robert Bloch
>> --
>>
>> Sheldon King
>> King Computer Consulting
>> 918-413-4330
>> sgking@...
>> www.seokcc.com
>>
>>
>
>

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[John DeSoi]

Sheldon,

Is this needed in call cases, or is the listbox not sorted only when  
you first open the form? SORT LISTBOX COLUMNS used to work in the On  
Load form event, but it stopped working in 11.4. I filed a bug report  
-- the response was that this is now "standard behavior" that it does  
not work in the On Load form event.


John DeSoi, Ph.D.


On Oct 29, 2009, at 4:24 PM, Sheldon King wrote:

> I have managed to work around my problem and "manually" sort my  
> data. Not
> the greatest way because if I had a large selection of records I  
> imagine it
> could be kinda slow. But it should deal pretty well with dynamic  
> columns. If
> anyone would like me to share I would be more than happy to.
>
> On Thu, Oct 29, 2009 at 12:57 PM, Sheldon King <sgking@...>  
> wrote:
>
>> I've just run across the same issue. It appears (in my case anyway)  
>> that
>> relational sorts don't work period, either in a list box (I'm using  
>> a named
>> selection based LB) or in code. However relational searches work  
>> fine.
>>
>> This code
>>
>> QUERY([Objects_Relations];[Objects_Relations]ORels_ParentRSN=
>> $vORels_ParentRSN_L;*)
>> QUERY([Objects_Relations]; & ;[Objects]Objct_Type=$vObjct_Type_L)
>> works fine and returns the proper records in the  
>> [Objects_Relations] table
>>
>> This code
>>
>> USE NAMED SELECTION("nsObjctChildren")
>> ORDER BY([Objects_Relations];[Objects]Objct_Type;<)
>> COPY NAMED SELECTION([Objects_Relations];"nsObjctChildren")
>>
>> appears to do absolutely nothing
>>
>> it functions the same whether using Set Automatic Relations or not.
>>
>> If I've read the Doc's correctly this should work. I'm at a loss :-(
>>
>> Note: We are using 11.4HF6 though.
>>
>> --
>> The man who smiles when things go wrong has thought of someone to  
>> blame it
>> on. - Robert Bloch

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Sheldon King-2]

John,

For whatever reason I am unable to get a named selection based listbox to
sort no matter what I do. However I appear to be having deeper problems than
just that. List boxes aside. With our default relation configuration.

[Object_Relations] = Many Table
[Objects] = One Table

Manual Relation between the 2 tables.

ORDER BY([Objects_Relations];[Objects]Objct_Type;<)

Does Nothing no matter where the code runs. The equivalent sort dosen't even
work when using the Order By editor in User Mode. Which is strange because
according to the doc's:

 "The field may belong to the (selection's) table being reordered or to a
One table related to aTable with an automatic or manual relation."

Which appears to be incorrect or there is a bug.

If I set the relation Automatic in the structure editor. Then the sort will
work in User Mode but will still not work in code. :-(

As I said before, what's even more weird is that my searches work fine
across the relation.

Also (in my List Box) I had no luck either way with Sort List Box Column.

And using Set Automatic Relations & Set Field Relation appear to have no
effect.

We are running Client/Server 11.4HF6 so it could just be a glitch that
will/has been fixt for 11.5

If you have any further Ideas I would like to hear them.

I hope this makes sense. It's late :-)

Thanx

Sheldon

On Thu, Oct 29, 2009 at 6:49 PM, John DeSoi <desoi@...> wrote:

> Sheldon,
>
> Is this needed in call cases, or is the listbox not sorted only when you
> first open the form? SORT LISTBOX COLUMNS used to work in the On Load form
> event, but it stopped working in 11.4. I filed a bug report -- the response
> was that this is now "standard behavior" that it does not work in the On
> Load form event.
>
>
> John DeSoi, Ph.D.
>
>
>
> On Oct 29, 2009, at 4:24 PM, Sheldon King wrote:
>
>  I have managed to work around my problem and "manually" sort my data. Not
>> the greatest way because if I had a large selection of records I imagine
>> it
>> could be kinda slow. But it should deal pretty well with dynamic columns.
>> If
>> anyone would like me to share I would be more than happy to.
>>
>> On Thu, Oct 29, 2009 at 12:57 PM, Sheldon King <sgking@...> wrote:
>>
>>  I've just run across the same issue. It appears (in my case anyway) that
>>> relational sorts don't work period, either in a list box (I'm using a
>>> named
>>> selection based LB) or in code. However relational searches work fine.
>>>
>>> This code
>>>
>>>
>>> QUERY([Objects_Relations];[Objects_Relations]ORels_ParentRSN=$vORels_ParentRSN_L;*)
>>> QUERY([Objects_Relations]; & ;[Objects]Objct_Type=$vObjct_Type_L)
>>> works fine and returns the proper records in the [Objects_Relations]
>>> table
>>>
>>> This code
>>>
>>> USE NAMED SELECTION("nsObjctChildren")
>>> ORDER BY([Objects_Relations];[Objects]Objct_Type;<)
>>> COPY NAMED SELECTION([Objects_Relations];"nsObjctChildren")
>>>
>>> appears to do absolutely nothing
>>>
>>> it functions the same whether using Set Automatic Relations or not.
>>>
>>> If I've read the Doc's correctly this should work. I'm at a loss :-(
>>>
>>> Note: We are using 11.4HF6 though.
>>>
>>> --
>>> The man who smiles when things go wrong has thought of someone to blame
>>> it
>>> on. - Robert Bloch
>>>
>>
> **********************************************************************
> Get the speed and power of 4D v11 SQL
> before upgrade prices increase - http://www.4d.com
>
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4D.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4D_Tech-Unsubscribe@...
> **********************************************************************
>

--
The man who smiles when things go wrong has thought of someone to blame it
on. - Robert Bloch
--

Sheldon King
King Computer Consulting
918-413-4330
sgking@...
www.seokcc.com
**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Chip Scheide]

while I havent test my sorts outside of the list box - I will today
sometime - I am seeing the same behavior with regards to selection  
based list boxes

What I find for a selection based list box is:
If I sort* on a field from the 'master' table (data source table) not a
problem.

If I try to sort* on a field NOT in the 'master' table, ie related
(manual or auto) - the record/row order changes but the order is
undefined.  It *appears* that that the sort order might be entry
order/reverse entry order based on the related table.

* sort in this instance means click on the column header button.

---
If I (using code) capture the 'On Header Click' and 'On After Sort'
events, and try to sort the selection (the selection of records of the
'master' table), the code runs. BUT I get no sort at all; with or
without auto relations on.


 
On Thu, 29 Oct 2009 22:30:40 -0500, Sheldon King wrote:

> John,
>
> For whatever reason I am unable to get a named selection based listbox to
> sort no matter what I do. However I appear to be having deeper problems than
> just that. List boxes aside. With our default relation configuration.
>
> [Object_Relations] = Many Table
> [Objects] = One Table
>
> Manual Relation between the 2 tables.
>
> ORDER BY([Objects_Relations];[Objects]Objct_Type;<)
>
> Does Nothing no matter where the code runs. The equivalent sort dosen't even
> work when using the Order By editor in User Mode. Which is strange because
> according to the doc's:
>
>  "The field may belong to the (selection's) table being reordered or to a
> One table related to aTable with an automatic or manual relation."
>
> Which appears to be incorrect or there is a bug.
>
> If I set the relation Automatic in the structure editor. Then the sort will
> work in User Mode but will still not work in code. :-(
>
> As I said before, what's even more weird is that my searches work fine
> across the relation.
>
> Also (in my List Box) I had no luck either way with Sort List Box Column.
>
> And using Set Automatic Relations & Set Field Relation appear to have no
> effect.
>
> We are running Client/Server 11.4HF6 so it could just be a glitch that
> will/has been fixt for 11.5
>
> If you have any further Ideas I would like to hear them.
>
> I hope this makes sense. It's late :-)
>
> Thanx
>
> Sheldon
>
> On Thu, Oct 29, 2009 at 6:49 PM, John DeSoi <desoi@...> wrote:
>
>> Sheldon,
>>
>> Is this needed in call cases, or is the listbox not sorted only when you
>> first open the form? SORT LISTBOX COLUMNS used to work in the On Load form
>> event, but it stopped working in 11.4. I filed a bug report -- the response
>> was that this is now "standard behavior" that it does not work in the On
>> Load form event.
>>
>>
>> John DeSoi, Ph.D.
>>
>>
>>
>> On Oct 29, 2009, at 4:24 PM, Sheldon King wrote:
>>
>>  I have managed to work around my problem and "manually" sort my data. Not
>>> the greatest way because if I had a large selection of records I imagine
>>> it
>>> could be kinda slow. But it should deal pretty well with dynamic columns.
>>> If
>>> anyone would like me to share I would be more than happy to.
>>>
>>> On Thu, Oct 29, 2009 at 12:57 PM, Sheldon King <sgking@...> wrote:
>>>
>>>  I've just run across the same issue. It appears (in my case anyway) that
>>>> relational sorts don't work period, either in a list box (I'm using a
>>>> named
>>>> selection based LB) or in code. However relational searches work fine.
>>>>
>>>> This code
>>>>
>>>>
>>>>

QUERY([Objects_Relations];[Objects_Relations]ORels_ParentRSN=$vORels_ParentRSN_L;*)

>>>> QUERY([Objects_Relations]; & ;[Objects]Objct_Type=$vObjct_Type_L)
>>>> works fine and returns the proper records in the [Objects_Relations]
>>>> table
>>>>
>>>> This code
>>>>
>>>> USE NAMED SELECTION("nsObjctChildren")
>>>> ORDER BY([Objects_Relations];[Objects]Objct_Type;<)
>>>> COPY NAMED SELECTION([Objects_Relations];"nsObjctChildren")
>>>>
>>>> appears to do absolutely nothing
>>>>
>>>> it functions the same whether using Set Automatic Relations or not.
>>>>
>>>> If I've read the Doc's correctly this should work. I'm at a loss :-(
>>>>
>>>> Note: We are using 11.4HF6 though.
>>>>
>>>> --
>>>> The man who smiles when things go wrong has thought of someone to blame
>>>> it
>>>> on. - Robert Bloch
>>>>
>>>
>> **********************************************************************
>> Get the speed and power of 4D v11 SQL
>> before upgrade prices increase - http://www.4d.com
>>
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4D.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4D_Tech-Unsubscribe@...
>> **********************************************************************
>>
>
>
>
> --
> The man who smiles when things go wrong has thought of someone to blame it
> on. - Robert Bloch
> --
>
> Sheldon King
> King Computer Consulting
> 918-413-4330
> sgking@...
> www.seokcc.com
> **********************************************************************
> Get the speed and power of 4D v11 SQL
> before upgrade prices increase - http://www.4d.com
>    
>
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4D.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4D_Tech-Unsubscribe@...
> **********************************************************************
>

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[David Ringsmuth-3]

Sheldon,

I just worked through a similar problem with relational queries. I was reminded that doing such within a output form may not work.

After I spawned the method to be a stand-alone process and the same query worked exactly as I expected it would.

Hth...
David Ringsmuth

-----Original Message-----
From: 4d_tech-bounces@... [mailto:4d_tech-bounces@...] On Behalf Of Sheldon King
Sent: Thursday, October 29, 2009 10:31 PM
To: 4D iNug Technical
Subject: Re: v11 List Box sorting

John,

For whatever reason I am unable to get a named selection based listbox to
sort no matter what I do. However I appear to be having deeper problems than
just that. List boxes aside. With our default relation configuration.

[Object_Relations] = Many Table
[Objects] = One Table

Manual Relation between the 2 tables.

...

If you have any further Ideas I would like to hear them.

I hope this makes sense. It's late :-)

Thanx

Sheldon

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com


4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Sheldon King-2]

David,

I just tried this. I Started a new Process With just the following lines of
code:

TRACE

ALL RECORDS([Objects_Relations])

ORDER BY([Objects_Relations];[Objects]Objct_Type;>)

ORDER BY([Objects_Relations];[Objects]Objct_Type;<)

Stepping through the code nothing happens :-(

So just for the fun of it I deleted the relation and recreated it. When I
ran my code again 4D crashed when it hit the sort. So I deleted the relation
again and recreated it and the above code returned the same results as
before.

Then I turned the Many -> One relation atutomatic in the structure editor
and the above code works fine.

Then I set the relation back to manual and added:
SET FIELD RELATION([Objects_Relations]ORels_ChildRSN;Automatic;Manual)

and the above code works fine.

However if I add this code:
SET FIELD RELATION([Objects_Relations]ORels_ChildRSN;Automatic;Manual)

USE NAMED SELECTION("nsObjectChildren")
ORDER BY([Objects_Relations];[Objects]Objct_Type;>)
COPY NAMED SELECTION([Objects_Relations;"nsObjectChildren")

SET FIELD RELATION([Objects_Relations]ORels_ChildRSN;Manual;Manual)

 to the on header clicked of my listbox (which is on an "input form" in a
"new process") it dosen't do anything.

I guess I could change my named selection to an interprocess named selection
and launch a new process every time a user clicks on a header and do my
sorts. But that just seems kinda silly.

Thanx

Sheldon

On Fri, Oct 30, 2009 at 12:37 PM, David Ringsmuth <davidinug@...>wrote:

> Sheldon,
>
> I just worked through a similar problem with relational queries. I was
> reminded that doing such within a output form may not work.
>
> After I spawned the method to be a stand-alone process and the same query
> worked exactly as I expected it would.
>
> Hth...
> David Ringsmuth
>
> -----Original Message-----
> From: 4d_tech-bounces@... [mailto:4d_tech-bounces@...]
> On Behalf Of Sheldon King
> Sent: Thursday, October 29, 2009 10:31 PM
> To: 4D iNug Technical
> Subject: Re: v11 List Box sorting
>
> John,
>
> For whatever reason I am unable to get a named selection based listbox to
> sort no matter what I do. However I appear to be having deeper problems
> than
> just that. List boxes aside. With our default relation configuration.
>
> [Object_Relations] = Many Table
> [Objects] = One Table
>
> Manual Relation between the 2 tables.
>
> ...
>
> If you have any further Ideas I would like to hear them.
>
> I hope this makes sense. It's late :-)
>
> Thanx
>
> Sheldon
>
> **********************************************************************
> Get the speed and power of 4D v11 SQL
> before upgrade prices increase - http://www.4d.com
>
>
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4D.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4D_Tech-Unsubscribe@...
> **********************************************************************
>

--
The man who smiles when things go wrong has thought of someone to blame it
on. - Robert Bloch
--

Sheldon King
King Computer Consulting
918-413-4330
sgking@...
www.seokcc.com
**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Chip Scheide]

I was not aware of this - Is this an intentional change in v11 or s it
a side effect (read bug)?


On Fri, 30 Oct 2009 12:37:19 -0500, David Ringsmuth wrote:

> Sheldon,
>
> I just worked through a similar problem with relational queries. I
> was reminded that doing such within a output form may not work.
>
> After I spawned the method to be a stand-alone process and the same
> query worked exactly as I expected it would.
>
> Hth...
> David Ringsmuth
>
> -----Original Message-----
> From: 4d_tech-bounces@...
> [mailto:4d_tech-bounces@...] On Behalf Of Sheldon King
> Sent: Thursday, October 29, 2009 10:31 PM
> To: 4D iNug Technical
> Subject: Re: v11 List Box sorting
>
> John,
>
> For whatever reason I am unable to get a named selection based listbox to
> sort no matter what I do. However I appear to be having deeper problems than
> just that. List boxes aside. With our default relation configuration.
>
> [Object_Relations] = Many Table
> [Objects] = One Table
>
> Manual Relation between the 2 tables.
>
> ...
>
> If you have any further Ideas I would like to hear them.
>
> I hope this makes sense. It's late :-)
>
> Thanx
>

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Chip Scheide]

yes it *IS* silly -
however, AFTER reporting the problem to tech support/forums/bug tracker

if it gets you up and working then at least you have (as clunky as it
maybe) a work around

looks like Im going to have to do this too :(
On Fri, 30 Oct 2009 13:36:59 -0500, Sheldon King wrote:
>
> I guess I could change my named selection to an interprocess named selection
> and launch a new process every time a user clicks on a header and do my
> sorts. But that just seems kinda silly.
**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[Chip Scheide]

This problem (along with a reference to this thread) has been reported
to 4D (bug tracker) as :
ACI0063803
**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[David Ringsmuth-3]

Chip,

My situation with cross relations queries failing was due to being in an
OUTPUT FORM METHOD Querying a different table that used the table I was
displaying as part of the relational query. 4D prevents this. (2003.8r2).

My process made sense to launch stand-alone. It did not require the display
of records after it began.

ListBoxes are not OUTPUT FORMS, and probably do not have the same limitation
by 4D.

Please forgive me if I improperly added concern.

David

-----Original Message-----
From: Chip Scheide [mailto:4d_Only@...]
Sent: Friday, October 30, 2009 1:41 PM
To: davidinug@...; 4D iNug Technical
Subject: RE: v11 List Box sorting

I was not aware of this - Is this an intentional change in v11 or s it
a side effect (read bug)?


On Fri, 30 Oct 2009 12:37:19 -0500, David Ringsmuth wrote:

> Sheldon,
>
> I just worked through a similar problem with relational queries. I
> was reminded that doing such within a output form may not work.
>
> After I spawned the method to be a stand-alone process and the same
> query worked exactly as I expected it would.
>
> Hth...
> David Ringsmuth
>
> -----Original Message-----
> From: 4d_tech-bounces@...
> [mailto:4d_tech-bounces@...] On Behalf Of Sheldon King
> Sent: Thursday, October 29, 2009 10:31 PM
> To: 4D iNug Technical
> Subject: Re: v11 List Box sorting
>
> John,
>
> For whatever reason I am unable to get a named selection based listbox to
> sort no matter what I do. However I appear to be having deeper problems

than

> just that. List boxes aside. With our default relation configuration.
>
> [Object_Relations] = Many Table
> [Objects] = One Table
>
> Manual Relation between the 2 tables.
>
> ...
>
> If you have any further Ideas I would like to hear them.
>
> I hope this makes sense. It's late :-)
>
> Thanx
>

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com
   

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

[David Ringsmuth-3]

Sheldon,

 

Are you “Drilled Into” your listbox form from an OUTPUT form?

 

That may have something to do with it…

 

Hth,

David Ringsmuth

 

From: Sheldon King [mailto:sgking@...]
Sent: Friday, October 30, 2009 1:37 PM
To: davidinug@...; 4D iNug Technical
Subject: Re: v11 List Box sorting

 

David,

 

I just tried this. I Started a new Process With just the following lines of code:

 

TRACE

 

ALL RECORDS([Objects_Relations])

 

ORDER BY([Objects_Relations];[Objects]Objct_Type;>)

 

ORDER BY([Objects_Relations];[Objects]Objct_Type;<)

 

Stepping through the code nothing happens :-(

 

So just for the fun of it I deleted the relation and recreated it. When I ran my code again 4D crashed when it hit the sort. So I deleted the relation again and recreated it and the above code returned the same results as before.

 

Then I turned the Many -> One relation atutomatic in the structure editor and the above code works fine.

 

Then I set the relation back to manual and added:

SET FIELD RELATION([Objects_Relations]ORels_ChildRSN;Automatic;Manual)

 

and the above code works fine.

 

However if I add this code:

SET FIELD RELATION([Objects_Relations]ORels_ChildRSN;Automatic;Manual)

 

USE NAMED SELECTION("nsObjectChildren")

ORDER BY([Objects_Relations];[Objects]Objct_Type;>)

COPY NAMED SELECTION([Objects_Relations;"nsObjectChildren")

 

SET FIELD RELATION([Objects_Relations]ORels_ChildRSN;Manual;Manual)

 

 to the on header clicked of my listbox (which is on an "input form" in a "new process") it dosen't do anything.

 

I guess I could change my named selection to an interprocess named selection and launch a new process every time a user clicks on a header and do my sorts. But that just seems kinda silly.

 

Thanx

 

Sheldon

 

On Fri, Oct 30, 2009 at 12:37 PM, David Ringsmuth <davidinug@...> wrote:

Sheldon,

I just worked through a similar problem with relational queries. I was reminded that doing such within a output form may not work.

After I spawned the method to be a stand-alone process and the same query worked exactly as I expected it would.

Hth...
David Ringsmuth


-----Original Message-----
From: 4d_tech-bounces@... [mailto:4d_tech-bounces@...] On Behalf Of Sheldon King
Sent: Thursday, October 29, 2009 10:31 PM
To: 4D iNug Technical
Subject: Re: v11 List Box sorting

John,

For whatever reason I am unable to get a named selection based listbox to
sort no matter what I do. However I appear to be having deeper problems than
just that. List boxes aside. With our default relation configuration.

[Object_Relations] = Many Table
[Objects] = One Table

Manual Relation between the 2 tables.

...


If you have any further Ideas I would like to hear them.

I hope this makes sense. It's late :-)

Thanx

Sheldon

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com


4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************




--
The man who smiles when things go wrong has thought of someone to blame it on. - Robert Bloch
--

Sheldon King
King Computer Consulting
918-413-4330
sgking@...
www.seokcc.com

**********************************************************************
Get the speed and power of 4D v11 SQL
before upgrade prices increase - http://www.4d.com


4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************