DBEXPRESS: Operation not allowed on unidirectional dataset

Question

DBEXPRESS: Operation not allowed on unidirectional dataset

Guest (visitor)

(OP)

29 Jan 02 05:11

I put a datasource, sqlconnection, sqlquery and a dbgrid,
and when I try to change dbgrid datasource it tells me:
"Operation not allowed on unidirectional dataset"

What is the solution to this!

Dooda (IS/IT--Management) · Answer 1 · 2002-01-29 06:43:19

I haven't used dbexpress, but have seen changing the datasource of a Tquery fail if the Tquery was not first made inactive.

TimSNL (Programmer) · Answer 2 · 2002-01-29 16:56:48

"Operation not allowed on unidirectional dataset"

A unidirectional dataset can only move through records in one direction, not back and forward. A grid can move in both directions and so can't be connected to a unidirectional dataset.

You realy need to read the "Developers Guide", part II, 'Developing Database Applications', page 14-6.

To use a grid you need these components ...
SQLQuery
DataSetProvider
ClientDataSet
DataSource
DBGrid

This can also be achieved by using the TSQLClientDatSet which murges the first 3 components in the above list into 1.

Tim Dover

Come Join Us!

Posting Guidelines

Jobs

DBEXPRESS: Operation not allowed on unidirectional dataset