Page 1 of 1
Commit Control
Posted: Mon Mar 09, 2015 11:49 am
by devinst
When using Database Driven Selection in a selection box, does Profound UI use SQL to populate the object? If so, where does it get its commit control level? Will it pick up the same option as used in the controlling RPG object? Thanks.!!!
Re: Commit Control
Posted: Mon Mar 09, 2015 4:54 pm
by Scott Klement
It generates an SQL SELECT statement, and runs it using the SQL Call-Level Interface (CLI). It does not set any commitment control settings, so it'll end up with whatever is the default for SQL CLI. I believe the default is SQL_TXN_READ_UNCOMMITTED.
Why, is this causing you problems?
Re: Commit Control
Posted: Thu Mar 12, 2015 11:17 am
by devinst
We were having trouble with our backups and I just wanted to rule that out. I have begun using some commit control in our development, *CHG, and wanted to make sure that it would not be an issue. Thanks for the info.!!!