changing ORDER BY clause in a "single record" form?

Hi all

In SC4, is it possible to change by php code the ORDER BY clause of a “single record” form?

best regards!!

Re: changing ORDER BY clause in a “single record” form?

The only way I see is in Settings-> SQL, there is an option Order By.

Re: changing ORDER BY clause in a “single record” form?

Hi Max!!!

that’s right!!!

but how to change that in “Settings-> SQL” just by PHP code??

best regards!

Re: changing ORDER BY clause in a “single record” form?

Just enter a MySQL order by clause like:

address_date desc,
address_zip asc

no php code.