Discussions tagged Transaction
unable to assign values to SQLErrText
- Issue
- Last updated 10 months ago
- Chris Pollach @Appeon replied 10 months ago
I am trying to assign values to transaction properties as below
transaction l_tmp
l_tmp = CREATE transaction
l_tmp.DBParm = arg_trans.DBParm
l_tmp.SQLErrText= arg_trans.SQLErrText
l_tmp.SQLDBCode= arg_trans.SQLDBCode
I observe that l_tmp.SQL...
Events in a transaction object (n_tr) like retrievestart/-end for logging purposes.
- How-to
- Last updated 10 months ago
- Olaf Bönning replied 10 months ago
I like to log the begin and the end of an SQL statement because i like to measure the time the SELECT needed.
In datawindows i have the retrievestart and retrieveend events where i can exactly do what i wish to do.
In embedded SQL i use SQLCA which...
Transaction already connected after communication link failure
- Resolved
- How-to
- Last updated 1 year ago
- Andreas Mykonios replied 1 year ago
I connect to SQLServer with ODBC 18 in login window.
I retrieve a report that takes long time.
I terminate connection from server side.
I get message on the client side that communication link is broken.
I wrote code for the retrieve button so th...
How to reconnect broken DB connection?
- Resolved
- How-to
- Last updated 1 year ago
- Berka Frenfert replied 1 year ago
Is there any way connection can be re-established and retrieve is resumed from same record connection was broken?
Sometimes due to network error DB connection is broken when retrieve is in progress and there is no way to resume retrival from the ...
PowerServer 2022 Session Error/Timeout
- Issue
- Last updated 1 year ago
- Logan Liu @Appeon replied 1 year ago
We recently migrated a PB 2019 application to 2022 and also deployed it to PowerServer. It's been working very well. However, one user reported an issue recently. The user stated that the app was started and used without issue for a while. It was...
Web API transaction management and multiple DWs update in single transaction.
- How-to
- Last updated 1 year ago
- Miraben Apani replied 1 year ago
Hi,
I have converted two Datawindows into C# using Snap Develop, have two .NET Datastores, created a WEB API(c#) .I am using ODBC data connection. Working on Transaction management at API side, how to pass multiple DWs from PB (Client side) to API s...
Enhancement request: modify SQLSyntax in transactions SQLPreview event
- Resolved
- Misc
- Last updated 1 year ago
- René Ullrich replied 1 year ago
Hi all, have a happy new year!
I could not find another way to post an enhancement request for future PB versions, so I'll leave it here. If there is a better way to do so, please let me know.
We develop and maintain a quite large c/s application (...
PowerServer not encapsulating SQL in Transactions
- Issue
- Last updated 2 years ago
- Kai Zhao @Appeon replied 2 years ago
We have a PB classic application migrating to PS (latest PB etc.), connecting to Oracle 19 database. When the application runs in PS it is not encapsulating multiple SQL statements in a transaction, almost as though a commit is issued between each s...
Hi Team,
We have met an issue about using the Transaction connecting to Sybase database.
It shows below error when connect failed:
Error Code:-1Error Text:ct_connect(): user api layer: external error: The maximum number of connections have alread...
SQLCA and memory management
- Resolved
- Issue
- Last updated 4 years ago
- Chris Pollach @Appeon replied 4 years ago
Hi, I have a desktop application developed in PB 2017 R3. It is connecting to the database (Sybase ASE 12.5) using the global transaction object SQLCA. To connect to the db, we are setting the trans object as:
SQLCA.Database = "MyDB"SQLCA.Servernam...
Hi.
My application has started pop up a message box on some data fetches.
The message is "Select error: SQL State = 22005 ... Invalid character for cast specification"
This may have started when I changed the connection to a newer SQL server. The ...
nested report - transaction object
- How-to
- Last updated 5 years ago
- Miguel Leeuwe replied 5 years ago
Hi
Can anyone tell me whether it is possible to have a nested report connected to a different transaction object and if so how to.
So the report might be on SQLCA - sales database and the sub / nested report on the SQLCB - personel database
the m...
Transaction's DBHandle() yields DBError
- Issue
- Last updated 6 years ago
- Roland Smith replied 6 years ago
Hello,
Trying to check if a transaction object is connected to a database, I'm calling its DBHandle() function. When the objects is not connected, this call yields the transaction object DBError event. How can this be worked around?
PB 12.5.1 b 459...
Commit transaction error
- Resolved
- Issue
- Last updated 6 years ago
- Appeon Support Team replied 6 years ago
I am using PB 2017 R2 and SQL Server 2017. The following test code works when running on a desktop. When running on a mobile device (iPad) I get error "The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION."-------------------------...
SQL Server Native Test Connection Freezes AEM Console
- Resolved
- How-to
- Last updated 6 years ago
- Tracy Huang @Appeon replied 6 years ago
DB Connection Issues w/ Mobile deploy w/ Native Microsoft SQL Server
Summary
Have not been able to deploy as mobile application and go beyond the database connection. Have tried using native and ODBC and have failed numerous times. PB2017 Help con...
We have multiple users, using same .exe from shared folder (shared folder exist in server), recently i installed the Application first time for one new user but a error is coming
like "Transaction already connected", remaining all users its workin...
- Page :
- 1