Recent

Author Topic: Default SQLDB TSQLTransaction transaction params for Firebird 2.5  (Read 2714 times)

Unvictis

  • New Member
  • *
  • Posts: 13
  • Nihil habeo, nihil timeo
Hi everyone!

First I want to thank the team of FreePascal and Lazarus for such a wonderful free products and their many years of hard work! You make the world a better place! Happy to continue the immersion in the Lazarus SQLDB and Firebird.

In this regard, I want to know what the default params (if TSQLTransaction.Params.Text = ";) starts a transaction for Firebird 2.5 (for Lazarus 1.6.2)?
« Last Edit: January 28, 2017, 01:09:11 pm by Unvictis »

mangakissa

  • Hero Member
  • *****
  • Posts: 1101
Re: Default SQLDB TSQLTransaction transaction params for Firebird 2.5
« Reply #1 on: January 29, 2017, 05:26:00 pm »
Firebird always create a transaction file when you get data from.
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

Unvictis

  • New Member
  • *
  • Posts: 13
  • Nihil habeo, nihil timeo
Re: Default SQLDB TSQLTransaction transaction params for Firebird 2.5
« Reply #2 on: January 30, 2017, 03:28:52 pm »
Firebird always create a transaction file when you get data from.
Yes, I know that Firebird starts a transaction in any action with a dataset (read, write, edit etc..).

I need to know what parameters (isc_tpb_nowait or isc_tpb_wait / isc_tpb_read_committed or isc_tpb_concurrency etc..) starts a transaction unless explicitly not specified parameters (default).
« Last Edit: January 30, 2017, 03:49:53 pm by Unvictis »

rvk

  • Hero Member
  • *****
  • Posts: 4407
Re: Default SQLDB TSQLTransaction transaction params for Firebird 2.5
« Reply #3 on: January 30, 2017, 04:36:52 pm »
I'm not sure if FPC overrides the default from Firebird but if no options are provided these are the default:
isc_tpb_write
isc_tpb_wait
isc_tpb_concurrency


Unvictis

  • New Member
  • *
  • Posts: 13
  • Nihil habeo, nihil timeo
Re: Default SQLDB TSQLTransaction transaction params for Firebird 2.5
« Reply #4 on: January 30, 2017, 04:41:22 pm »
I'm not sure if FPC overrides the default from Firebird but if no options are provided these are the default:
isc_tpb_write
isc_tpb_wait
isc_tpb_concurrency
Thanks, I got the answer to my question!

 

TinyPortal © 2005-2018