Repository navigation
TPDSSDataManager
This update optimizes database management for MS Access, focusing on stable processing of multi-valued fields (MVF) and resolving database locking conflicts.
Key Improvements:
ID Preservation: Implemented direct data insertion to ensure the "Ідентифікатор" (ID) field remains unchanged during database merging.
MVF Handling: Resolved the "Cannot refer to a table with a multi-valued field using an IN clause" error by utilizing temporary Linked Tables, ensuring checkbox states ("Місяць відображення") are preserved correctly.
Selective Logging: Introduced the SimpleLogger class. It now generates a TPDSS_Errors.txt file in the target directory only if an error occurs.
Log Management: The log file is automatically cleared at the start of every new operation and includes a 1 MB size limit to prevent disk overflow. If no errors occur during processing, no log file is created, keeping the workspace clean.