Devart Forums

If I'm doing a SELECT with TMyQuery, will the cursor linked on the the table or will the table closed like TClientdataset. I have to make a pre-printscript witch access some tables on SELECT.

I know that Locate search a record locally on the dataset, but if I'm using filter in runtime will it also filtered in the dataset or will there be a new query created?

I also can use Virtualtable, but it doesn't support blobfields (as far as I know)
and an extra component has to be created.

jkuiper wrote:If I'm doing a SELECT with TMyQuery, will the cursor linked on the the table or will the table closed like TClientdataset. I have to make a pre-printscript witch access some tables on SELECT.

TMyQuery allows to get the direct access to records and fields in a database table.
On executing SELECT query TMyQuery opens a table, fetches data and allows to update records using DML SQL statements.

jkuiper wrote:I know that Locate search a record locally on the dataset, but if I'm using filter in runtime will it also filtered in the dataset or will there be a new query created?

The Filter property serves to specify local a dataset filter. To specify filter for server side you should use the FilterSQL property, that changes WHERE clause of SELECT statement and reopens query.