'NEXT' in 5.0 version

asieraies

Hi,

In version 5.0 with SqlServer2005, has "NEXT" any improvement?

Thanks

Asier

frede

No - but you have the FINDFIRST, FINDLAST AND FINDSET which should make it faster to do the searches through the database with the NEXT command.

davmac1

And don't make updates directly to records in the NEXT set - use a temp table

bbrown

davmac1 wrote:

And don't make updates directly to records in the NEXT set - use a temp table

This is only an issue if updating fields that are part of the current key. In that case use FINDSET(TRUE,TRUE) and copy the record to another record variable before modifying

Waldo

Well, to be hones ... it should have been done this way, even without the new FINDSET-statement, don't you agree?

bbrown

True

kriki

[Topic moved from Upcoming version NAV 5.1 forum to SQL Performance forum]