Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » How To » Blocking order column feature
Blocking order column feature [message #3719] Thu, 02 May 2013 01:11 Go to next message
edortizq is currently offline  edortizq
Messages: 82
Registered: August 2008
Location: Ecuador
Member

I have a non-database field on a detail screen, when click over column header the framework returns an error screen with the message "Unknown column 'xxxxxx' in 'order clause'. That's because radicore is trying to execute a select statement with an order by clause, the order by clause is over xxxxxx column.
Is there a way to block the 'order by' on click feature?
Re: Blocking order column feature [message #3721 is a reply to message #3719] Thu, 02 May 2013 02:00 Go to previous messageGo to next message
AJM is currently offline  AJM
Messages: 2275
Registered: April 2006
Location: Surrey, UK
Senior Member
You can use the 'nosort' option as described in FAQ146

Re: Blocking order column feature [message #3722 is a reply to message #3721] Thu, 02 May 2013 02:04 Go to previous messageGo to next message
edortizq is currently offline  edortizq
Messages: 82
Registered: August 2008
Location: Ecuador
Member

Thank you!
Re: Blocking order column feature [message #3723 is a reply to message #3722] Thu, 02 May 2013 02:22 Go to previous messageGo to next message
edortizq is currently offline  edortizq
Messages: 82
Registered: August 2008
Location: Ecuador
Member

It doesn't work Sad
Here is my code in cm_ChangeConfig function:

$this->fieldspec['product_mask'] = array('type' => 'string',
'size' => 12,
'noedit' => 'y',
'nosort' => 'y',
'nondb' => 'y',
'uppercase' => 'y');

Is something wrong?

Thanks for advance!
Re: Blocking order column feature [message #3724 is a reply to message #3723] Thu, 02 May 2013 02:24 Go to previous message
edortizq is currently offline  edortizq
Messages: 82
Registered: August 2008
Location: Ecuador
Member

Sorry, my mistake!!!
I will change the screen file
Previous Topic: Two lines per record in List screen
Next Topic: Cant create relationships
Goto Forum:
  


Current Time: Sun Nov 28 16:31:23 EST 2021

Total time taken to generate the page: 0.01017 seconds