unidirectional

Topic group Related topics

Specifies whether to assume forward-only navigation to increase performance on SQL-based servers.

Property of

Query

Description

If unidirectional is set to true, previously visited rows are not cached and less communication is required between dBASE Plus and the SQL server. This results in fewer resources consumed and better performance, but is worthwhile only if you never want to go backward in the rowset.

If unidirectional is true, you may still be able to go backward, depending on the server, but if so it would be time-consuming.