Activity overview
Latest activity by Grimfellow
Spaces between values when using IN expression
Greetings, can someone advise how I can format an IN operator to exclude any spaces between the values as seen below? I checked the formatting style and currently the setting for add a space around...
Experiencing the same as well and running the latest version 10.12.2.28458. It runs for awhile then the database is locked messages start happening. Intellisense is disabled as suggested to no avail. SQL Prompt has also been reinstalled to no avail. Using the prior version I did not experience this. This was part of the log for the error: 2022-07-21 12:08:53.448 -04:00 [Error] Report error dialog UI shown code = Busy (5), message = System.Data.SQLite.SQLiteException (0x800007AF): database is locked database is locked at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior) at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery() at RedGate.SqlPrompt.TabHistory.DocumentStore.MarkDocumentOpen(Int64 documentId) at RedGate.SqlPrompt.TabHistory.Monitoring.TabWatcher.<>c__DisplayClass14_0.<OnDocumentOpened>b__0() at RedGate.SqlPrompt.UsageReporting.ErrorReporting.ErrorReporterWithUI.Do(Action action) 2022-07-21 12:08:56.775 -04:00 [Debug] Tab not reconnected for reason: Document not found for id / comments
Experiencing the same as well and running the latest version 10.12.2.28458. It runs for awhile then the database is locked messages start happening. Intellisense is disabled as suggested to no avai...
same as well, running the newest version / comments
same as well, running the newest version
Same here as well, updated this morning / comments
Same here as well, updated this morning