Very Computer

I have a problem when I dynamically change the SQL for
a datawindow.

The SQL changed is the WHERE clause and the ORDER BY clause
(ie. sort of returned data) The columns retrieved does not change.
The correct data is always returned, by the ORDER BY clause
is ignored. We have no sort set on the Datawindow, and although
this is an option, we would prefer to have the database do the
work, and return the data in the correct order, rather than
retrieving and then sorting.

We are using PB 3.0a03, SQL*Net 2.1, and Oracle 7.1.

Has anybody had similar problems, or can think of a solution?

TIA,
Ewan

--
--------------------------------------------------
Ewan Humphrey,  BComp(InfoSys), AACS, PCP
Telstra Corporation,                        Voice: +61-3-9865-7477



"Any opinions are mine, No one else wanted them" - Unknown

Quote:

>I have a problem when I dynamically change the SQL for
>a datawindow.

>The SQL changed is the WHERE clause and the ORDER BY clause
>(ie. sort of returned data) The columns retrieved does not change.
>The correct data is always returned, by the ORDER BY clause
>is ignored. We have no sort set on the Datawindow, and although
>this is an option, we would prefer to have the database do the
>work, and return the data in the correct order, rather than
>retrieving and then sorting.

>We are using PB 3.0a03, SQL*Net 2.1, and Oracle 7.1.

>Has anybody had similar problems, or can think of a solution?

>TIA,
>Ewan

This should work. Check the return code from dwmodify. If it is -1,
then you have a syntax problem.