Discussions tagged Transaction

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...
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...
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...
  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 ...
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...
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...
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 (...
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...
 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 ...
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...
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...
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."-------------------------...
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