AboutDialog About SQLiteStudio and licenses About <html><head/><body><p align="center"><span style=" font-size:11pt; font-weight:600;">SQLiteStudio v%1</span></p><p align="center">Free, open-source, cross-platform SQLite database manager.<br/><a href="http://sqlitestudio.pl"><span style=" text-decoration: underline; color:#0000ff;">http://sqlitestudio.pl</span></a><br/></p><p align="center">%2<br/></p><p align="center">Author and active maintainer:<br/>SalSoft (<a href="http://salsoft.com.pl"><span style=" text-decoration: underline; color:#0000ff;">http://salsoft.com.pl</span></a>)<br/></p></body></html> Licenses Environment Icon directories Form directories Plugin directories Application directory SQLite 3 version: Configuration directory Qt version: Portable distribution. MacOS X application boundle distribution. Operating system managed distribution. Copy <h3>Table of contents:</h3><ol>%2</ol> BugDialog Bugs and ideas Reporter E-mail address Log in Short description Detailed description Show more details SQLiteStudio version Operating system Loaded plugins Send You can see all your reported bugs and ideas by selecting menu '%1' and then '%2'. A bug report sent successfully. An error occurred while sending a bug report: %1 %2 You can retry sending. The contents will be restored when you open a report dialog after an error like this. An idea proposal sent successfully. An error occurred while sending an idea proposal: %1 %2 A bug report Describe problem in few words Describe problem and how to reproduce it A new feature idea A title for your idea Describe your idea in more details Reporting as an unregistered user, using e-mail address. Reporting as a registered user. Log out Providing true email address will make it possible to contact you regarding your report. To learn more, press 'help' button on the right side. Enter vaild e-mail address, or log in. Short description requires at least 10 characters, but not more than 100. Longer description can be entered in the field below. Long description requires at least 30 characters. BugReportHistoryWindow Title Reported at URL Reports history Clear reports history Delete selected entry Invalid response from server. BugReportLoginDialog Log in Credentials Login: Password: Validation Validate Validation result message Abort A login must be at least 2 characters long. A password must be at least 5 characters long. Valid CollationsEditor Filter collations Collation name: Implementation language: Databases Register in all databases Register in following databases: Implementation code: Collations editor Commit all collation changes Rollback all collation changes Create new collation Delete selected collation Editing collations manual Enter a non-empty, unique name of the collation. Pick the implementation language. Enter a non-empty implementation code. Collations editor window has uncommitted modifications. ColorButton Pick a color ColumnCollatePanel Collation name: Named constraint: Enter a name of the constraint. Enter a collation name. ColumnDefaultPanel Default value: Named constraint: Enter a default value expression. Invalid default value expression: %1 Enter a name of the constraint. ColumnDialog Column Name and type Scale Precision Data type: Column name: Size: Constraints Unique Configure Foreign Key Collate Not NULL Check condition Primary Key Default Advanced mode Add constraint column dialog Edit constraint column dialog Delete constraint column dialog Move constraint up column dialog Move constraint down column dialog Add a primary key column dialog Add a foreign key column dialog Add an unique constraint column dialog Add a check constraint column dialog Add a not null constraint column dialog Add a collate constraint column dialog Add a default constraint column dialog Are you sure you want to delete constraint '%1'? column dialog Correct the constraint's configuration. This constraint is not officially supported by SQLite 2, but it's okay to use it. Scale is not allowed for INTEGER PRIMARY KEY columns. Precision cannot be defined without the scale. Precision is not allowed for INTEGER PRIMARY KEY columns. ColumnDialogConstraintsModel Type column dialog constraints Name column dialog constraints Details column dialog constraints ColumnForeignKeyPanel Foreign table: Foreign column: Reactions Deferred foreign key Named constraint Constraint name Pick the foreign table. Pick the foreign column. Enter a name of the constraint. ColumnPrimaryKeyPanel Autoincrement Sort order: Named constraint: On conflict: Enter a name of the constraint. Autoincrement (only for %1 type columns) column primary key ColumnUniqueAndNotNullPanel Named constraint: On conflict: Enter a name of the constraint. CompleterWindow Column: %1 completer statusbar Table: %1 completer statusbar Index: %1 completer statusbar Trigger: %1 completer statusbar View: %1 completer statusbar Database: %1 completer statusbar Keyword: %1 completer statusbar Function: %1 completer statusbar Operator: %1 completer statusbar String completer statusbar Number completer statusbar Binary data completer statusbar Collation: %1 completer statusbar Pragma function: %1 completer statusbar ConfigDialog Configuration Search General Keyboard shortcuts Look & feel Style Fonts Colors Plugins Code formatters Data browsing Data editors Database dialog window <p>When adding new database it is marked to be "permanent" (stored in configuration) by default. Checking this option makes every new database to NOT be "permanent" by default.</p> Do not mark database to be "permanent" by default <p>When this option is enabled, then files dropped from file manager onto database list will be automatically added to the list, bypassing standard database dialog. If for various reasons automatic process fails, then standard dialog will be presented to the user.</p> Try to bypass dialog completly when dropping database file onto the list Data browsing and editing Number of data rows per page: <p>When the data is read into grid view columns width is automatically adjusted. This value limits the initial width for the adjustment, but user can still resize the column manually over this limit.</p> Limit initial data column width to (in pixels): <p>When this is enabled and user holds mouse pointer over a cell in any data view (query results, a table data, a view data) a tooltip will appear with details about the cell - it includes details like column data type, constraints, ROWID and others.</p> Show column and row details tooltip in data view <p>When editing a cell which used to have NULL value and entering empty string as new value, then this option determinates whether the new value should remain NULL (have this option enabled), or should it be overwritten with empty string value (have this option disabled).</p> Inserting new row in data grid Before currently selected row After currently selected row At the end of data view <p>When enabled, Table Windows will show up with the data tab, instead of the structure tab.</p> <p>When enabled the "Data" tab will be placed as first tab in every Table Window, instead of being at second place.</p> Place data tab as first tab in a Table Window <p>When enabled, View Windows will show up with the data tab, instead of the structure tab.</p> <p>When enabled the "Data" tab will be placed as first tab in every View Window, instead of being at second place.</p> Place data tab as first tab in a View Window Data types Available editors: Editors selected for this data type: Schema editing Number of DDL changes kept in history. DDL history size: SQL queries Number of queries kept in the history. History size: <p>If there is more than one query in the SQL editor window, then (if this option is enabled) only a single query will be executed - the one under the keyboard insertion cursor. Otherwise all queries will be executed. You can always limit queries to be executed by selecting those queries before calling to execute.</p> Execute only the query under the cursor Updates Automatically check for updates at startup Session Restore last session (active MDI windows) after startup Status Field <p>When user manually closes the Status panel, this option makes sure that if any new message is printed in the Status panel it will be reopened. If it's disabled, then Status panel can only be open manually by the user from the "View" menu.</p> Always open Status panel when new message is printed Filter shortcuts by name or key combination Action Key combination Language Changing language requires application restart to take effect. Compact layout <p>Compact layout reduces all margins and spacing on the UI to minimum, making space for displaying more data. It makes the interface a little bit less aesthetic, but allows to display more data at once.</p> Use compact layout Database list If switched off, then columns will be sorted in the order they are typed in CREATE TABLE statement. Sort table columns alphabetically Expand tables node when connected to a database <p>Additional labels are those displayed next to the names on the databases list (they are blue, unless configured otherwise). Enabling this option will result in labels for databases, invalid databases and aggregated nodes (column group, index group, trigger group). For more labels see options below.<p> Display additional labels on the list For regular tables labels will show number of columns, indexes and triggers for each of tables. Display labels for regular tables Virtual tables will be marked with a 'virtual' label. Display labels for virtual tables Expand views node when connected to a database If this option is switched off, then objects will be sorted in order they appear in sqlite_master table (which is in order they were created) Sort objects (tables, indexes, triggers and views) alphabetically Display system tables and indexes on the list Keep NULL value when entering empty value <html><head/><body><p>Enable this to always enforce DEFAULT value when committing a NULL value for a column that has DEFAULT value defined, even though the column is allowed to contain NULL values.</p><p>Disable this option to use DEFAULT value exclusively when NULL value is committed for column with NOT NULL constraint.</p></body></html> Use DEFAULT value (if defined), when committing NULL value Table windows Open Table Windows with the data tab for start View windows Open View Windows with the data tab for start Don't show DDL preview dialog when committing schema changes Main window dock areas Left and right areas occupy corners Top and bottom areas occupy corners Hide built-in plugins Current style: Preview Enabled Disabled Active formatter plugin SQL editor font Database list font Database list additional label font Data view font Status field font SQL editor colors Current line background <p>SQL strings are enclosed with single quote characters.</p> String foreground <p>Bind parameters are placeholders for values yet to be provided by the user. They have one of the forms:</p><ul><li>:param_name</li><li>$param_name</li><li>@param_name</li><li>?</li></ul> Bind parameter foreground Highlighted parenthesis background <p>BLOB values are binary values represented as hexadecimal numbers, like:</p><ul><li>X'12B4'</li><li>x'46A2F4'</li></ul> BLOB value foreground Regular foreground Line numbers area background Keyword foreground Number foreground Comment foreground <p>Valid objects are name of tables, indexes, triggers, or views that exist in the SQLite database.</p> Valid objects foreground Data view colors <p>Any data changes will be outlined with this color, until they're committed to the database.</p> Uncommitted data outline color <p>In case of error while committing data changes, the problematic cell will be outlined with this color.</p> Commit error outline color NULL value foreground Deleted row background Database list colors <p>Additional labels are those which tell you SQLite version, number of objects deeper in the tree, etc.</p> Additional labels foreground Status field colors Information message foreground Warning message foreground Error message foreground Description: plugin details Category: plugin details Version: plugin details Author: plugin details Internal name: plugin details Dependencies: plugin details Conflicts: plugin details Plugin details Plugins are loaded/unloaded immediately when checked/unchecked, but modified list of plugins to load at startup is not saved until you commit the whole configuration dialog. %1 (built-in) plugins manager in configuration dialog Details No plugins in this category. Add new data type Rename selected data type Delete selected data type Help for configuring data type editors ConstraintCheckPanel The condition Named constraint: On conflict Enter a valid condition. Enter a name of the constraint. ConstraintDialog New constraint constraint dialog Create constraint dialog Edit constraint dialog window Apply constraint dialog Primary key table constraints Foreign key table constraints Unique table constraints Not NULL table constraints Check table constraints Collate table constraints Default table constraints ConstraintTabModel Table table constraints Column (%1) table constraints Scope table constraints Type table constraints Details table constraints Name table constraints CssDebugDialog SQLiteStudio CSS console DataView Filter data data view Grid view Form view Refresh table data data view First page data view Previous page data view Next page data view Last page data view Apply filter data view Commit changes for selected cells data view Rollback changes for selected cells data view Show grid view of results sql editor Show form view of results sql editor Filter by text data view Filter by the Regular Expression data view Filter by SQL expression data view Tabs on top data view Tabs at bottom data view Place new rows above selected row data view Place new rows below selected row data view Place new rows at the end of the data view data view Total number of rows is being counted. Browsing other pages will be possible after the row counting is done. Row: %1 DbConverterDialog Convert database Source database Source database version: Target database Target version: This is the file that will be created as a result of the conversion. Target file: Name of the new database: This is the name that the converted database will be added to SQLiteStudio with. Select source database Enter valid and writable file path. Entered file exists and will be overwritten. Enter a not empty, unique name (as in the list of databases on the left). No valid target dialect available. Conversion not possible. Select valid target dialect. Database %1 has been successfully converted and now is available under new name: %2 SQL statements conversion Following error occurred while converting SQL statements to the target SQLite version: Would you like to ignore those errors and proceed? DbDialog Database Database type Database driver Options Permanent (keep it in configuration) Test connection Create new database file File Name (on the list) <p>Enable this if you want the database to be stored in configuration file and restored every time SQLiteStudio is started.</p> aasfd Browse for existing database file on local computer Browse Enter an unique database name. This name is already in use. Please enter unique name. <p>Automatic name generation was disabled, becuase the name was edited manually. To restore automatic generation please erase contents of the name field.</p> Enter a database file path. This database is already on the list under name: %1 Select a database type. DbObjectDialogs Delete table Are you sure you want to delete table %1? Delete index Are you sure you want to delete index %1? Delete trigger Are you sure you want to delete trigger %1? Delete view Are you sure you want to delete view %1? Error while dropping %1: %2 Delete objects Are you sure you want to delete following objects: %1 Cannot start transaction. Details: %1 Cannot commit transaction. Details: %1 DbTree Databases Filter by name Copy Paste Select all Create a group Delete the group Rename the group Add a database Edit the database Remove the database Connect to the database Disconnect from the database Import Export the database Convert database type Vacuum Integrity check Create a table Edit the table Delete the table Export the table Import into the table Populate table Create similar table Reset autoincrement sequence Create an index Edit the index Delete the index Create a trigger Edit the trigger Delete the trigger Create a view Edit the view Delete the view Add a column Edit the column Delete the column Delete selected items Clear filter Refresh all database schemas Refresh selected database schema Erase table data Database Grouping Generate query for table Create group Group name Entry with name %1 already exists in group %2. Delete group Are you sure you want to delete group %1? All objects from this group will be moved to parent group. Are you sure you want to remove database '%1' from the list? Are you sure you want to remove following databases from the list: %1 Remove database Vacuum (%1) Autoincrement value for table '%1' has been reset successfully. Are you sure you want to delete all data from table(s): %1? Cannot import, because no import plugin is loaded. Cannot export, because no export plugin is loaded. Integrity check (%1) Reset autoincrement Are you sure you want to reset autoincrement value for table '%1'? An error occurred while trying to reset autoincrement value for table '%1': %2 An error occurred while trying to delete data from table '%1': %2 All data has been deleted for table '%1'. Following objects will be deleted: %1. Following databases will be removed from list: %1. Remainig objects from deleted group will be moved in place where the group used to be. %1<br><br>Are you sure you want to continue? Delete objects DbTreeItemDelegate error dbtree labels (system table) database tree label (virtual) virtual table label (system index) database tree label DbTreeModel Database: %1 dbtree tooltip Version: dbtree tooltip File size: dbtree tooltip Encoding: dbtree tooltip Error: dbtree tooltip Table : %1 dbtree tooltip Columns (%1): dbtree tooltip Indexes (%1): dbtree tooltip Triggers (%1): dbtree tooltip Copy Move Include data Include indexes Include triggers Abort Could not add dropped database file '%1' automatically. Manual setup is necessary. Referenced tables Do you want to include following referenced tables as well: %1 Name conflict Following object already exists in the target database. Please enter new, unique name, or press '%1' to abort the operation: SQL statements conversion Following error occurred while converting SQL statements to the target SQLite version: Would you like to ignore those errors and proceed? DdlHistoryWindow Filter by database: -- Queries executed on database %1 (%2) -- Date and time of execution: %3 %4 DDL history DdlPreviewDialog Queries to be executed Don't show again DebugConsole SQLiteStudio Debug Console EditorWindow Query History Results in the separate tab Results below the query SQL editor %1 Results Execute query Explain query Clear execution history sql editor Export results sql editor Create view from query sql editor Previous database Next database Show next tab sql editor Show previous tab sql editor Focus results below sql editor Focus SQL editor above sql editor Active database (%1/%2) Query finished in %1 second(s). Rows affected: %2 Query finished in %1 second(s). Clear execution history Are you sure you want to erase the entire SQL execution history? This cannot be undone. Cannot export, because no export plugin is loaded. No database selected in the SQL editor. Cannot create a view for unknown database. Editor window "%1" has uncommitted data. ErrorsConfirmDialog Errors Following errors occured: Would you like to proceed? ExportDialog Export What do you want to export? A database A single table Query results Table to export Database Table Options When this option is unchecked, then only table DDL (CREATE TABLE statement) is exported. Export table data Export table indexes Export table triggers Note, that exporting table indexes and triggers may be unsupported by some output formats. Select database objects to export Export data from tables Select all Deselect all Database: Query to export results for Query to be executed for results: Export format and options Export format Output Exported file path Clipboard File Exported text encoding: Export format options Cancel Select database to export. Select table to export. Enter valid query to export. Select at least one object to export. You must provide a file name to export to. Path you provided is an existing directory. You cannot overwrite it. The directory '%1' does not exist. The file '%1' exists and will be overwritten. All files (*) Pick file to export to Internal error during export. This is a bug. Please report it. FontEdit Choose font font configuration Form Active SQL formatter plugin FormView Commit row form view Rollback row form view First row form view Previous row form view Next row form view Last row form view Insert new row form view Delete current row form view FunctionsEditor Filter funtions Function name: Implementation language: Type: Input arguments Undefined Databases Register in all databases Register in following databases: Initialization code: Function implementation code: Final step implementation code: SQL function editor Commit all function changes Rollback all function changes Create new function Delete selected function Custom SQL functions manual Add function argument Rename function argument Delete function argument Move function argument up Move function argument down Scalar Aggregate Enter a non-empty, unique name of the function. Pick the implementation language. Per step code: Enter a non-empty implementation code. argument new function argument name in function editor window Functions editor window has uncommitted modifications. ImportDialog Import data Table to import to Table Database Data source to import from Data source type Options Input file: Text encoding: <p>If enabled, any constraint violation, or invalid data format (wrong column count), or any other problem encountered during import will be ignored and the importing will be continued.</p> Ignore errors Data source options Cancel If you type table name that doesn't exist, it will be created. Enter the table name Select import plugin. You must provide a file to import from. The file '%1' does not exist. Path you provided is a directory. A regular file is required. Pick file to import from IndexDialog Index On table: Index name: Partial index condition Unique index Column Collation Sort Delete selected indexed expression Moves selected index column up in the order, making it more significant in the index. Moves selected index column down in the order, making it less significant in the index. Edit selected indexed expression Add indexed expression DDL Tried to open index dialog for closed or inexisting database. Could not process index %1 correctly. Unable to open an index dialog. Unique index cannot have indexed expressions. Either remove expressions from list below, or uncheck this option. Pick the table for the index. Select at least one column. Enter a valid condition. default index dialog Sort order table constraints Error index dialog Cannot create unique index, because values in selected columns are not unique. Would you like to execute SELECT query to see problematic values? An error occurred while executing SQL statements: %1 IndexExprColumnDialog Indexed expression Expression to index This expression is already indexed by the index. Column should be indexed directly, not by expression. Either extend this expression to contain something more than just column name, or abort and select this column in index dialog directly. Column '%1' does not belong to the table covered by this index. Indexed expressions can refer only to columns from the indexed table. It's forbidden to use 'SELECT' statements in indexed expressions. Enter an indexed expression. Invalid expression. LanguageDialog Language Please choose language: MainWindow Database toolbar Structure toolbar Tools Window list View toolbar Configuration widgets Syntax highlighting engines Data editors Running in debug mode. Press %1 or use 'Help / Open debug console' menu entry to open the debug console. Running in debug mode. Debug messages are printed to the standard output. You need to restart application to make the language change take effect. Open SQL editor Open DDL history Open SQL functions editor Open collations editor Import Export Open configuration dialog Tile windows Tile windows horizontally Tile windows vertically Cascade windows Next window Previous window Hide status field Close selected window Close all windows but selected Close all windows Restore recently closed window Rename selected window Open Debug Console Open CSS Console Report a bug Propose a new feature About Licenses Open home page Open forum page User Manual SQLite documentation Report history Check for updates Database menubar Structure menubar View menubar Window list menubar view menu Tools menubar Help Could not set style: %1 main window Cannot export, because no export plugin is loaded. Cannot import, because no import plugin is loaded. Rename window Enter new name for the window: New updates are available. <a href="%1">Click here for details</a>. You're running the most recent version. No updates are available. Database passed in command line parameters (%1) was already on the list under name: %2 Database passed in command line parameters (%1) has been temporarily added to the list under name: %2 Could not add database %1 to list. MdiWindow Uncommitted changes Close anyway Don't close MultiEditor Null value multieditor Configure editors for this data type Data editor plugin '%1' not loaded, while it is defined for editing '%1' data type. Deleted multieditor Read only multieditor MultiEditorBool Boolean MultiEditorDate Date MultiEditorDateTime Date & time MultiEditorHex Hex MultiEditorNumeric Number numeric multi editor tab name MultiEditorText Text Tab changes focus Cut Copy Paste Delete Undo Redo MultiEditorTime Time NewConstraintDialog New constraint Primary Key new constraint dialog Foreign Key new constraint dialog Unique new constraint dialog Check new constraint dialog Not NULL new constraint dialog Collate new constraint dialog Default new constraint dialog NewVersionDialog SQLiteStudio updates New updates are available! Component Current version Update version Check for updates on startup Update to new version! The update will be automatically downloaded and installed. This will also restart application at the end. Not now. Don't install the update and close this window. PopulateConfigDialog Populating configuration Configuring <b>%1</b> for column <b>%2</b> PopulateDialog Populate table Database Table Columns Number of rows to populate: Populate populate dialog button Abort Configure Populating configuration for this column is invalid or incomplete. Select database with table to populate Select table to populate You have to select at least one column. QObject Cannot edit columns that are result of compound %1 statements (one that includes %2, %3 or %4 keywords). The query execution mechanism had problems with extracting ROWID's properly. This might be a bug in the application. You may want to report this. Requested column is a result of SQL expression, instead of a simple column selection. Such columns cannot be edited. Requested column belongs to restricted SQLite table. Those tables cannot be edited directly. Cannot edit results of query other than %1. Cannot edit columns that are result of aggregated %1 statements. Cannot edit columns that are result of %1 statement. Cannot edit columns that are result of common table expression statement (%1). on conflict: %1 data view tooltip references table %1, column %2 data view tooltip condition: %1 data view tooltip collation name: %1 data view tooltip Data grid view Copy cell(s) contents to clipboard Paste cell(s) contents from clipboard Set empty value to selected cell(s) Set NULL value to selected cell(s) Commit changes to cell(s) contents Rollback changes to cell(s) contents Delete selected data row Insert new data row Open contents of selected cell in a separate editor Total pages available: %1 Total rows loaded: %1 Data view (both grid and form) Refresh data Switch to grid view of the data Switch to form view of the data Database list Delete selected item Clear filter contents Refresh schema Refresh all schemas Add database Select all items Copy selected item(s) Paste from clipboard Tables Indexes Triggers Views Columns Data form view Commit changes for current row Rollback changes for current row Go to first row on current page Go to next row Go to previous row Go to last row on current page Insert new row Delete current row Main window Open SQL editor Previous window Next window Hide status area Open configuration dialog Open Debug Console Open CSS Console Cell text value editor Cut selected text Copy selected text Delete selected text Undo Redo SQL editor input field Select whole editor contents Save contents into a file Load contents from a file Find in text Find next Find previous Replace in text Delete current line Request code assistant Format contents Move selected block of text one line down Move selected block of text one line up Copy selected block of text and paste it a line below Copy selected block of text and paste it a line above Toggle comment All SQLite databases All files Database file Reports history window Delete selected entry SQL editor window Execute query Execute "%1" query Switch current working database to previous on the list Switch current working database to next on the list Go to next editor tab Go to previous editor tab Move keyboard input focus to the results view below Move keyboard input focus to the SQL editor above Table window Refresh table structure Add new column Edit selected column Delete selected column Export table data Import data to the table Add new table constraint Edit selected table constraint Delete selected table constraint Refresh table index list Add new index Edit selected index Delete selected index Refresh table trigger list Add new trigger Edit selected trigger Delete selected trigger Go to next tab Go to previous tab A view window Refresh view trigger list QuitConfirmDialog Uncommitted changes Are you sure you want to quit the application? Following items are pending: SearchTextDialog Find or replace Find: Case sensitive Search backwards Regular expression matching Replace && find next Replace with: Replace all Find SortDialog Sort by columns Column Order Sort by: %1 Move column up Move column down SqlEditor Cut sql editor Copy sql editor Paste sql editor Delete sql editor Select all sql editor Undo sql editor Redo sql editor Complete sql editor Format SQL sql editor Save SQL to file sql editor Select file to save SQL sql editor Load SQL from file sql editor Delete line sql editor Move block down sql editor Move block up sql editor Copy block down sql editor Copy up down sql editor Find sql editor Find next sql editor Find previous sql editor Replace sql editor Toggle comment sql editor Saved SQL contents to file: %1 Syntax completion can be used only when a valid database is set for the SQL editor. Contents of the SQL editor are huge, so errors detecting and existing objects highlighting are temporarily disabled. Save to file Could not open file '%1' for writing: %2 SQL scripts (*.sql);;All files (*) Open file Could not open file '%1' for reading: %2 Reached the end of document. Hit the find again to restart the search. SqlQueryItem Column: data view tooltip Data type: data view Table: data view tooltip Constraints: data view tooltip Cannot load the data for a cell that refers to the already closed database. SqlQueryItemDelegate The row is marked for deletion. Cannot edit this cell. Details: %1 Structure of this table has changed since last data was loaded. Reload the data to proceed. Editing a huge contents in an inline cell editor is not a good idea. It can become slow and inconvenient. It's better to edit such big contents in a Form View, or in popup editor (available under rick-click menu). Foreign key for column %2 has more than %1 possible values. It's too much to display in drop down list. You need to edit value manually. SqlQueryModel Only one query can be executed simultaneously. Cannot commit the data for a cell that refers to the already closed database. Could not begin transaction on the database. Details: %1 An error occurred while rolling back the transaction: %1 Tried to commit a cell which is not editable (yet modified and waiting for commit)! This is a bug. Please report it. Uncommitted data There are uncommitted data changes. Do you want to proceed anyway? All uncommitted changes will be lost. An error occurred while committing the transaction: %1 An error occurred while committing the data: %1 Error while executing SQL query on database '%1': %2 Error while loading query results: %1 Insert multiple rows Number of rows to insert: SqlQueryView Go to referenced row in... Copy Copy as... Paste Paste as... Set NULL values Erase values Edit value in editor Commit Rollback Commit selected cells Rollback selected cells Define columns to sort by Remove custom sorting Insert row Insert multiple rows Delete selected row Generate query for selected cells No items selected to paste clipboard contents to. Go to referenced row in table '%1' table '%1' Referenced row (%1) Edit value SqlTableModel Error while committing new row: %1 Error while deleting row from table %1: %2 StatusField Status Copy Clear TableConstraintsModel Type table constraints Details table constraints Name table constraints TableForeignKeyPanel Foreign table: SQLite 2 does not support foreign keys officially, but it's okay to use them anyway. Columns Local column Foreign column Reactions Deferred foreign key Named constraint Constraint name Pick the foreign column. Pick the foreign table. Select at least one foreign column. Enter a name of the constraint. Foreign column table constraints TablePrimaryKeyAndUniquePanel Columns Column Collation Sort Valid only for a single column with INTEGER data type Autoincrement Named constraint Constraint name On conflict Collate table constraints Sort order table constraints Select at least one column. Enter a name of the constraint. TableStructureModel Name table structure columns Data type table structure columns Primary Key table structure columns Foreign Key table structure columns Unique table structure columns Check table structure columns Not NULL table structure columns Collate table structure columns Default value table structure columns TableWindow Structure Table name: Data Constraints Indexes Triggers DDL Export table table window Import data to table table window Populate table table window Refresh structure table window Commit structure changes table window Rollback structure changes table window Add column table window Edit column table window Delete column table window Move column up table window Move column down table window Create similar table table window Reset autoincrement value table window Add table constraint table window Edit table constraint table window Delete table constraint table window Move table constraint up table window Move table constraint down table window Add table primary key table window Add table foreign key table window Add table unique constraint table window Add table check constraint table window Refresh index list table window Create index table window Edit index table window Delete index table window Refresh trigger list table window Create trigger table window Edit trigger table window Delete trigger table window Are you sure you want to delete column '%1'? table window Following problems will take place while modifying the table. Would you like to proceed? table window Table modification table window Could not load data for table %1. Error details: %2 Could not process the %1 table correctly. Unable to open a table window. Could not restore window %1, because no database or table was stored in session for this window. Could not restore window '%1', because no database or table was stored in session for this window. Could not restore window '%1', because database %2 could not be resolved. Could not restore window '%1'', because the table %2 doesn't exist in the database %3. New table %1 Committed changes for table '%1' successfully. Committed changes for table '%1' (named before '%2') successfully. Autoincrement value for table '%1' has been reset successfully. Uncommitted changes There are uncommitted structure modifications. You cannot browse or edit data until you have table structure settled. Do you want to commit the structure, or do you want to go back to the structure tab? Table window "%1" has uncommitted structure modifications and data. Table window "%1" has uncommitted data. Table window "%1" has uncommitted structure modifications. Could not commit table structure. Error message: %1 table window Reset autoincrement Are you sure you want to reset autoincrement value for table '%1'? An error occurred while trying to reset autoincrement value for table '%1': %2 Empty name A blank name for the table is allowed in SQLite, but it is not recommended. Are you sure you want to create a table with blank name? Cannot create a table without at least one column. Cannot create table %1, if it has no primary key defined. Either uncheck the %2, or define a primary key. Cannot use autoincrement for primary key when %1 clause is used. Either uncheck the %2, or the autoincrement in a primary key. Are you sure you want to delete table constraint '%1'? table window Delete constraint table window Cannot export, because no export plugin is loaded. Cannot import, because no import plugin is loaded. Go back to structure tab Commit modifications and browse data. Name table window indexes Unique table window indexes Columns table window indexes Partial index condition table window indexes Name table window triggers Event table window triggers Condition table window triggers Details table window triggers TriggerColumnsDialog Trigger columns Triggering columns: Select all Deselect all TriggerDialog Trigger On table: Action: <p>SQL condition that will be evaluated before the actual trigger code. In case the condition returns false, the trigger will not be fired for that row.</p> Pre-condition: The scope is still not fully supported by the SQLite database. Trigger name: When: List of columns for UPDATE OF action. Scope: Code: Trigger statements to be executed. DDL On view: Could not process trigger %1 correctly. Unable to open a trigger dialog. Enter a valid condition. Enter a valid trigger code. Error trigger dialog An error occurred while executing SQL statements: %1 VersionConvertSummaryDialog Database version convert Following changes to the SQL statements will be made: Before After ViewWindow Query View name: Output column names Data Triggers DDL Could not restore window '%1', because no database or view was stored in session for this window. Could not restore window '%1', because database %2 could not be resolved. Could not restore window '%1', because database %2 could not be open. Could not restore window '%1', because the view %2 doesn't exist in the database %3. New view %1 Refresh the view view window Commit the view changes view window Rollback the view changes view window Explicit column names Generate output column names automatically basing on result columns of the view. Add column view window Edit column view window Delete column view window Move column up view window Move column down view window Refresh trigger list view window Create new trigger view window Edit selected trigger view window Delete selected trigger view window View window "%1" has uncommitted structure modifications and data. View window "%1" has uncommitted data. View window "%1" has uncommitted structure modifications. Uncommitted changes There are uncommitted structure modifications. You cannot browse or edit data until you have the view structure settled. Do you want to commit the structure, or do you want to go back to the structure tab? Committed changes for view '%1' successfully. Committed changes for view '%1' (named before '%2') successfully. Could not load data for view %1. Error details: %2 Go back to structure tab Commit modifications and browse data. Could not commit view changes. Error message: %1 view window Override columns Currently defined columns will be overriden. Do you want to continue? Could not determinate columns returned from the view. The query is problably incomplete or contains errors. Name view window triggers Instead of view window triggers Condition view window triggers Details table window triggers Could not process the %1 view correctly. Unable to open a view window. Empty name A blank name for the view is allowed in SQLite, but it is not recommended. Are you sure you want to create a view with blank name? The SELECT statement could not be parsed. Please correct the query and retry. Details: %1 The view could not be modified due to internal SQLiteStudio error. Please report this! The view code could not be parsed properly for execution. This is a SQLiteStudio's bug. Please report it. Following problems will take place while modifying the view. Would you like to proceed? view window View modification view window WidgetCover Interrupt