ORDERING DATA WITH UP & DOWN ARROWS

Developers Programming
#1

Hi everybody,

Is there a way to add up and down arrows which allow to move a row up or down in a grid or form already programmed within Scriptcase?

Or must it be programmed manually?

Has anyone ever done this? Help required please!

Many thanks in advance.

#2

Re: ORDERING DATA WITH UP & DOWN ARROWS

Are you talking about moving rows in the grid directly? Same as in the SC5 IDE when ordering blocks? If this is the case, then you will have to code this yourself using your own control in a blank application. See jQuery for options. jQuery is used in SC5 IDE as well as others.

http://jqueryui.com/demos/draggable/#sortable

Regards,
Scott.

#3

Re: ORDERING DATA WITH UP & DOWN ARROWS

Thank you Scott. Your answer was spot on.

#4

Re: ORDERING DATA WITH UP & DOWN ARROWS

By the way, it would be a nice add on to have UP and DOWn buttons available in the form toolbars to change the order in the database of selected rows. :slight_smile:

#5

Re: ORDERING DATA WITH UP & DOWN ARROWS

In joomla you can reaord the records with up & down arrows,

is possible to have this option with the next versions of Scriptcase?

Thanks a lot

D.

#6

Re: ORDERING DATA WITH UP & DOWN ARROWS

Not automatically.

Cause scriptcase order is based on the order that the user creates the database(primary key or set the order manually), unlike joomla that manage their own database, so, changin the order with joomla its only the change of one field.

With scriptcase, we connect to your database(customers database). And we dont know the table structure. Sometimes customers fill the order that they need in the sql, or if is without the order, the database manages the order (in this cause they obey the primary key order. Sometimes users need to order by the inserted data … its not that easy.

Instead of joomly, that has an internal field “order” and the order by is by that field and the arrows only put +1 or -1 :-p

There is a lot of ways to do that. Add a field with an image redirecting to an application to update the database …

#7

Re: ORDERING DATA WITH UP & DOWN ARROWS

You can see example similar at Scriptcase5 in Adobe Developer toolbox for dreameweaver “Dynamic List browser behavior”:

http://help.adobe.com/en_US/Dreamweaver/10.0_ADDT/help.html?content=ch9_display_dynamic_data_20.html