If cOrder_ID is a character type than you can set it to empty string (assuming that SET ANSI OFF) to get all orders. You can also change '=' to 'LIKE".
CREATE SQL VIEW order_purchase CONNECTION sql_hcdc_1 SHARE AS
SELECT * FROM order_purchase WHERE Order_ID LIKE ?cOrder_ID ORDER BY order_ID
cOrder_ID = "%"
>I set up some remote views as shown:
>
>CREATE SQL VIEW order_purchase CONNECTION sql_hcdc_1 SHARE AS SELECT *
FROM order_purchase WHERE Order_ID = ?cOrder_ID ORDER BY order_ID
>
>In some time, I would like to selct all order_purchase, what can I do? any wildcard substitute for cOrder_ID?!
>
--sb--