SQL statement auto storage

<< Click to Display Table of Contents >>

Navigation:  Main Form Interface > SQL Statements >

SQL statement auto storage

Previous pageReturn to chapter overviewNext page

Autosaving tabbed SQL statements

Content of each tab is auto-saved as per user stored in the INI file following the location of the AbsoluteSQL application using the current Windows user name as the INI section heading. To comply with the single line keys nature of the INI files line breaks are substituted by the '<br>' character sequence indicating line breaks.
If running the application from a removable device, the "user" section as stored on the removable will be [REMOVABLE], thus not dependent on the current user name on the PC currently running the application from the removable.

Due to the inherent limitations of 2058 characters for string lengths in an INI file, long SQL statements are broken up into sections, and SQL statements are auto-stored only up to a total of well over 8000 characters, 8188 including formatting characters.
Truncating auto stored very long SQL statements will be warned as:

However, SQL statements of any size may by manually stored and retrieved via the SQL Menu to/from storage folder of choice.
See Open SQL / Save SQL menus.

SQL statement auto reload

On application launch auto stored SQL statements are automatically reloaded from the INI file and reassembled to the non broken SQL statements loaded into the SQL statements tabs.

Porting your application

As the tabbed SQL statements are stored in the application INI-file, do remember to copy and bring along the INI-file, if you relocate your application exe.

INI-file and local area network

As the INI-file on a network file server will be shared by users using the application, never delete or remove the INI-file if it holds data from other users.

AbsoluteSQL Application Manual - 13 March 2023 - Copyright © 2011 - 2023 Niels Knabe