Databas-transaktioner

Operations which you want to perform within a database transaction so that you do not risk partially updated data in the event of an abnormal operating interruption.

Anm: In later versions of Visma Business, more transaction processing has been programmed. We therefore recommend that no one uses this field. You can only use this field if you are experiencing problems with repeated crashes, but even in these cases it is better to find the cause of the crashes. The parameter is not the solution to the problems.

Visma Business will perform these operations with several small transactions, for example around each voucher line, so that data is locked for the shortest possible period of time. The problem with having large transactions is that they can produce disproportionate delays in multi-user systems unless the activities are co-ordinated so that they are performed at different times. Checks are therefore normally recommended only if there is one user or not many concurrent users or if, for example, batch updating can be started at the end of the working day.

If the transaction fails, the status bar will display 0 rows approved and a dialog box will appear to inform you that the transaction was not performed on account of deadlock or another database error. An attempt is made to cancel locks, and voucher and document series are reset if possible (i.e. unless other concurrent users have retrieved data from them in the meantime; see the section on voucher and document series).

Ett uppslag öppnar dialogrutan som innehåller följande kryssrutor och alternativ:

Uppdatering av buntar: Anm: You cannot check the Updating batches field for new installations as this may produce errors in the updated journals. The field is not available in version 4.60.0. If you have updated from a previous version and the field is selected, the function will work as before.
Lagring av order
Lagring generellt
Andra behandlingar
Plocklista
Godkännande av dokument: Approval of documents refers to order documents, delivery notes, price refund requests, reminders, interest notes, payment giros and tax statements.

Egenskap	Värde	Beskrivning
Visas som standard	Ja	Det här fältet visas som standard i tabellvyn.
Domän	Databas-transaktioner	Heltal
SQL-namn	DBTrans	Databasfältets namn.
Nummer	5732