Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQLRDD Filters and ORDER BY

72 views
Skip to first unread message

gacos...@gmail.com

unread,
May 4, 2013, 8:46:04 AM5/4/13
to
Hello
I'm using SQLRDD and want to do a filter and a sort of a table without index associated, I usually use the function:

cFilter: = "A.` EX_STATUS `= 'A'"
SR_SetFilter (cFilter)
(oDuex) -> (DBGOTOP ())

The question is, how do I tell SQLRDD who also do an ORDER BY?
Something like:

Command: SELECT A. * FROM `external` A WHERE (A. `EX_STATUS` = 'A') ORDER BY A. `sr_recno and A.`EX_NUMERO`) LIMIT 12 / * GoTop * /

The intention is to make an order by any field, the user choose on which column you want to order.

thanks for your comments.

cul...@gmail.com

unread,
May 6, 2013, 2:59:20 AM5/6/13
to
Hi

Order by is done by the order you has selected for your workarea.

if you need costum order, use queries

Regards
Luiz
Message has been deleted
0 new messages