Hi Guys,

I wanter to opt for the easy option and ended up doing this:

SELECT R.*,
 (SELECT DISTANCE FROM Stations S WHERE R.Station_ID=S.ID) As DISTANCE,
 (SELECT STATION FROM Stations S WHERE R.Station_ID=S.ID) As STATION,
 (SELECT LONGITUDE FROM Stations S WHERE R.Station_ID=S.ID) As LONGITUDE,
 (SELECT LATITUDE FROM Stations S WHERE R.Station_ID=S.ID) As LATITUDE
FROM Races R
ORDER BY XDATE, RACE_TYPE, TRAINING

RequestSensitive=True
ReadOnly=False

I'm still getting the error:  Cannot edit a readonly dataset?

Can you perhaps point out where I'm misunderstand things?


Many thanks
Pierre

Hi there,

Removing the ORDER BY clause makes it work.  I guess to sort it in a specific order, will require one of the other options, such as a temp or memory table?

Thanks
Pierre

Pierre

>Removing the ORDER BY clause makes it work. I guess to sort it in a specific order, will require one of the other options, such as a temp or memory table?

Nope - just an index on the columns you want to order by.

I think you'll need a compound index including XDATE, RACE_TYPE, TRAINING but my memory is failing so it may be three separate ones but without trying it I'm pretty sure that the ORDER BY clause is the place where compound indices are needed.

Roy Lambert [Team Elevate]

> I think you'll need a compound index including XDATE, RACE_TYPE, TRAINING but my
> memory is failing so it may be three separate ones but without trying it I'm pretty sure that
> the ORDER BY clause is the place where compound indices are needed.

Thanks Roy, I will give it a go.

Pierre

Pierre,

Just to add to what Roy said the docs cover most cases quite well:

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Result_Set_Cursor_Sensitivity

In your case point #5: (for getting a sensitive result set)

There is no ORDER BY clause in the SELECT statement, or there is an
ORDER BY clause that minimally matches the columns, and the collations
defined for the columns, in an existing index in the source table.


Raul

On 9/12/2013 6:37 AM, Pierre du Plessis wrote:
> Thanks Roy, I will give it a go.

Raul


Reading the manual is regarded as cheating!

Roy Lambert

It's my secret weapon when i want to make it look like i still know
something

Raul


On 9/12/2013 10:14 AM, Roy Lambert wrote:
> Reading the manual is regarded as cheating!

All clear now - thanks guys - I guess you would suggest me to RTFM