Devart Forums

delphiman

Perfect, thank you very much.

Best Regarts,

Eliseu Corrona

delphiman

Hi, is it possible to clone data through TIBCQuery or another IBDAC component, as is done with TClientDataSet with CloneCursor?

Best Regarts,

Eliseu Corrona

delphiman

Hi, sorry for the delay. The forum notification went to the spam box in my email.

I really got confused, a thousand apologies.

The transaction is starting correctly. I was analyzing Firebird system tables and mistake the informations.

It's all correct.

Thank you very much for the feedback and sorry for my fail.

Best Regarts.

delphiman

Hello, I'm performing some tests where I need to perform a query in the database in read-only mode, that is, I want to start a read-only transaction, consult the data and close this transaction.

I did several tests configuring transaction isolation, but I may be doing something wrong as it is not querying with the isolation I request.

Can you give me a correct example of how to use it?

Sample:

Code: Select all

IBCConnection1.DefaultTransaction.IsolationLevel := iblReadOnlyReadCommitted;
IBCConnection1.Open;
IBCConnection1.StartTransaction;
IBCQuery1.Close;
IBCQuery1.SQL.Text := 'select * from test';
IBCQuery1.Open;
IBCConnection1.Commit;

Thanks.

Best Regarts;

delphiman

Hello, I'm performing some tests where I need to perform a query in the database in read-only mode, that is, I want to start a read-only transaction, consult the data and close this transaction.

I did several tests configuring transaction isolation, but I may be doing something wrong as it is not querying with the isolation I request.

Can you give me a correct example of how to use it?

Sample:

Code: Select all

IBCConnection1.DefaultTransaction.IsolationLevel := iblReadOnlyReadCommitted;
IBCConnection1.Open;
IBCConnection1.StartTransaction;
IBCQuery1.Close;
IBCQuery1.SQL.Text := 'select * from test';
IBCQuery1.Open;
IBCConnection1.Commit;

Thanks.

Best Regarts;

delphiman

Hello, I am replying to my own topic because I have identified the solution.

The SetPageBuffers method works normally in IBDAC, it is only necessary to restart Firebird after calling it.

Everything is alright.

I will leave the topic registered anyway for reference if other users also have this question.

Best Regarts.

delphiman

Hello how are you?

Doesn't this method work on Firebird 2.5? I'm using IBDAC version 7.1.2 in Delphi XE.

In tests, I run it, but the buffer page is not changed and also does not generate exceptions.

I identified in the class documentation that apparently this method would only work in Interbase, is that correct?

https://www.devart.com/ibdac/docs/devar ... int32).htm

Note by documentation: You sould install InterBase 6 to use this feature.

Is there another way via IBDAC to change the buffer page?

Thanks.

delphiman

Hello Oleg, all right.
No, the situation is already cleared up. All very well.
Thank you very much.

Best Regarts.

delphiman

Hi, all fine?
I have a little doubt about LockTimeout configuration.

In Readme file, have this description:

Code: Select all

LockTimeout

Use this option to set the Lock timeout for WAIT transactions available on Firebird 2.1 and higher.

const
  coLockTimeout = TSQLConnectionOption(403); // integer
. . .
  SQLConnection1.SQLConnection.SetOption(coLockTimeout, 10);

About this, follow the questions:

1) Is possible configurate this extented option in TSQLConnection default from Delphi?

Example:

Code: Select all

SQLConnection1.Params.Values['LockTimeout'] := '5000';

2) The value from LockTimeout is what? Miliseconds? Seconds? This information not exists in Readme File.

3) To DevartInterBase TransIsolation option, what values are allowed?

Thanks.

Devart Forums

Search found 9 matches

Re: TIBCQuery Clone Data

TIBCQuery Clone Data

Re: Start read only transactions not work

Start read only transactions not work

Start read only transactions not work

Re: TIBCConfigService.SetPageBuffers in Firebird 2.5

TIBCConfigService.SetPageBuffers in Firebird 2.5

Re: LockTimeout: Extended DBExpress Configuration

LockTimeout: Extended DBExpress Configuration