View Issue Details
973 [Sqlite Developer] DBA minor always 2009-08-05 21:56 2009-08-05 21:56
Null  
 
normal  
new 3.3.x  
open  
none    
none  
   
数据库连接语句的密码部分没有事用双引号引起
如果数据库密码中包含以下字符之一,见不能正确解析: { - 解决方法:密码前后加双引号, 原始的语句: Data Source=MyData.db;Pooling=true;FailIfMissing=false;Password=pwd 改进后的语句: Data Source=MyData.db;Pooling=true;FailIfMissing=false;Password="pwd"
There are no notes attached to this issue.





View Issue Details
1037 [Sqlite Developer] SQL Editor minor have not tried 2010-05-24 09:04 2010-05-27 11:35
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.7.x  
   
wrong line number was displayed(regression of 3.41)
wrong line number was displayed
There are no notes attached to this issue.





View Issue Details
841 [Sqlite Developer] DBA minor have not tried 2008-08-23 03:14 2009-06-08 20:53
sharpplus  
 
normal  
new  
open  
none    
none  
   
Write a SQL Profiler
Write a SQL Profiler
There are no notes attached to this issue.





View Issue Details
1003 [Sqlite Developer] DBA minor have not tried 2009-11-10 19:53 2009-11-10 19:53
sharpplus  
 
normal  
new  
open  
none    
none  
  3.5.x  
Windows Shell Integration: so that sqlite files when double-clicked open with sqlite developer
Windows Shell Integration: so that sqlite files when double-clicked open with sqlite developer
There are no notes attached to this issue.





View Issue Details
859 [Sqlite Developer] Schema Editor minor have not tried 2008-09-23 04:34 2008-09-23 04:35
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
   
When View autoindex_project3 of Sample DB ,there is a exception.
When View autoindex_project3 of Sample DB ,there is a exception.
There are no notes attached to this issue.





View Issue Details
336 [Sqlite Developer] DBA minor always 2005-11-14 07:46 2005-11-20 00:21
user2  
user2  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
when the dataset was not in the insert or edit mode , the post button was still enabled
when the dataset was not in the insert or edit mode , the post button was still enabled
There are no notes attached to this issue.





View Issue Details
267 [Sqlite Developer] Parser minor always 2005-10-08 22:01 2005-10-29 13:11
user2  
user2  
normal  
closed  
fixed  
none    
none 0.97Alpha1  
   
when rollback automaticlly refresh the Db Explorer
when rollback automaticlly refresh the Db Explorer
There are no notes attached to this issue.





View Issue Details
308 [Sqlite Developer] DBA minor always 2005-10-31 06:44 2005-11-06 04:19
user2  
user2  
normal  
closed  
fixed  
none    
none 1.02Alpha2  
   
when pk's is autoincrement, automaticlly set Data Type to integer
when pk's is autoincrement, automaticlly set Data Type to integer
There are no notes attached to this issue.





View Issue Details
419 [Sqlite Developer] SQL Editor minor always 2006-04-02 06:15 2006-04-02 06:15
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.2RC2  
   
when paste code from clipboard often popup autocomplete window
when paste code from clipboard often popup autocomplete window
There are no notes attached to this issue.





View Issue Details
528 [Sqlite Developer] Parser minor always 2006-08-19 20:52 2006-08-20 02:28
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.0  
   
when parse multi sql sepearted by semicolon, create trigger statement will be parsed incorrectly(Introduced in ver1.89)
when parse multi sql sepearted by semicolon, create trigger statement will be parsed incorrectly(Introduced in ver1.89)
There are no notes attached to this issue.





View Issue Details
827 [Sqlite Developer] crash always 2008-08-11 01:24 2008-08-12 12:42
Ouch  
 
normal  
closed 2.9  
fixed  
none    
none 3.0.x  
  3.0.x  
When opening database, an error "Could not load SQLite library(sqlite3.dll)"
When opening database, an error "Could not load SQLite library(sqlite3.dll)" in Ver 2.9.0 and 2.9.1.
The issue appears in windows xp sp3 and sp2. I've tried to replace the sqlite3.dll with the same file come with ver 2.8.8 then it works well.
1.jpg (74,136) 2008-08-11 01:24
http://mantis.sharpplus.com/file_download.php?file_id=9&type=bug
jpg
Notes
(0000213)
sharpplus   
2008-08-11 03:36   
(edited on: 2008-08-11 03:38)
Sorry, I can not reproduce the problem, would you tell me the dll size of sqlite3.dll which can not be loaded. By the way , did you tried to uninstall all the previous version and reinstall the sqlite deveoper 2.91?
(0000214)
sharpplus   
2008-08-12 07:38   
I know the problem was caused by vc2005 runtime library msvcr80.dll





View Issue Details
629 [Sqlite Developer] DBA minor have not tried 2007-04-21 09:23 2007-04-21 09:23
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
when open a new registered database will report error(Introduced in 2.59)
when open a new registered database will report error
There are no notes attached to this issue.





View Issue Details
351 [Sqlite Developer] DBA minor always 2005-11-20 10:29 2005-11-23 01:07
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
when one sql execute failed ,the cursor always hourglass
when one sql execute failed ,the cursor always hourglass
There are no notes attached to this issue.





View Issue Details
488 [Sqlite Developer] SQL Editor minor always 2006-07-12 11:35 2006-07-12 11:55
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.8  
   
when one sql execute failed , all the next sql will fail to get result without opening a new sql editor.
when one sql execute failed , all the next sql will fail to get result without opening a new sql editor.
There are no notes attached to this issue.





View Issue Details
600 [Sqlite Developer] SQL Editor minor have not tried 2007-02-12 20:17 2007-03-18 02:37
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
when invoking chinese input method, the keyword autocomplete was incorrectly popped up
when invoking chinese input method, the keyword autocomplete was popped up incorrectly
There are no notes attached to this issue.





View Issue Details
543 [Sqlite Developer] Export/Import minor always 2006-09-10 05:48 2006-09-14 06:23
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.2  
   
when exporting data with '"' char as sql, generated wrong insert sql
when exporting data with '"' char as sql, generated wrong insert sql
There are no notes attached to this issue.





View Issue Details
576 [Sqlite Developer] DBA minor always 2006-10-14 04:05 2006-10-14 04:06
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.3  
   
When executing select current_date return multi records
When executing select current_date return multi records
There are no notes attached to this issue.





View Issue Details
461 [Sqlite Developer] GUI minor always 2006-06-24 08:42 2006-06-24 08:42
sharpplus  
 
normal  
new  
open  
none    
none  
   
when executing a long-time query, the close db etc context menu items should be disabled
when executing a long-time query, the close db etc context menu items should be disabled
There are no notes attached to this issue.





View Issue Details
487 [Sqlite Developer] DBA minor always 2006-07-12 10:07 2006-07-12 10:20
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.8  
   
when execute create schema sql or some other sql, always show Error message: near "limit": syntax error.
when execute create schema sql or some other sql, always show Error message: near "limit": syntax error.
There are no notes attached to this issue.





View Issue Details
707 [Sqlite Developer] DBA minor have not tried 2007-12-29 20:19 2008-01-12 00:17
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
  2.8  
When edit temp table, the temporary checkbox was not checked
When edit temp table, the temporary checkbox was not checked
There are no notes attached to this issue.





View Issue Details
320 [Sqlite Developer] DBA minor always 2005-11-06 01:19 2005-11-06 04:23
user2  
user2  
normal  
closed  
fixed  
none    
none 1.02Alpha2  
   
when edit table , grid shows xxx(1,2) datatype as xxx uncorrectly
when edit table , grid shows xxx(1,2) datatype as xxx uncorrectly
There are no notes attached to this issue.





View Issue Details
758 [Sqlite Developer] Schema Editor minor have not tried 2008-02-04 09:39 2008-02-12 07:56
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
When create trigger and index for attached database table, the trigger will be created in main database
When create trigger for attached database table, the trigger will be created in main database
There are no notes attached to this issue.





View Issue Details
507 [Sqlite Developer] SQL Editor minor always 2006-07-27 09:15 2006-07-29 09:47
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.9  
   
when create sql editor , set database to dbexplorer current selected database
when create sql editor , set database to dbexplorer current selected database
There are no notes attached to this issue.





View Issue Details
858 [Sqlite Developer] Schema Editor minor have not tried 2008-09-23 04:33 2008-09-23 04:33
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
   
When closing the virtual Table View Form, the save changes messagebox popped up. (regression of 2.94)
When closing the virtual Table View Form, the save changes messagebox popped up. (regression of 2.94)
There are no notes attached to this issue.





View Issue Details
395 [Sqlite Developer] GUI minor always 2006-01-06 06:38 2006-01-06 08:31
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.1RC1  
   
when click the empty area in database schema tree of Extract Schema Dialog , AV was raised.
when click the empty area in database schema tree of Extract Schema Dialog , AV was raised.
There are no notes attached to this issue.





View Issue Details
754 [Sqlite Developer] GUI minor have not tried 2008-02-03 05:00 2008-02-03 07:56
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
When click enter in filter edit , will jump to focus the first matched object
When click enter in filter edit , will jump to focus the first matched object
There are no notes attached to this issue.





View Issue Details
221 [Sqlite Developer] SQL Editor minor always 2005-09-15 08:57 2005-09-29 06:32
user2  
user2  
normal  
closed  
fixed  
none    
none 0.89  
   
when clear sql monitor does not clear the sql edit
when clear sql monitor does not clear the sql edit
There are no notes attached to this issue.





View Issue Details
632 [Sqlite Developer] Schema Editor minor have not tried 2007-04-23 21:19 2007-04-27 21:45
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
when change trigger event from instead of to after, the on list was not changed to table list
when change trigger event from instead of to after, the on list was not changed to table list
There are no notes attached to this issue.





View Issue Details
578 [Sqlite Developer] DBA minor always 2006-10-20 21:56 2006-10-21 08:23
sharpplus  
 
normal  
closed  
fixed  
none    
none  
   
Virtual Table appear in table list
Virtual Table appear in table list
There are no notes attached to this issue.





View Issue Details
518 [Sqlite Developer] DBA minor always 2006-08-05 10:18 2006-08-05 10:19
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.0  
   
View Data as Html
View Data as Html
There are no notes attached to this issue.





View Issue Details
1014 [Sqlite Developer] SQL Editor major always 2009-11-30 17:17 2009-12-10 10:46
Gillissie Windows  
sharpplus Vista 64 bit  
urgent  
closed  
fixed  
none    
none 3.5.x  
  3.5.x  
view code cut off when using UNION
When creating a view that uses a UNION in the query, query the view works as expected. But when you go back in to edit the view, the query text is cut off after the first part of the query. Everything from the UNION and below is missing. If you update again, it is permanently missing. version 3.5.7.435
Create any view with a UNION, save it, then edit the view to see the UNION part missing. For example, in a view named TestView: SELECT 1 UNION SELECT 2 Now query the view to verify the UNION works: SELECT * FROM TestView Now edit the view to only see: SELECT 1
Notes
(0000256)
sharpplus   
2009-12-06 08:36   
Thank you for your bug report. I will check it as soon as possible
(0000257)
sharpplus   
2009-12-10 10:46   
I just fixed the bug. please try with the latest version http://www.sqlitedeveloper.com/downloads/SqliteDev358.zip





View Issue Details
111 [Sqlite Developer] DBA feature always 2005-07-31 12:35 2005-09-29 06:32
user2  
user2  
normal  
closed  
fixed  
none    
none 0.89  
   
View and Edit Blobl Field
View and Edit Blobl Field
There are no notes attached to this issue.





View Issue Details
828 [Sqlite Developer] DBA minor have not tried 2008-08-11 22:24 2008-08-11 22:24
sharpplus  
 
normal  
new  
open  
none    
none  
   
use new profile api to profile the performance of sql
use new profile api to profile the performance of sql
There are no notes attached to this issue.





View Issue Details
917 [Sqlite Developer] Unicode minor have not tried 2009-02-15 22:41 2009-02-15 22:41
sharpplus  
 
normal  
new  
open  
none    
none  
   
use like to query asia data
use like to query asia data
There are no notes attached to this issue.





View Issue Details
359 [Sqlite Developer] DBA minor always 2005-11-24 21:21 2005-11-24 21:21
sharpplus  
 
normal  
new  
open  
none    
none  
   
use keyboard can move the cursor to primary key when alter table
use keyboard can move the cursor to primary key when alter table
There are no notes attached to this issue.





View Issue Details
781 [Sqlite Developer] Export/Import minor have not tried 2008-02-16 07:01 2008-03-09 08:43
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
Use DiagramExpress as the mapping gui
Use DiagramExpress as the mapping gui
There are no notes attached to this issue.





View Issue Details
780 [Sqlite Developer] Query Builder minor have not tried 2008-02-16 07:01 2008-03-02 09:21
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
Use Diagram Express as main gui
Use Diagram Express to main gui
There are no notes attached to this issue.





View Issue Details
837 [Sqlite Developer] Export/Import minor have not tried 2008-08-19 02:41 2008-08-19 02:41
sharpplus  
 
normal  
new  
open  
none    
none  
  3.2.x  
use delete key to delete the link
use delete key to delete the link
There are no notes attached to this issue.





View Issue Details
477 [Sqlite Developer] GUI minor always 2006-07-01 14:57 2006-07-01 14:57
sharpplus  
 
normal  
new  
open  
none    
none  
   
use checkbox to display the asc , desc for index edit form
use checkbox to display the asc , desc for index edit form
There are no notes attached to this issue.





View Issue Details
803 [Antlr For Delphi Target] General minor have not tried 2008-07-19 21:35 2008-08-13 08:53
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.1  
  3.1  
Use AttributeRender to split long string to str+str format
Use AttributeRender to lowercase all typename and convert long string to str+str format
There are no notes attached to this issue.





View Issue Details
846 [Sqlite Developer] DBA minor have not tried 2008-09-03 12:28 2008-09-06 02:07
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
  3.0.x  
upgrade to sqlite 3.62
upgrade to sqlite 3.62
There are no notes attached to this issue.





View Issue Details
892 [Sqlite Developer] DBA minor have not tried 2008-12-17 07:18 2008-12-19 21:43
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.2.x  
  3.2.x  
Upgrade to sqlite 3.6.7
Upgrade to sqlite 3.6.7
There are no notes attached to this issue.





View Issue Details
884 [Sqlite Developer] DBA minor have not tried 2008-11-13 10:08 2008-11-20 10:36
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.1.x  
  3.1.x  
Upgrade to sqlite 3.6.6
Upgrade to sqlite 3.6.6
There are no notes attached to this issue.





View Issue Details
878 [Sqlite Developer] DBA minor have not tried 2008-10-24 00:31 2008-10-24 00:32
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.1.x  
   
upgrade to sqlite 3.6.4
upgrade to sqlite 3.6.4
There are no notes attached to this issue.





View Issue Details
860 [Sqlite Developer] DBA minor have not tried 2008-09-23 04:35 2008-09-23 04:35
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
   
Upgrade to SQLite 3.6.3
Upgrade to SQLite 3.6.3
There are no notes attached to this issue.





View Issue Details
1023 [Sqlite Developer] DBA minor have not tried 2010-03-10 10:20 2010-03-30 08:23
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.6.x  
  3.6.x  
upgrade to sqlite 3.6.23.1
upgrade to sqlite 3.6.23.1
There are no notes attached to this issue.





View Issue Details
1016 [Sqlite Developer] DBA minor have not tried 2010-01-08 02:32 2010-01-08 09:22
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.5.x  
  3.5.x  
upgrade to sqlite 3.6.22
upgrade to sqlite 3.6.22
There are no notes attached to this issue.





View Issue Details
1015 [Sqlite Developer] DBA minor have not tried 2009-12-08 19:40 2009-12-09 08:47
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.5.x  
  3.5.x  
Upgrade to sqlite 3.6.21
Upgrade to sqlite 3.6.21
There are no notes attached to this issue.





View Issue Details
998 [Sqlite Developer] DBA minor have not tried 2009-11-04 18:10 2009-11-05 09:28
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.5.x  
  3.5.x  
upgrade to sqlite 3.6.20
upgrade to sqlite 3.6.20
There are no notes attached to this issue.





View Issue Details
989 [Sqlite Developer] DBA minor have not tried 2009-10-14 11:48 2009-10-16 10:34
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.5.x  
  3.5.x  
upgrade to sqlite 3.6.19
upgrade to sqlite 3.6.19
There are no notes attached to this issue.





View Issue Details
979 [Sqlite Developer] DBA minor have not tried 2009-09-12 06:33 2009-09-13 03:19
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.5.x  
  3.5.x  
upgrade to sqlite 3.6.18
upgrade to sqlite 3.6.18
There are no notes attached to this issue.





View Issue Details
976 [Sqlite Developer] DBA minor have not tried 2009-08-11 01:16 2009-08-11 10:47
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
upgrade to sqlite 3.6.17
upgrade to sqlite 3.6.17
There are no notes attached to this issue.





View Issue Details
965 [Sqlite Developer] DBA minor have not tried 2009-06-15 09:00 2009-06-27 19:35
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
upgrade to sqlite 3.6.16
upgrade to sqlite 3.6.16
There are no notes attached to this issue.





View Issue Details
961 [Sqlite Developer] DBA minor have not tried 2009-05-19 02:48 2009-05-27 09:19
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
upgrade to sqlite 3.6.14.2
upgrade to sqlite 3.6.14.2
There are no notes attached to this issue.





View Issue Details
958 [Sqlite Developer] DBA minor have not tried 2009-05-07 02:19 2009-05-07 03:21
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
upgrade to sqlite 3.6.14
upgrade to sqlite 3.6.14
There are no notes attached to this issue.





View Issue Details
952 [Sqlite Developer] DBA minor have not tried 2009-04-13 05:59 2009-04-13 09:46
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.3.x  
  3.3.x  
upgrade to sqlite 3.6.13
upgrade to sqlite 3.6.13
There are no notes attached to this issue.





View Issue Details
935 [Sqlite Developer] DBA minor have not tried 2009-03-31 09:35 2009-04-04 00:40
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.3.x  
  3.3.x  
Upgrade to sqlite 3.6.12
Upgrade to sqlite 3.6.12
There are no notes attached to this issue.





View Issue Details
919 [Sqlite Developer] Data Access Component minor have not tried 2009-02-17 19:40 2009-02-20 21:53
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.2.x  
  3.2.x  
upgrade to sqlite 3.6.11
upgrade to sqlite 3.6.11
Notes
(0000227)
sharpplus   
2009-02-19 07:37   
Upgrade parser to adopt the new change of fallback





View Issue Details
896 [Sqlite Developer] DBA minor have not tried 2009-01-13 04:44 2009-01-17 01:49
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.2.x  
  3.2.x  
upgrade to sqlite 3.6.10
upgrade to sqlite 3.6.10
There are no notes attached to this issue.





View Issue Details
825 [Sqlite Developer] DBA minor have not tried 2008-08-06 23:34 2008-08-11 05:53
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
  3.0.x  
Upgrade to sqlite 3.6.1
Upgrade to sqlite 3.6.1
There are no notes attached to this issue.





View Issue Details
702 [Sqlite Developer] DBA minor have not tried 2007-12-02 06:02 2007-12-15 22:20
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
   
Upgrade to sqlite 3.5.4 and integrate fts3
Upgrade to sqlite 3.5.4 and integrate fts3
There are no notes attached to this issue.





View Issue Details
696 [Sqlite Developer] DBA minor have not tried 2007-11-10 22:09 2007-11-10 22:09
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
   
Upgrade to sqlite 3.5.2
Upgrade to sqlite 3.5.2
There are no notes attached to this issue.





View Issue Details
691 [Sqlite Developer] DBA minor have not tried 2007-11-03 09:53 2007-11-03 09:54
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
   
Upgrade to sqlite 3.5.1
Upgrade to sqlite 3.5.1
There are no notes attached to this issue.





View Issue Details
663 [Sqlite Developer] DBA minor have not tried 2007-07-23 21:07 2007-07-23 22:15
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
   
Upgrade to sqlite 3.4.1
Upgrade to sqlite 3.4.1
There are no notes attached to this issue.





View Issue Details
656 [Sqlite Developer] DBA minor have not tried 2007-07-07 04:55 2007-07-07 04:55
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
Upgrade to sqlite 3.4.0
Upgrade to sqlite 3.4.0
There are no notes attached to this issue.





View Issue Details
634 [Sqlite Developer] DBA minor have not tried 2007-04-27 07:37 2007-04-27 07:38
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
Upgrade to sqlite 3.3.17
Upgrade to sqlite 3.3.17
There are no notes attached to this issue.





View Issue Details
627 [Sqlite Developer] DBA minor have not tried 2007-04-21 08:45 2007-04-21 08:45
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
Upgrade to sqlite 3.3.16
Upgrade to sqlite 3.3.16
There are no notes attached to this issue.





View Issue Details
816 [Sqlite Developer] minor have not tried 2008-08-03 00:06 2008-08-11 05:22
sharpplus  
 
normal  
closed  
fixed  
none    
none  
  3.0.x  
Upgrade to new jcl and jvcl
Upgrade to new jcl and jvcl
There are no notes attached to this issue.





View Issue Details
975 [Sqlite Developer] Other minor have not tried 2009-08-08 08:24 2009-08-08 08:25
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
upgrade System.Data.SQLite encrypted database support to 1.0.65
upgrade System.Data.SQLite encrypted database support to 1.0.65
There are no notes attached to this issue.





View Issue Details
386 [Sqlite Developer] Component minor always 2005-12-14 20:28 2006-02-23 10:13
sharpplus  
 
normal  
closed  
fixed  
none    
none  
   
Upgrade Synedit Sqlite Components, Jvcl.
Upgrade Synedit Sqlite Components, Jvcl.
Notes
(0000045)
sharpplus   
2006-01-07 03:05   
Upgrade the synedit unicode version
(0000046)
sharpplus   
2006-01-30 09:38   
upgrade sqlite components
(0000047)
sharpplus   
2006-02-22 21:09   
upgrade tntware





View Issue Details
668 [Sqlite Developer] SQL Editor minor have not tried 2007-07-31 10:49 2007-08-05 08:06
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
   
Upgrade Synedit
Upgrade Synedit
There are no notes attached to this issue.





View Issue Details
604 [Sqlite Developer] DBA minor have not tried 2007-02-15 22:31 2007-02-15 22:39
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.5  
   
Upgrade Sqlite, fts1, fts2 to 3.3.13
Upgrade Sqlite, fts1, fts2 to 3.3.13
There are no notes attached to this issue.





View Issue Details
792 [Sqlite Developer] DBA minor have not tried 2008-04-16 23:56 2008-04-19 08:34
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
upgrade sqlite to 3.5.9
upgrade sqlite to 3.5.8
There are no notes attached to this issue.





View Issue Details
791 [Sqlite Developer] DBA minor have not tried 2008-03-17 19:26 2008-03-18 09:48
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
upgrade sqlite to 3.5.7
upgrade sqlite to 3.5.7
There are no notes attached to this issue.





View Issue Details
761 [Sqlite Developer] DBA minor have not tried 2008-02-06 20:21 2008-02-07 09:49
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
upgrade sqlite to 3.5.6
upgrade sqlite to 3.5.6
There are no notes attached to this issue.





View Issue Details
751 [Sqlite Developer] DBA minor have not tried 2008-01-31 23:49 2008-02-01 09:58
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
upgrade sqlite to 3.5.5
upgrade sqlite to 3.5.5
There are no notes attached to this issue.





View Issue Details
447 [Sqlite Developer] DBA minor always 2006-06-10 11:02 2006-06-12 07:54
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.6  
   
Upgrade Sqlite to 3.3.6
Upgrade Sqlite to 3.3.6
There are no notes attached to this issue.





View Issue Details
626 [Sqlite Developer] DBA minor have not tried 2007-04-14 11:15 2007-04-14 11:16
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
Upgrade Sqlite to 3.3.15
Upgrade Sqlite to 3.3.15
There are no notes attached to this issue.





View Issue Details
623 [Sqlite Developer] DBA minor have not tried 2007-04-08 03:39 2007-04-08 03:40
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
Upgrade Sqlite to 3.3.14 and support database locking Mode
Upgrade Sqlite to 3.3.14 and support database locking Mode
There are no notes attached to this issue.





View Issue Details
597 [Sqlite Developer] DBA minor have not tried 2007-01-29 23:05 2007-02-03 04:45
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.4  
   
upgrade sqlite to 3.3.12
upgrade sqlite to 3.3.12
There are no notes attached to this issue.





View Issue Details
589 [Sqlite Developer] DBA minor have not tried 2007-01-24 08:06 2007-01-24 08:07
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.4  
   
Upgrade Sqlite to 3.3.11
Upgrade Sqlite to 3.3.11
There are no notes attached to this issue.





View Issue Details
584 [Sqlite Developer] DBA minor have not tried 2007-01-21 00:19 2007-01-21 00:19
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.4  
   
Upgrade Sqlite to 3.3.10
Upgrade Sqlite to 3.3.10
There are no notes attached to this issue.





View Issue Details
813 [Sqlite Developer] DBA minor have not tried 2008-07-26 23:58 2008-07-26 23:58
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
   
upgrade sqlite dll to 3.6
upgrade sqlite dll to 3.6
There are no notes attached to this issue.





View Issue Details
400 [Sqlite Developer] DBA minor always 2006-02-18 23:59 2006-02-19 00:03
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.1RC1  
   
upgrade sqlite dll to 3.34
upgrade sqlite dll to 3.34
There are no notes attached to this issue.





View Issue Details
424 [Sqlite Developer] DBA minor always 2006-04-06 11:35 2006-04-08 23:42
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.3  
   
upgrade sqlite dll to 3.3.5
upgrade sqlite dll to 3.3.5
There are no notes attached to this issue.





View Issue Details
393 [Sqlite Developer] DBA minor always 2005-12-20 20:02 2006-01-07 02:27
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.1RC1  
   
Upgrade Sqlite dll to 3.2.8
Upgrade Sqlite dll to 3.2.8
There are no notes attached to this issue.





View Issue Details
405 [Sqlite Developer] Component minor always 2006-03-05 18:10 2009-02-10 03:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none  
   
Upgrade SQLite components
Upgrade SQLite components
Notes
(0000048)
sharpplus   
2006-03-06 03:04   
Upgrade Hex Editor





View Issue Details
401 [Sqlite Developer] Install minor always 2006-02-19 00:00 2006-02-19 00:05
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.1RC1  
   
upgrade Liveupdate program
upgrade Liveupdate program
There are no notes attached to this issue.





View Issue Details
275 [Sqlite Developer] Install minor always 2005-10-11 10:29 2005-10-29 13:31
user2  
 
normal  
closed  
fixed  
none    
none 0.97Alpha1  
   
Upgrade liveupdate
Upgrade liveupdate
There are no notes attached to this issue.





View Issue Details
888 [Sqlite Developer] Help minor have not tried 2008-12-02 08:34 2008-12-02 08:35
sharpplus  
 
normal  
new  
open  
none    
none  
  3.2.x  
Update Help to keep up with the new changes
Update Help to keep up with the new changes
There are no notes attached to this issue.





View Issue Details
960 [Sqlite Developer] Extension minor have not tried 2009-05-09 22:24 2009-06-27 22:20
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
Update function extension for sqlite
Update function extension for sqlite
There are no notes attached to this issue.





View Issue Details
553 [Sqlite Developer] DBA minor always 2006-09-15 08:48 2007-02-28 20:30
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.4  
   
Update Data when leave the inplace editor
Update Data when leave the inplace editor
There are no notes attached to this issue.





View Issue Details
991 [Sqlite Developer] Schema Editor minor have not tried 2009-10-18 08:47 2009-10-18 08:56
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.5.x  
  3.5.x  
uniform the [ DB Object Name ] usage
uniform the [ DB Object Name ] usage, unique , foreign key
There are no notes attached to this issue.





View Issue Details
355 [Sqlite Developer] Unicode minor always 2005-11-22 23:36 2009-02-10 03:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none  
   
Unicode FieldName has card
Unicode FieldName has card
There are no notes attached to this issue.





View Issue Details
385 [Sqlite Developer] Unicode minor always 2005-12-14 20:18 2005-12-14 20:18
sharpplus  
 
normal  
new  
open  
none    
none  
   
under japanese system, can not invoke the IME
under japanese system, can not invoke the IME
There are no notes attached to this issue.





View Issue Details
661 [Sqlite Developer] GUI minor have not tried 2007-07-16 01:55 2007-07-23 22:20
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
   
under japanese enviroment, extract schema wizard will display strange text
under japanese enviroment, extract schema wizard will display strange text
There are no notes attached to this issue.





View Issue Details
964 [Sqlite Developer] Export/Import major always 2009-06-04 08:52 2009-06-05 09:01
mreisch  
sharpplus  
normal  
closed 3.3.x  
unable to reproduce  
none    
none 3.4.x  
  3.4.x  
unable to insert my data
The insert command fails with an error "unrecognized token". What can I do to insert my data? CREATE TABLE "Help"( [ID] integer ,[SeqID] integer ,[HelpCaption] varchar(250) ,[HelpText] blob , Primary Key(ID) ); INSERT INTO "Help" VALUES (5, 0, 'Adressen', 'Erfassen oder bearbeiten Sie die Adressen, welche Sie in Ihren Projekten einsetzen.

Die Schalter zur Bearbeitung der Adressen finden Sie oben in der Toolbar.

Bearbeitungsfunktionen<HR>
<IMG src="idx:$15"> Erfassen einer neuen Adresse
<IMG src="idx:$01"> Bearbeiten der ausgewählten Adresse
<IMG src="idx:$02"> löschen der ausgewählen Adresse
<IMG src="idx:$03"> speichert die Änderungen
<IMG src="idx:$04"> verwirft die Änderungen

Außerdem gibt es noch einige weitere Bearbeitungsfunktionen. Links in dem Navigationsbereich besteht die Möglichkeit Adressen von anderen Anwendungen zu übernehmen, oder die Ansicht der Listendarstellung zu verändern.

Adressen recherchieren<HR>
<IMG src="idx:$05"> Recherche von Adressen in der http://www.architektenservice.com [^] im Internet

<IMG src="idx:$06"> Übernehmen von einzelnen Adressen von Microsoft Outlook

Wenn Sie alle Adressen aus Microsoft Outlook importieren möchten, dann können Sie im Menü Datei\Importassistent auswählen oder klicken Sie menu:frmHaupt.bbImportDlg.

<IMG src="idx:$07"> Aktualisiert Adressen, welche aus Fremdanwendungen übernommen wurden (z.Bsp. vom AS Architektenservice). ');
Dear mreisch Sorry, I can not duplicate the bug reported easily. I just new sql editor and paste the sql you provided, then press query button of sql editor. The sql was finished correctly , and I can see a 'Help' table was created and one record was inserted. Would you please tell me the duplication steps?
Notes
(0000250)
sharpplus   
2009-06-04 09:23   
thanks for your bug report. I will check it as soon as possible.
(0000251)
sharpplus   
2009-06-04 09:33   
By the way , I used the latest version 3.4.2 to test your bug report, I will try the old 3.3.x version lately
(0000252)
sharpplus   
2009-06-04 09:35   
I just test with 3.3.8 . Still can not duplicate your bug report
(0000253)
sharpplus   
2009-06-04 09:38   
hi , mreisch I just change my region setting to Germany and can duplicate your bug report, I will check it and find out why the sql can not be executed on germany system.
(0000254)
sharpplus   
2009-06-05 09:00   
Dear mreisch, I just tested the bug with the latest sqlite developer .It seems the bug already fixed from version 3.4.1 ,so please download the latest sqlite developer 3.4.2 from http://www.sqlitedeveloper.com/downloads/SqliteDev342.zip and try it . If you still have problem , please do not hesitate to let me know





View Issue Details
929 [Sqlite Developer] GUI major always 2009-02-27 07:27 2009-03-03 09:21
mreisch  
 
normal  
new 3.2.x  
open  
none    
none  
   
Timestamp Fields shows always 0 Dates
The timestamp fields show always 30.12.1899 value (=0) even when it have valid date
sql_error.jpg (50,253) 2009-02-27 07:27
http://mantis.sharpplus.com/file_download.php?file_id=15&type=bug
jpg

date2.jpg (38,584) 2009-03-02 09:18
http://mantis.sharpplus.com/file_download.php?file_id=16&type=bug
jpg

Germany2.jpg (35,177) 2009-03-03 09:13
http://mantis.sharpplus.com/file_download.php?file_id=17&type=bug
jpg

Germany1.jpg (52,256) 2009-03-03 09:14
http://mantis.sharpplus.com/file_download.php?file_id=18&type=bug
jpg
Notes
(0000233)
sharpplus   
2009-02-27 07:36   
Thank you for your bug report , I will check it
(0000234)
sharpplus   
2009-02-28 08:30   
sorry, I can not duplicate the problem, I guess it maybe caused by Germany region setting or your data format or type mapping ? would you please post a little database which can show the problem. best gards
(0000237)
mreisch   
2009-03-01 05:03   
The screenshot you see was made with the sample database, that was installed with sqlite developer. BTW I like the sqlite developer very much, great piece of software. I think I will order it for my private use.
(0000238)
sharpplus   
2009-03-02 09:20   
I guess the problem was caused by the difference of region settings between Germany and Japanese System. Our sample db's data was created under Japanese system settings. Would you please open your sqlite developer and execute menu command Options | Options , then in the options dialog select Tree Node General | DataType , then change the DateTime Setting's Date Separator to '/', DateFormat to 'yyyy/MM/dd' (please open the attachment date2.jpg to see my setting), and open the table again ? Best regards
(0000239)
mreisch   
2009-03-02 11:08   
When I change the DateFormat as you wish then the Timestamps in the sample DB was shown correct. But not in my DB which I had filled with my german system. In my Delphi Application the timestamps was shown correctly.
(0000241)
sharpplus   
2009-03-03 09:21   
sorry, I do not know your problem very clearly. I just change my date format setting to germany region settings(Date Separator ='.' and DateFormat='dd.MM.yyyy' like attachment Germany2.jpg) and then I create a table with a datetime field , and edit the date , it looks like ok (see Germany1.jpg). in your db, are the timestamp data saved as dd.MM.yyyy format string? In SQLite Developer , the timestamp data will be converted from string to datetime using Delphi StrToDateTime function. If your time data were not saved as string for example integer, it will explain the result you observed. If you still can not get the data be shown correctly , would you please post a sample db?





View Issue Details
947 [Sqlite Developer] Export/Import minor have not tried 2009-04-09 01:47 2009-04-09 09:47
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.3.x  
  3.3.x  
there were only 80 charecters( ANSI ) was imported successfully for each column when importing csv to db
there were only 80 charecters( ANSI ) was imported successfully for each column when importing csv to db
Notes
(0000243)
sharpplus   
2009-04-09 09:47   
change max string length from 80 to 320





View Issue Details
946 [Sqlite Developer] Schema Editor minor have not tried 2009-04-08 09:49 2009-04-08 10:06
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.3.x  
  3.3.x  
there is no confirmation message popuped after clicking the close button after index edited was changed
there is no confirmation message popuped after clicking the close button after index edited was changed
There are no notes attached to this issue.





View Issue Details
674 [Sqlite Developer] GUI minor have not tried 2007-09-19 00:43 2007-09-19 08:28
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
   
There is no a context menu for edit , combobox and memo anymore . (regression of Ver2.73)
There is no a context menu for edit , combobox and memo anymore . (regression of Ver2.73)
There are no notes attached to this issue.





View Issue Details
762 [Sqlite Developer] Parser minor have not tried 2008-02-07 09:15 2008-02-07 09:15
sharpplus  
 
normal  
new  
open  
none    
none  
   
the error msg was not very user friend
for example /* Error message: SQL script is wrong mismatched input . expecting "RP" */
There are no notes attached to this issue.





View Issue Details
148 [Sqlite Developer] DBA minor always 2005-08-22 21:52 2010-01-31 08:54
user2  
 
normal  
closed  
fixed  
none    
none 3.6.x  
  3.6.x  
Test Data Generator
Test Data Generator
There are no notes attached to this issue.





View Issue Details
606 [Sqlite Developer] Unicode minor have not tried 2007-02-23 22:13 2007-02-23 22:13
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.5  
   
Tag "Web" is unknown (line 0) and load List index out of bounds(0) error on some non-english locale systems.
Tag "Web" is unknown (line 0) and load List index out of bounds(0) error on some non-english locale systems.
There are no notes attached to this issue.





View Issue Details
435 [Sqlite Developer] Query Builder minor always 2006-04-29 03:56 2006-05-26 12:13
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 1.4  
   
Table link in Query builder is broken(Introduced in ver 0.97)
Table link in Query builder is broken(Introduced in ver 0.97)
There are no notes attached to this issue.





View Issue Details
465 [Sqlite Developer] DBA minor always 2006-06-25 11:04 2006-06-25 11:04
sharpplus  
 
normal  
new  
open  
none    
none  
   
Table Designer
Table Designer
There are no notes attached to this issue.





View Issue Details
602 [Sqlite Developer] SQL Editor minor have not tried 2007-02-13 06:49 2007-02-13 06:49
sharpplus  
 
normal  
new  
open  
none    
none  
   
Syntax highlight was strange for string with '
Syntax highlight was strange for string with ' insert into person (id, name, userGroupId, description, creationTime) values (1, '阿大', 1, '�管员1', 1171180932015);
There are no notes attached to this issue.





View Issue Details
472 [Sqlite Developer] SQL Editor minor always 2006-06-28 07:48 2006-07-01 05:12
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.7  
   
syntax highlight has problem
when keyword with TAB(0x09) following the keyword, the keyword was not highlighted
There are no notes attached to this issue.





View Issue Details
640 [Sqlite Developer] SQL Editor minor have not tried 2007-05-01 01:23 2007-05-01 03:48
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
syntax check was still enabled after disabling the option
syntax check was still enabled after disabling the option
There are no notes attached to this issue.





View Issue Details
631 [Sqlite Developer] Schema Editor minor have not tried 2007-04-23 21:19 2007-05-01 08:13
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
Syntax check always prompt error for end in create trigger editor
Syntax check always prompt error for end in create trigger editor
There are no notes attached to this issue.





View Issue Details
934 [Antlr For Delphi Target] General minor have not tried 2009-03-28 23:31 2009-10-04 13:14
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.2  
  3.2  
Syndicate with Antlr 3.2
Syndicate with Antlr 3.2
There are no notes attached to this issue.





View Issue Details
922 [Antlr For Delphi Target] General minor have not tried 2009-02-22 10:30 2009-03-28 23:31
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.1  
   
Syndicate with Antlr 3.1.2
Syndicate with Antlr 3.1.2
There are no notes attached to this issue.





View Issue Details
536 [Sqlite Developer] DBA minor always 2006-08-27 04:44 2009-03-03 03:42
sharpplus  
 
normal  
closed  
fixed  
none    
none  
   
syndicate primary key after drop or change field name
syndicate primary key after drop or change field name
There are no notes attached to this issue.





View Issue Details
185 [Sqlite Developer] DBA minor always 2005-09-04 04:07 2005-09-29 06:25
user2  
user2  
normal  
closed  
fixed  
none    
none 0.84  
   
switch system objects and non-sysobject does not hide the system index
switch system objects and non-sysobject does not hide the system index
There are no notes attached to this issue.





View Issue Details
999 [Sqlite Developer] DBA minor have not tried 2009-11-08 21:59 2009-11-08 22:00
sharpplus  
 
normal  
new  
open  
none    
none  
  3.5.x  
support WxSqlite3 encrypted database
support WxSqlite3 encrypted database
There are no notes attached to this issue.





View Issue Details
271 [Sqlite Developer] DBA minor always 2005-10-10 00:09 2005-10-29 13:12
user2  
user2  
normal  
closed  
fixed  
none    
none 0.97Alpha1  
   
support view and edit temporary index
support view and edit temporary index
There are no notes attached to this issue.





View Issue Details
290 [Sqlite Developer] SQL Editor minor always 2005-10-18 05:07 2005-10-29 13:17
user2  
user2  
normal  
closed  
fixed  
none    
none 0.97Alpha1  
   
Support view and edit string , blob field as Hex Value
Support view and edit string , blob field as Hex Value
Notes
(0000033)
user2   
2005-10-18 05:08   
based on simple sqlite wrapper





View Issue Details
372 [Sqlite Developer] Unicode minor always 2005-12-01 21:03 2005-12-13 07:28
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 1.08Beta2  
   
support unicode name database
support unicode name database
There are no notes attached to this issue.





View Issue Details
970 [Sqlite Developer] Data Access Component minor have not tried 2009-07-30 12:20 2009-08-01 10:21
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
support sqlite dateformat (iso 8601)
support sqlite dateformat (iso 8601)
There are no notes attached to this issue.





View Issue Details
135 [Sqlite Developer] SQL Editor minor always 2005-08-21 11:13 2005-09-29 06:28
user2  
user2  
normal  
closed  
fixed  
none    
none 0.84  
   
Support SQL History
Support SQL History
Notes
(0000024)
user2   
2005-09-09 23:33   
Add SQL History Count Option





View Issue Details
569 [Sqlite Developer] Parser minor always 2006-10-09 07:37 2006-10-12 09:31
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.3  
   
support new if exists syntax introduced in sqlite 3.3.8
support new if exists syntax introduced in sqlite 3.3.8
There are no notes attached to this issue.





View Issue Details
226 [Sqlite Developer] Parser minor always 2005-09-17 04:02 2005-09-29 06:33
user2  
user2  
normal  
closed  
fixed  
none    
none 0.89  
   
support mulit-line comment
support mulit-line comment
There are no notes attached to this issue.





View Issue Details
466 [Sqlite Developer] Parser minor always 2006-06-25 11:18 2009-02-10 03:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none  
   
support more undocumented pragma commands
support more undocumented pragma commands static int flagPragma(Parse *pParse, const char *zLeft, const char *zRight){ static const struct sPragmaType { const char *zName; /* Name of the pragma */ int mask; /* Mask for the db->flags value */ } aPragma[] = { { "vdbe_trace", SQLITE_VdbeTrace }, { "sql_trace", SQLITE_SqlTrace }, { "vdbe_listing", SQLITE_VdbeListing }, { "full_column_names", SQLITE_FullColNames }, { "short_column_names", SQLITE_ShortColNames }, { "count_changes", SQLITE_CountRows }, { "empty_result_callbacks", SQLITE_NullCallback }, { "legacy_file_format", SQLITE_LegacyFileFmt }, { "fullfsync", SQLITE_FullFSync }, #ifndef SQLITE_OMIT_CHECK { "ignore_check_constraints", SQLITE_IgnoreChecks }, #endif /* The following is VERY experimental */ { "writable_schema", SQLITE_WriteSchema }, { "omit_readlock", SQLITE_NoReadlock }, /* TODO: Maybe it shouldn't be possible to change the ReadUncommitted ** flag if there are any active statements. */ { "read_uncommitted", SQLITE_ReadUncommitted }, };
There are no notes attached to this issue.





View Issue Details
526 [Sqlite Developer] DBA minor always 2006-08-16 12:25 2006-08-16 12:25
sharpplus  
 
normal  
new  
open  
none    
none  
   
support live query editing
support live query editing
There are no notes attached to this issue.





View Issue Details
454 [Sqlite Developer] Parser minor always 2006-06-20 04:18 2006-07-27 09:38
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.9  
   
support IF NOT EXISTS and IF EXISTS syntax
support IF NOT EXISTS and IF EXISTS syntax
There are no notes attached to this issue.





View Issue Details
931 [Sqlite Developer] DBA minor have not tried 2009-03-08 11:11 2009-08-08 09:27
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
support hexkey for encrypted database
support hexkey for encrypted database
There are no notes attached to this issue.





View Issue Details
880 [Sqlite Developer] GUI minor have not tried 2008-10-24 00:45 2008-11-10 21:52
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.1.x  
  3.1.x  
support Grid Filtering , Grouping and Sorting .
support Grid Filtering , Grouping and Sorting .
There are no notes attached to this issue.





View Issue Details
223 [Sqlite Developer] DBA minor always 2005-09-16 12:33 2005-10-08 22:15
user2  
user2  
normal  
closed  
fixed  
none    
none 0.93  
   
support display and edit the temp table, view,trigger
support display and edit the temp table, view,trigger
There are no notes attached to this issue.





View Issue Details
801 [Antlr For Delphi Target] General minor have not tried 2008-07-11 19:32 2008-07-11 19:32
sharpplus  
 
normal  
new  
open  
none    
none  
   
Support debug with AntlrWorks
Support debug with AntlrWorks
There are no notes attached to this issue.





View Issue Details
559 [Sqlite Developer] DBA minor always 2006-09-22 21:39 2006-10-07 22:52
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.2  
   
support constraint name displaying and editing
support constraint name displaying and editing
There are no notes attached to this issue.





View Issue Details
930 [Sqlite Developer] DBA minor have not tried 2009-03-08 07:17 2009-04-17 22:04
sharpplus  
 
normal  
new  
open  
none    
none  
  3.4.x  
Support attach encrypted database
Support attach encrypted database
There are no notes attached to this issue.





View Issue Details
219 [Sqlite Developer] DBA minor always 2005-09-13 23:28 2008-01-13 04:24
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 2.8  
  2.8  
support attach database
support attach database
There are no notes attached to this issue.





View Issue Details
356 [Sqlite Developer] GUI minor always 2005-11-24 09:50 2009-02-10 03:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none  
   
SuiSkin havs problem with skin button and combobox
SuiSkin havs problem with skin button and combobox
There are no notes attached to this issue.





View Issue Details
886 [Sqlite Developer] DBA minor have not tried 2008-11-30 09:21 2009-06-08 20:53
sharpplus  
 
normal  
new  
open  
none    
none  
   
Structure Difference Viewer
Structure Difference Viewer
There are no notes attached to this issue.





View Issue Details
317 [Sqlite Developer] DBA minor always 2005-11-05 21:19 2005-11-20 00:17
user2  
user2  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
Sqlite DataSet always show 0 for NULL Integer field
Sqlite DataSet always show 0 for NULL Integer field
There are no notes attached to this issue.





View Issue Details
1051 [Sqlite Developer] Other major always 2010-08-23 11:25 2010-08-25 13:06
ve3meo  
sharpplus  
high  
closed  
fixed  
none    
none 3.8.x  
   
SQLite 3.7.0 - recommended to upgrade to 3.7.1
3.7.0.1: •Fix a potential database corruption bug that can occur if version 3.7.0 and version 3.6.23.1 alternately write to the same database file. Ticket [51ae9cad317a1] •Fix a performance regression related to the query planner enhancements of version 3.7.0. 3.7.1: •Fixed a bug in the query planner that caused performance regresssions relative to 3.6.23.1 on some complex joins. 3.7.2 pending: a fix for a database corruption bug appearing to be due to incremental vacuum, going back to 3.6.16 June, 2009
Cannot fill in Product version on report form - it stops at 3.6x. Mine is 3.7.9.491 Tom
Notes
(0000283)
sharpplus   
2010-08-25 12:53   
Dear Tom, I will release a new version with 3.7.2 tomorrow. regards
(0000284)
sharpplus   
2010-08-25 13:06   
Please try with http://www.sqlitedeveloper.com/downloads/SqliteDev380.zip





View Issue Details
146 [Sqlite Developer] DBA minor always 2005-08-22 21:47 2005-09-29 06:28
user2  
user2  
normal  
closed  
fixed  
none    
none 0.84  
   
SQL Monitor
SQL Monitor
There are no notes attached to this issue.





View Issue Details
376 [Sqlite Developer] SQL Editor minor always 2005-12-11 08:30 2005-12-13 07:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 1.08Beta2  
   
sql is always saved as ansi text ignoring the charencoding setting.
sql is always saved as ansi text ignoring the charencoding setting.
There are no notes attached to this issue.





View Issue Details
560 [Sqlite Developer] Unicode minor always 2006-09-22 21:52 2007-05-05 22:06
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
SQL History was not saved as unicode string
SQL History was not saved as unicode string
There are no notes attached to this issue.





View Issue Details
643 [Sqlite Developer] SQL Editor minor have not tried 2007-05-05 10:09 2007-05-14 10:46
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
  2.7  
SQL Formatter supports formating comment
SQL Formatter supports format comment
There are no notes attached to this issue.





View Issue Details
1034 [Sqlite Developer] SQL Editor block always 2010-05-22 23:58 2010-05-23 11:17
ve3meo  
sharpplus Windows  
urgent XP SP3  
closed 3.5.x  
fixed  
none    
none 3.6.x  
  3.6.x  
SQL Editor reports error on INSERT of a hex value into BLOB field
CREATE TABLE AddressTable (AddressID INTEGER PRIMARY KEY, AddressType INTEGER, Name TEXT COLLATE RMNOCASE, Street1 TEXT, Street2 TEXT, City TEXT, State TEXT, Zip TEXT, Country TEXT, Phone1 TEXT, Phone2 TEXT, Fax TEXT, Email TEXT, URL TEXT, Latitude INTEGER, Longitude INTEGER, Note BLOB ); Insert Into [AddressTable] ([AddressID],[AddressType],[Name],[Street1],[Street2],[City],[State],[Zip],[Country],[Phone1],[Phone2],[Fax],[Email],[URL],[Latitude],[Longitude],[Note]) Values("101","0","Adolf Wilhelm WEITZ","Burgwedelestr. 141",NULL,"Isernhagen","HB","30916","Germany","+-49-511-775-927",NULL,NULL,NULL,NULL,"0","0",X'48616E64793A20303137322D3435382D35382D3135'); Log: Insert Into [AddressTable] ([AddressID],[AddressType],[Name],[Street1],[Street2],[City],[State],[Zip],[Country],[Phone1],[Phone2],[Fax],[Email],[URL],[Latitude],[Longitude],[Note]) Values("108","0","Wigand WEITZ","Krummbeher Weg 10",NULL,"Höhndorf",NULL,"24217","Germany",NULL,NULL,NULL,NULL,NULL,"0","0",X' expecting "RP" */
Notes
(0000269)
sharpplus   
2010-05-23 11:17   
Thank you for your bug report. There is a bug in the sqlite script lexer of sqlite developer. I just fixed it . Please download the http://www.sqlitedeveloper.com/downloads/SqliteDev368.zip and try it.





View Issue Details
110 [Sqlite Developer] SQL Editor feature always 2005-07-31 12:19 2005-11-20 00:18
user2  
user2  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
SQL Editor now can edit , save and load unicode text.
SQL Editor now can edit , save and load unicode text.
There are no notes attached to this issue.





View Issue Details
1033 [Sqlite Developer] SQL Editor tweak always 2010-05-17 20:54 2010-05-18 09:37
Gillissie Windows  
sharpplus Vista 64 bit  
normal Home edition  
assigned 3.5.x  
open  
none    
none  
   
SQL editor autocomplete
Actually my version is 3.6.5 but the Product Version select list doesn't show that. The autocomplete "feature" in the SQL Editor is more unhelpful than helpful. Primarily, it automatically changes case of my object names as I type. Sometimes it ends up all lower case, sometimes it ends up all upper case. I name all of my tables and columns with proper casing and expect the autocomplete to use the exact casing I specified. The strangest part is that the autocomplete suggestions show the objects in the correct case, but when choosing them, it changes in the editor. Also, it is very common for a huge empty white box to appear while typing something. It looks like it's trying to suggest something but instead just shows an empty white box that just covers most of what I'm trying to type. While on the subject, it is annoying that the cursor in the editor doesn't start on the first column when clicking on an empty line.
Create a table named Proper_Case with a column named Proper_Case. Try entering this in the SQL editor: SELECT * FROM Proper_Case Curiously, it appears that if you type up to the underscore then use the autocomplete, the correct case is preserved. Why wouldn't it preserve it no matter how far you type into the object name?
Notes
(0000268)
sharpplus   
2010-05-18 09:37   
Thanks for your suggestion , I will consider improving it in the next version





View Issue Details
1040 [Sqlite Developer] GUI minor always 2010-05-29 02:00 2010-05-31 23:01
Gillissie  
sharpplus  
normal  
assigned  
open  
none    
none  
   
sorting numeric data as text
This seems to be a new bug because I don't think it always did this until recently. When viewing data in a table, clicking a column header will sort by that column. Sorting by a numeric column is treating the data like text for sorting purposes. This results in sorts like this: 0 1 10 11 2 3 ....
Notes
(0000270)
sharpplus   
2010-05-30 08:54   
Dear Gillissie, Are you sure your field is mapped to a number data type? If your field is mapped to the default string data type, the sort result will like what you observed. I just create a table with a integer field and can not reproduce the problem. Would you please use options | General | Data type to map your field to integer or int64 and check again?
(0000271)
Gillissie   
2010-05-31 23:01   
I am certain that it is an integer type. It happens on any integer type field, not just a certain one. When I do that data type mapping from int to Integer, the sorting is correct. Why wouldn't it just recognize int as Integer automatically? It used to, I'm tell you.





View Issue Details
1020 [Sqlite Developer] Schema Editor minor have not tried 2010-01-30 10:36 2010-01-30 10:36
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.6.x  
   
Sort the index fields will cause access violation (regression of 3.58)
Sort the index fields will cause access violation (regression of 3.58)
There are no notes attached to this issue.





View Issue Details
620 [Sqlite Developer] SQL Editor minor have not tried 2007-03-27 04:54 2007-03-31 06:37
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
sometimes when selecting the autocomplete suggestion will generate Access vialation(Introduced in 2.52)
sometimes when selecting the autocomplete suggestion will generate Access vialation(Introduced in 2.52)
There are no notes attached to this issue.





View Issue Details
473 [Sqlite Developer] GUI minor always 2006-06-28 08:57 2006-09-08 09:46
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.1  
   
sometimes when scrolling field grid or displaying many fields in Table Edit Form,one of the fields display was messed
sometimes when scrolling field grid or displaying many fields in Table Edit Form,one of the fields display was messed
There are no notes attached to this issue.





View Issue Details
563 [Sqlite Developer] Other minor always 2006-09-25 01:47 2006-09-25 01:47
sharpplus  
 
normal  
new  
open  
none    
none  
   
sometimes runtime 217 error was shown when executing the program
runtime 217 error sometimes runtime 217 error was shown when executing the program , use jcl to find the bug
There are no notes attached to this issue.





View Issue Details
847 [Sqlite Developer] SQL Editor minor have not tried 2008-09-06 01:25 2008-09-06 04:04
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
  3.0.x  
sometimes report list out of index error when deleting right ")" ( regression of 2.88)
when delete the last ) , the editor will report list out of index error for select pi)
There are no notes attached to this issue.





View Issue Details
735 [Sqlite Developer] DBA minor have not tried 2008-01-12 06:32 2008-01-12 06:38
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
  2.8  
Sometimes raise Access violation when drop the table, etc
Sometimes raise Access violation when drop the table, etc
There are no notes attached to this issue.





View Issue Details
653 [Sqlite Developer] SQL Editor minor have not tried 2007-07-05 22:21 2007-07-07 00:16
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
sometimes prompt schema complete when keyword complete should be prompted
sometimes prompt schema complete when keyword complete should be prompted
There are no notes attached to this issue.





View Issue Details
756 [Sqlite Developer] DBA minor have not tried 2008-02-03 08:44 2008-02-04 09:07
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
sometimes no response after editing attached database's table, view, trigger, etc,
sometimes no response after editing attached database's table, view, trigger, etc,
There are no notes attached to this issue.





View Issue Details
812 [Sqlite Developer] SQL Editor minor have not tried 2008-07-26 23:55 2008-07-26 23:55
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
   
sometimes keyword complete was not invoked
sometimes keyword complete was not invoked
There are no notes attached to this issue.





View Issue Details
582 [Sqlite Developer] DBA minor always 2006-11-12 05:53 2008-08-19 21:40
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
  3.0.x  
sometimes empty table can not delete all the data in the table
sometimes empty table can not delete all the data in the table
There are no notes attached to this issue.





View Issue Details
760 [Sqlite Developer] Schema Editor minor have not tried 2008-02-04 10:05 2008-02-09 05:02
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
sometimes edit virtual table will raise error (regression of Ver2.80)
sometimes edit virtual table will raise error (regression of Ver2.80)
There are no notes attached to this issue.





View Issue Details
866 [Sqlite Developer] Other minor have not tried 2008-09-28 08:17 2008-09-28 08:17
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
   
sometimes copy all to clipboard did not work (3.00 beta)
sometimes copy all to clipboard did not work (3.00 beta)
There are no notes attached to this issue.





View Issue Details
407 [Sqlite Developer] GUI minor always 2006-03-18 00:20 2007-11-03 09:53
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
   
sometimes clicking the node will not set to the node to focused state
sometimes clicking the node will not set to the node to focused state
There are no notes attached to this issue.





View Issue Details
595 [Sqlite Developer] Parser minor have not tried 2007-01-24 23:15 2007-01-24 23:15
sharpplus  
 
normal  
new  
open  
none    
none  
   
some times the parsed result include return which will make the text shown in editor as empty
some times the parsed result include return which will make the text shown in editor as empty
There are no notes attached to this issue.





View Issue Details
202 [Sqlite Developer] GUI minor always 2005-09-10 10:08 2005-09-29 06:29
user2  
user2  
normal  
closed  
fixed  
none    
none 0.84  
   
some quirk focus problem
some quirk focus problem
There are no notes attached to this issue.





View Issue Details
513 [Sqlite Developer] GUI minor always 2006-07-31 11:56 2006-08-05 05:46
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.0  
   
some minor gui tweaks
change mainmenu and popupmenu to actionmainmenu and popupmenubar
There are no notes attached to this issue.





View Issue Details
864 [Sqlite Developer] Schema Editor minor have not tried 2008-09-28 08:14 2008-09-28 08:14
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
   
some inplace editor of grid's height was not small than cell height.(bug of 3.00 beta)
some inplace editor of grid's height was not small than cell height.(bug of 3.00 beta)
There are no notes attached to this issue.





View Issue Details
379 [Sqlite Developer] Option minor always 2005-12-12 08:19 2006-09-02 23:09
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.1  
   
some database Configuration(Temp Store , etc) were not persisted correctly
some database Configuration(Temp Store , etc) were not persisted correctly
Notes
(0000053)
sharpplus   
2006-06-23 22:22   
Temp Store , Count Changes , Empty result callbacks, Full column names was still incorrect.
(0000061)
sharpplus   
2006-09-02 22:34   
Temp Store was still incorrect.





View Issue Details
259 [Sqlite Developer] Parser minor always 2005-10-07 21:42 2005-10-08 22:21
user2  
user2  
normal  
closed  
fixed  
none    
none 0.93  
   
some create SQL will not automaticlly add node to DB Explorer when executed successfully
Below SQL will not Automaticlly add node to DB Explorer create trigger trigger9 instead of delete ON TempView BEGIN --Test END TempView is a Temp View.
Notes
(0000031)
user2   
2005-10-07 21:46   
when create trigger on a temp view or temp table , the created trigger will be also temporary.





View Issue Details
363 [Sqlite Developer] GUI minor always 2005-11-26 00:47 2009-02-10 03:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none  
   
Skin Engine will raise Exception for SQL Editor
Skin Engine will raise Exception for SQL Editor
Notes
(0000040)
sharpplus   
2005-11-26 06:27   
need RemoveSkinForm after showmodal and maybe do not use addskinform at create event





View Issue Details
269 [Sqlite Developer] GUI minor always 2005-10-08 22:47 2005-10-10 22:33
user2  
user2  
normal  
closed  
fixed  
none    
none 0.93  
   
Show Toolbar Button Hint for Edit View Dialog and Edit Trigger Dialog
Show Toolbar Button Hint for Edit View Dialog and Edit Trigger Dialog
There are no notes attached to this issue.





View Issue Details
836 [Sqlite Developer] GUI minor have not tried 2008-08-19 02:40 2009-04-04 00:41
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.3.x  
  3.3.x  
Show row number in indicator of dbgrid
Show row number in indicator of dbgrid
There are no notes attached to this issue.





View Issue Details
842 [Sqlite Developer] Schema Editor minor have not tried 2008-08-26 07:33 2008-09-06 02:47
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
  3.0.x  
show modified mark on Schema Editor Title
show modified mark on Schema Editor Title
Notes
(0000217)
sharpplus   
2008-08-27 03:30   
display the title as bold font when modified





View Issue Details
826 [Sqlite Developer] DBA minor have not tried 2008-08-06 23:41 2008-11-29 04:09
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.2.x  
  3.2.x  
Show fetched record count for queries or table.
get record count for queries.
There are no notes attached to this issue.





View Issue Details
413 [Sqlite Developer] GUI minor always 2006-03-18 01:51 2006-03-18 04:22
sharpplus  
 
normal  
closed  
fixed  
none    
none  
   
show edit table , view , trigger name on form title
show edit table , view , trigger name on form title
There are no notes attached to this issue.





View Issue Details
186 [Sqlite Developer] GUI minor always 2005-09-04 04:21 2005-10-08 22:27
user2  
user2  
normal  
closed  
fixed  
none    
none 0.93  
   
Show different icons with tempoary and system table, view, trigger, index.
Show different icons with tempoary and system table, view, trigger, index.
There are no notes attached to this issue.





View Issue Details
954 [Sqlite Developer] GUI minor have not tried 2009-04-17 21:58 2009-04-28 08:18
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
show different icon for key field
show different icon for key field
There are no notes attached to this issue.





View Issue Details
294 [Sqlite Developer] DBA minor always 2005-10-22 23:19 2005-11-06 04:18
user2  
user2  
normal  
closed  
fixed  
none    
none 1.02Alpha2  
   
show Db Explorer's Db or table information at status bar
show Db Explorer's Db or table information at status bar
There are no notes attached to this issue.





View Issue Details
545 [Sqlite Developer] DBA minor always 2006-09-12 21:00 2006-09-16 00:52
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.2  
   
Show compress size change information when compressing the database
Show compress size change information when compressing the database
There are no notes attached to this issue.





View Issue Details
1001 [Sqlite Developer] Other minor have not tried 2009-11-10 19:50 2009-11-13 21:56
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.5.x  
  3.5.x  
Shell Integration:Support open drag and dropped db from windows explorer(not available for vista or win7)
Shell Integration:Support open drag and dropped db from windows explorer
There are no notes attached to this issue.





View Issue Details
647 [Sqlite Developer] Data Editor minor have not tried 2007-05-06 00:56 2007-05-14 10:46
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
  2.7  
serveral data edit buttons were disabled (Introduced in 2.60)
All the data edit buttons were disabled (Introduced in 2.60)
There are no notes attached to this issue.





View Issue Details
431 [Sqlite Developer] GUI minor always 2006-04-22 04:07 2006-04-23 00:41
sharpplus  
 
normal  
new  
open  
none    
none  
   
Select the first node on incremental search
Select the first node on incremental search
There are no notes attached to this issue.





View Issue Details
610 [Sqlite Developer] DBA minor have not tried 2007-03-04 07:00 2007-03-04 09:09
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
select rowid from table does not return results
select rowid from table does not return results
There are no notes attached to this issue.





View Issue Details
456 [Sqlite Developer] GUI minor always 2006-06-20 07:20 2006-06-20 07:23
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.7  
   
Search Result TreeView alignment was incorrect in Find Database Schema Form
Search Result TreeView alignment was incorrect in Find Database Schema Form
There are no notes attached to this issue.





View Issue Details
1026 [Sqlite Developer] GUI feature always 2010-03-12 23:27 2010-05-08 22:45
Gillissie Windows  
sharpplus Vista  
normal  
closed 3.5.x  
fixed  
none    
none 3.6.x  
  3.6.x  
Schema windows
When closing a schema window then re-opening it, it doesn't remember the size and position it last used. Please make it remember this information, at least until exiting the program. Also, when applying schema changes, the window closes. Please automatically re-open the window after applying a schema change to it, using the same size and position that it already had.
Notes
(0000259)
sharpplus   
2010-03-16 08:59   
Thank you for your suggestion , I will consider improve it in the coming version
(0000263)
sharpplus   
2010-03-20 11:58   
Just added Remember Schema Window Placement Option in the new version. Please try it with http://www.sqlitedeveloper.com/downloads/SqliteDev363.zip Save Schema Change without closing the schema window will be added in the next version.
(0000264)
sharpplus   
2010-04-11 09:35   
Just implement that saving schema changes without closing the schema window . please try it with http://www.sqlitedeveloper.com/downloads/SqliteDev365.zip
(0000265)
Gillissie   
2010-04-11 13:45   
(edited on: 2010-04-11 13:45)
Thank you for adding this feature. However, it is not very elegant because the window initially opens in the default position and size, then quickly changes to the remembered size. Can you make it so the window isn't displayed until it has been positioned and sized properly, to avoid that disconcerting flash?
(0000266)
sharpplus   
2010-04-12 06:57   
Yes there is a ugly flash. I will fix it in the next version.
(0000267)
sharpplus   
2010-05-08 22:45   
just fixed the flash problem, please try it with. http://www.sqlitedeveloper.com/downloads/SqliteDev366.zip





View Issue Details
865 [Sqlite Developer] Export/Import minor have not tried 2008-09-28 08:15 2008-09-28 08:15
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
   
Schema SQL export and import database were broken (bug of 3.0beta)
Schema SQL export and import database were broken (bug of 3.0beta)
There are no notes attached to this issue.





View Issue Details
982 [Sqlite Developer] Schema Editor minor have not tried 2009-09-23 20:36 2009-09-25 22:30
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.5.x  
  3.5.x  
schema editor combobox editor minor tweaks
schema editor combobox editor minor tweaks
There are no notes attached to this issue.





View Issue Details
856 [Sqlite Developer] Schema Editor minor have not tried 2008-09-23 04:31 2008-09-23 04:31
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
   
Schema Autocomplete was not valid for view and trigger editor (regression of 2.94)
Schema Autocomplete was not valid for view and trigger editor (regression of 2.94)
There are no notes attached to this issue.





View Issue Details
664 [Sqlite Developer] Other minor have not tried 2007-07-23 22:21 2009-02-10 03:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.2.x  
   
Save ConfigFile to User Document folder to improved the vista compatibility
Save ConfigFile to User Document folder to improved the vista compatibility
There are no notes attached to this issue.





View Issue Details
671 [Sqlite Developer] SQL Editor minor have not tried 2007-09-16 11:58 2007-12-28 22:44
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
  2.8  
Rewrited code format engine and added more format options and preview
Rewrited code format engine and added more format options and preview
There are no notes attached to this issue.





View Issue Details
840 [Sqlite Developer] DBA minor have not tried 2008-08-21 11:34 2008-08-23 03:12
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
   
Rewrite SQL Monitor to record database and clocktime of executed SQL statement
Rewrite SQL Monitor use profile and trace
There are no notes attached to this issue.





View Issue Details
936 [Sqlite Developer] Unicode minor have not tried 2009-04-02 22:11 2009-05-02 11:39
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
restore ansi table name and field name support which was removed from version 3.00
restore ansi table name and field name support which was removed from version 3.00
There are no notes attached to this issue.





View Issue Details
907 [Sqlite Developer] Unicode minor have not tried 2009-02-06 08:15 2009-03-27 22:28
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.3.x  
  3.3.x  
Restore ansi Data Encoding support which was removed from version 3.00
Restore ansi Data Encoding support which was removed from version 3.00
There are no notes attached to this issue.





View Issue Details
820 [Sqlite Developer] Export/Import minor have not tried 2008-08-03 04:52 2008-08-06 04:39
sharpplus  
 
normal  
new  
open  
none    
none  
  3.2.x  
report out of memory when importing million records
report out of memory for import function
There are no notes attached to this issue.





View Issue Details
726 [Sqlite Developer] DBA minor have not tried 2008-01-10 08:32 2008-01-10 08:32
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
  2.8  
report error when reindex sqlite_temp_master table
report error when reindex sqlite_temp_master table
There are no notes attached to this issue.





View Issue Details
641 [Sqlite Developer] SQL Editor minor have not tried 2007-05-01 21:28 2007-05-01 21:50
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
replace command always disabled
replace command always disabled
There are no notes attached to this issue.





View Issue Details
869 [Sqlite Developer] Option minor have not tried 2008-09-28 08:21 2008-10-05 23:41
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
  3.0.x  
remove transaction type from options
remove transaction type from options
There are no notes attached to this issue.





View Issue Details
984 [Antlr For Delphi Target] General minor have not tried 2009-09-26 11:16 2009-09-26 11:16
sharpplus  
 
normal  
new  
open  
none    
none  
  3.2  
Remove StrReplace to improve the performance of lexer
Remove StrReplace to improve the performance of lexer
There are no notes attached to this issue.





View Issue Details
609 [Sqlite Developer] SQL Editor minor have not tried 2007-03-04 05:17 2007-03-04 05:17
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
remove some wrong keywords from autocomplete and highlighter
remove some wrong keywords from autocomplete and highlighter
There are no notes attached to this issue.





View Issue Details
398 [Sqlite Developer] DBA minor always 2006-01-30 02:17 2006-01-30 09:21
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.1RC1  
   
Remove Reverse Collation from collation list because sqlite does not implement it like that the document said.
Remove Reverse Collation from collation list because sqlite does not implement it like that the document said.
There are no notes attached to this issue.





View Issue Details
402 [Sqlite Developer] DBA minor always 2006-02-22 07:59 2006-02-22 07:59
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.1RC1  
   
Remove On Conflict from create index support because sqlite remove the feature
Remove On Conflict from create index support because sqlite remove the feature
There are no notes attached to this issue.





View Issue Details
1022 [Sqlite Developer] Schema Editor minor have not tried 2010-03-10 10:17 2010-03-11 10:00
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.6.x  
  3.6.x  
Remove Generate foreign key trigger command due to sqlite already have build in foreign key support
Remove Generate foreign key trigger command due to sqlite already have build in foreign key support
There are no notes attached to this issue.





View Issue Details
344 [Sqlite Developer] SQL Editor minor always 2005-11-19 01:21 2005-11-20 00:30
user2  
user2  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
remove duplicate time log messages when sql was executed successfully
remove duplicate time log messages when sql was executed successfully
There are no notes attached to this issue.





View Issue Details
616 [Sqlite Developer] GUI minor have not tried 2007-03-23 13:53 2007-03-24 10:28
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
Remove conflict algorithm from multi language support
Remove conflict algorithm from multi language support
There are no notes attached to this issue.





View Issue Details
568 [Sqlite Developer] DBA minor always 2006-10-07 23:07 2006-10-07 23:07
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.3  
   
Reindex and Analyze Command was broken
Reindex and Analyze Command was broken
There are no notes attached to this issue.





View Issue Details
330 [Sqlite Developer] DBA minor always 2005-11-08 07:55 2005-11-08 08:02
user2  
 
normal  
closed  
fixed  
none    
none 1.02Alpha2  
   
Registered Database was added to wrong Db Explorer Node
Registered Database was added to wrong Db Explorer Node
There are no notes attached to this issue.





View Issue Details
548 [Sqlite Developer] DBA minor always 2006-09-14 08:38 2006-09-15 21:15
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.2  
   
Refresh Data command in Table Data Edit Tab was broken
Refresh Data command in Table Data Edit Tab was broken
There are no notes attached to this issue.





View Issue Details
467 [Sqlite Developer] GUI minor always 2006-06-26 09:08 2006-06-26 09:08
sharpplus  
 
normal  
new  
open  
none    
none  
   
redirect console output to show vbde_trace , sql_trace and etc
redirect console output to show vbde_trace , sql_trace and etc
There are no notes attached to this issue.





View Issue Details
615 [Sqlite Developer] SQL Editor minor have not tried 2007-03-18 08:50 2007-03-24 09:41
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
randomBlob() and hex()
randomBlob() and hex()
There are no notes attached to this issue.





View Issue Details
727 [Sqlite Developer] DBA minor have not tried 2008-01-10 09:04 2008-01-11 22:02
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
  2.8  
raise Access violation when execute some wrong sql (regression of ver2.75)
raise Access violation when execute some wrong sql
There are no notes attached to this issue.





View Issue Details
736 [Sqlite Developer] SQL Editor minor have not tried 2008-01-13 00:00 2008-01-13 01:27
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
  2.8  
raise access violation exception when executing reindex and analyze command(regression of ver2.75)
raise access violation exception when executing reindex and analyze command
There are no notes attached to this issue.





View Issue Details
325 [Sqlite Developer] DBA minor always 2005-11-06 04:58 2005-11-06 05:38
user2  
user2  
normal  
closed  
fixed  
none    
none 1.02Alpha2  
   
Query Sample Database's Sales data will report invalid datetime error
Query Sample Database's Sales data will report invalid datetime error
There are no notes attached to this issue.





View Issue Details
190 [Sqlite Developer] DBA minor always 2005-09-04 10:45 2005-09-29 06:30
user2  
user2  
normal  
closed  
fixed  
none    
none 0.89  
   
Query Form can switch opened Database
Query Form can switch opened Database like sql server
There are no notes attached to this issue.





View Issue Details
264 [Sqlite Developer] Query Builder minor always 2005-10-08 12:15 2005-10-29 13:24
user2  
user2  
normal  
closed  
fixed  
none    
none 0.97Alpha1  
   
Query Builder to Support Views
Query Builder to Support Views
There are no notes attached to this issue.





View Issue Details
939 [Sqlite Developer] Other minor have not tried 2009-04-04 05:46 2009-04-06 10:04
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.3.x  
  3.3.x  
put sqlitedev.hql to application data folder to improve vista compatibility
put sqlitedev.hql to application data folder to improve vista compatibility
There are no notes attached to this issue.





View Issue Details
478 [Sqlite Developer] Other minor always 2006-07-03 09:30 2006-07-03 09:30
sharpplus  
 
normal  
new  
open  
none    
none  
   
prohibit running two instances of sqlite developer
prohibit running two instances of sqlite developer
There are no notes attached to this issue.





View Issue Details
516 [Sqlite Developer] GUI minor always 2006-08-05 06:06 2006-08-05 06:21
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.0  
   
press enter key in find in database form will execute the search
press enter key in find in database form will execute the search
There are no notes attached to this issue.





View Issue Details
787 [Sqlite Developer] DBA minor have not tried 2008-03-15 05:07 2008-03-15 05:07
sharpplus  
 
normal  
new  
open  
none    
none  
  2.9  
pragma foreign_key_list(unexisttable) will raise access violation
pragma foreign_key_list(unexisttable) will raise access violation
There are no notes attached to this issue.





View Issue Details
800 [Antlr For Delphi Target] General minor have not tried 2008-07-11 19:31 2008-07-11 19:31
sharpplus  
 
normal  
new  
open  
none    
none  
   
Port GUnit
Port GUnit
There are no notes attached to this issue.





View Issue Details
1038 [Sqlite Developer] Performance minor have not tried 2010-05-26 14:35 2010-05-26 14:49
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.7.x  
   
Poor performance when executing large script
Poor performance when executing large script
There are no notes attached to this issue.





View Issue Details
561 [Sqlite Developer] Parser minor always 2006-09-22 22:55 2007-02-03 09:39
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.5  
   
parsing sql with chinese comment will fail
parsing sql with chinese comment will fail
There are no notes attached to this issue.





View Issue Details
442 [Sqlite Developer] Parser minor always 2006-05-28 12:32 2006-06-04 11:16
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.6  
   
Parser parse "/" incorrectly
Parser parse "/" incorrectly
There are no notes attached to this issue.





View Issue Details
458 [Sqlite Developer] Parser minor always 2006-06-22 06:32 2007-02-03 04:47
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.5  
   
parse FOREIGN KEY constraints
parse FOREIGN KEY constraints
There are no notes attached to this issue.





View Issue Details
794 [Sqlite Developer] SQL Editor minor have not tried 2008-05-24 08:57 2008-05-24 10:48
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
parentheis matching was broken (regression of 2.64)
parentheis matching was broken (regression of 2.64)
There are no notes attached to this issue.





View Issue Details
619 [Sqlite Developer] GUI minor have not tried 2007-03-25 03:42 2007-03-31 07:54
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
Option| Edit Display was strange with japanese language
Option| Edit Display was strange with japanese language
err2.JPG (44,793) 2007-03-25 03:43
http://mantis.sharpplus.com/file_download.php?file_id=8&type=bug
jpg
There are no notes attached to this issue.





View Issue Details
599 [Sqlite Developer] DBA minor have not tried 2007-02-12 04:22 2007-02-12 05:02
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.5  
   
Opening and closing database twice times will make the application deadlocked(Introduced in ver2.30)
Opening and closing database twice times will make the application deadlocked(Introduced in ver2.30)
There are no notes attached to this issue.





View Issue Details
920 [Sqlite Developer] DBA minor have not tried 2009-02-19 07:38 2009-04-27 10:22
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
open db as memory database
open db as memory database
There are no notes attached to this issue.





View Issue Details
448 [Sqlite Developer] SQL Editor minor always 2006-06-17 09:06 2006-06-17 09:06
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.6  
   
only save the current line text when save sql to file
only save the current line text when save sql to file
There are no notes attached to this issue.





View Issue Details
358 [Sqlite Developer] DBA minor always 2005-11-24 21:21 2005-12-13 07:34
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 1.08Beta2  
   
only one field can be added to table every time
only one field can be added to table every time
There are no notes attached to this issue.





View Issue Details
392 [Sqlite Developer] GUI minor always 2005-12-18 09:50 2006-03-18 02:25
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.2RC2  
   
often show "can not open clipboard error"
often show "can not open clipboard error"
I can duplicated the bug with sqlitedev running under debug mode and copy ie contents.
There are no notes attached to this issue.





View Issue Details
389 [Sqlite Developer] SQL Editor minor always 2005-12-18 09:48 2006-01-07 03:30
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 1.1RC1  
   
now you can use Ctrl+Enter to execute the query in SQL Editor
Add Shortcut to Query function , for example Ctrl+Enter
There are no notes attached to this issue.





View Issue Details
861 [Sqlite Developer] Export/Import minor have not tried 2008-09-23 04:37 2008-09-23 04:37
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
   
now you can import / export csv file with specified encoding(utf8, ansi, utf16, utf16be)
now you can import / export csv file with specified encoding(utf8, ansi, utf16, utf16be)
There are no notes attached to this issue.





View Issue Details
339 [Sqlite Developer] Unicode minor always 2005-11-16 08:37 2005-11-20 00:22
user2  
user2  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
now you can create unicode name for table, view, trigger, index
now you can create unicode name for table, view, trigger, index
There are no notes attached to this issue.





View Issue Details
374 [Sqlite Developer] DBA minor always 2005-12-02 07:54 2006-02-21 08:46
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.1RC1  
   
now you can change the database path and database alias when edit the closed database.
now you can change the database path and database alias when edit the closed database.
There are no notes attached to this issue.





View Issue Details
433 [Sqlite Developer] GUI minor always 2006-04-22 06:11 2006-04-23 00:39
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.4  
   
now we can use enter key to open the database in Database Explorer
now we can use enter key to open the database in Database Explorer
There are no notes attached to this issue.





View Issue Details
703 [Sqlite Developer] DBA minor have not tried 2007-12-15 22:38 2007-12-28 22:43
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
  2.8  
now we can select multiple tables in DB Explorer and empty them all
now we can select multiple tables in DB Explorer and empty them all
There are no notes attached to this issue.





View Issue Details
690 [Sqlite Developer] GUI minor have not tried 2007-11-03 09:36 2007-12-28 22:50
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
  2.8  
now we can select multiple nodes in DB Explorer and drop them all
now we can select multiple nodes in DB Explorer and drop them all
There are no notes attached to this issue.





View Issue Details
295 [Sqlite Developer] DBA minor always 2005-10-24 09:12 2005-10-29 13:16
user2  
user2  
normal  
closed  
fixed  
none    
none 0.97Alpha1  
   
now we can generate correct multi primary key create table sql
now we can generate correct multi primary key create table sql
There are no notes attached to this issue.





View Issue Details
104 [Sqlite Developer] SQL Editor feature always 2005-07-31 00:30 2006-07-24 10:43
user15  
 
normal  
closed  
fixed  
none    
none 1.9  
   
now we can execute multiple sql which is seperated by semi colon
now we can execute multi sql which is seperated by semi colon
There are no notes attached to this issue.





View Issue Details
875 [Sqlite Developer] Unicode minor have not tried 2008-10-05 23:44 2008-10-05 23:44
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
   
Now unicode error message can be displayed correctly
Now unicode error message can be displayed correctly
There are no notes attached to this issue.





View Issue Details
524 [Sqlite Developer] Parser minor always 2006-08-15 23:39 2006-08-15 23:40
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.0  
   
now parse identifier with underscore prefix properly
now parse identifier with underscore prefix properly
There are no notes attached to this issue.





View Issue Details
331 [Sqlite Developer] Option minor always 2005-11-08 09:35 2005-11-20 00:20
user2  
user2  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
Now only Fixed Font can be setted as SQL Editor Font
Now only Fixed Font can be setted as SQL Editor Font
There are no notes attached to this issue.





View Issue Details
633 [Sqlite Developer] Option minor have not tried 2007-04-27 06:25 2007-04-28 05:51
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
now multi language setting was persisted to configuration file
multi language setting was persisted to configuration file
There are no notes attached to this issue.





View Issue Details
304 [Sqlite Developer] SQL Editor minor always 2005-10-29 12:47 2005-11-06 04:15
user2  
user2  
normal  
closed  
fixed  
none    
none 1.02Alpha2  
   
now Log was displayed order by date desc
now Log was displayed order by date desc
There are no notes attached to this issue.





View Issue Details
434 [Sqlite Developer] Performance minor always 2006-04-26 22:27 2006-07-07 10:16
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.8  
   
now load data on demand instead of loading all data when querying or editing the table.
now load data on demand instead of loading all data when querying or editing the table.
There are no notes attached to this issue.





View Issue Details
532 [Sqlite Developer] Export/Import minor always 2006-08-20 02:24 2006-09-03 00:48
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.1  
   
now export blob data as X'00AABBCC' string when export data as sql
now export blob data as X'00AABBCC' string when export data as sql
There are no notes attached to this issue.





View Issue Details
438 [Sqlite Developer] DBA minor always 2006-05-26 21:48 2006-05-26 21:48
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.5  
   
now double click on table , view ,etc with invoking the edit table, view etc form.
now double click on table , view ,etc with invoking the edit table, view etc form.
There are no notes attached to this issue.





View Issue Details
350 [Sqlite Developer] Parser minor always 2005-11-20 10:13 2005-11-23 01:06
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
now can parse bracket enclosed token , for example create table [test]....
now can parse bracket enclosed token , for example create table [test]....
There are no notes attached to this issue.





View Issue Details
349 [Sqlite Developer] Unicode minor always 2005-11-19 08:18 2005-11-20 00:31
user2  
user2  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
now can edit data in UTF16 database correctly
now can edit data in UTF16 database correctly
There are no notes attached to this issue.





View Issue Details
357 [Sqlite Developer] Unicode minor always 2005-11-24 10:58 2005-12-13 07:36
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.08Beta2  
   
now all data are stored as utf8 in database
now all data are stored as utf8 in database
Notes
(0000041)
sharpplus   
2005-12-01 10:22   
After Add utf8 Support , Edit Table function was failed
(0000043)
sharpplus   
2005-12-12 09:03   
now all changed to utf8 before read and write to database





View Issue Details
974 [Sqlite Developer] Schema Editor minor have not tried 2009-08-08 08:00 2009-08-08 08:10
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
no such table error was displayed when new index for a database without table
no such table error was displayed when new index for a database without table
There are no notes attached to this issue.





View Issue Details
953 [Sqlite Developer] Help minor have not tried 2009-04-15 09:11 2009-04-15 09:11
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.3.x  
   
no response after clicking the help button in options and create database form(regression of ver3.00)
no response after clicking the help button in options and create database form(regression of ver3.00)
There are no notes attached to this issue.





View Issue Details
1044 [Sqlite Developer] GUI minor always 2010-06-25 04:39 2010-06-25 11:11
datac  
sharpplus  
normal  
assigned 3.6.x  
open  
none    
none  
   
No application icon while runing on Windows 7
Running SQLite Developer 3.7.x on a Windows 7 machine only shows the default document icon in the taskabar. See attached image.
Unbenannt.png (63,252) 2010-06-25 04:39
http://mantis.sharpplus.com/file_download.php?file_id=19&type=bug
png

win7.jpg (35,691) 2010-06-25 11:04
http://mantis.sharpplus.com/file_download.php?file_id=20&type=bug
jpg
Notes
(0000275)
sharpplus   
2010-06-25 11:04   
Thank you for your bugreport ,I also uses the windows 7. But I can not reproduce the bug(see the attached screen copy).is the bug always reproduceable.
(0000276)
datac   
2010-06-25 11:11   
It (was) always reproducable, but after your comment I did a little more investigation a noticed, that in the start menu the icon too was this document icon, even though if I opened the properties of the shortcut, the dialog showed the correct SQLDeveloper icon. That made me curious and I reseted my icon cache like that: http://www.winhelponline.com/blog/how-to-rebuild-the-icon-cache-in-windows-vista/ Now the icon is back. Sorry for the false bug report!!!! keep up the good work...





View Issue Details
823 [Sqlite Developer] DBA minor have not tried 2008-08-06 10:52 2008-08-11 08:41
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
  3.0.x  
new pragma function_list and module_list to display installed modules and functions
Get all function and extension list by pragma
There are no notes attached to this issue.





View Issue Details
649 [Sqlite Developer] GUI feature always 2007-05-23 11:05 2007-12-28 22:11
sharpplus  
sharpplus  
normal  
assigned 2.8  
open  
none    
none  
  3.2.x  
new Chart Viewer
new Chart Viewer
There are no notes attached to this issue.





View Issue Details
1031 [Sqlite Developer] Install minor have not tried 2010-03-30 09:23 2010-03-30 09:25
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.6.x  
  3.6.x  
Multiple duplicate Sample DB were registered after installation
Multiple duplicate Sample DB were registered after installation
There are no notes attached to this issue.





View Issue Details
950 [Sqlite Developer] GUI minor have not tried 2009-04-12 02:02 2009-04-12 02:02
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.3.x  
   
Multi selection bug introduced in version 3.00
Multi selection bug introduced in version 3.00
There are no notes attached to this issue.





View Issue Details
851 [Sqlite Developer] GUI minor have not tried 2008-09-07 05:57 2008-09-23 11:18
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
  3.0.x  
multi select should be disabled when the node can not be dropped
should disable multi select can not be dropped nodes(such as table , index)
There are no notes attached to this issue.





View Issue Details
244 [Sqlite Developer] GUI minor always 2005-09-23 23:31 2005-10-08 22:15
user2  
user2  
normal  
closed  
fixed  
none    
none 0.93  
   
Minor tweak of options menu
Minor tweak of options menu
There are no notes attached to this issue.





View Issue Details
279 [Sqlite Developer] SQL Editor minor always 2005-10-14 11:39 2005-10-29 13:13
user2  
user2  
normal  
closed  
fixed  
none    
none 0.97Alpha1  
   
minor tweak DataType display in the auto complete window
minor tweak DataType display in the auto complete window
There are no notes attached to this issue.





View Issue Details
822 [Sqlite Developer] GUI minor have not tried 2008-08-06 04:35 2008-08-11 05:20
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
  3.0.x  
minor combobox's style tweak
Database Information dialog's combobox's style was not dropdownlist
There are no notes attached to this issue.





View Issue Details
885 [Sqlite Developer] DBA minor have not tried 2008-11-27 10:52 2009-05-30 04:30
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
Master-Detail Table Browser
Master-Detail Table Browser
There are no notes attached to this issue.





View Issue Details
659 [Sqlite Developer] GUI minor have not tried 2007-07-16 01:30 2007-07-23 22:48
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
   
Make the menu always show all the items
Make the menu always show all the items
There are no notes attached to this issue.





View Issue Details
642 [Sqlite Developer] Parser minor have not tried 2007-05-05 10:09 2007-05-05 10:09
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
make syntax check provide more clear hint information
make syntax check provide more clear hint information
There are no notes attached to this issue.





View Issue Details
390 [Sqlite Developer] GUI minor always 2005-12-18 09:48 2006-01-15 00:16
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.1RC1  
   
Make splitter more obvious
Make splitter more obvious
There are no notes attached to this issue.





View Issue Details
298 [Sqlite Developer] DBA minor always 2005-10-27 10:12 2005-10-29 13:18
user2  
user2  
normal  
closed  
fixed  
none    
none 0.97Alpha1  
   
make Data type names showed in Table Edit Grid same as the sqlite standard
make Data type names showed in Table Edit Grid same as the sqlite standard
There are no notes attached to this issue.





View Issue Details
810 [Sqlite Developer] Extension minor have not tried 2008-07-26 11:47 2008-10-09 01:22
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
  2.9  
lower funciton of icu display string strange
lower funciton of icu display string strange
Notes
(0000211)
sharpplus   
2008-07-26 22:18   
select lower('I', 'tr_tr') -> 'ı' (small dotless i)
(0000212)
sharpplus   
2008-08-03 03:28   
The problem was caused by widechar to string conversion for example u_strToLower(@dest2[0], 50, 'I', -1, 'tr_tr', errCode); if errCode=0 then ShowMessage(WideCharToString(PWideChar(@dest2[0]))); will show 'i' as '?' the following statement will show 'i' as 'i'(dot less) edt1.Text:=WideString(PWideChar(@dest2[0]));





View Issue Details
1027 [Sqlite Developer] GUI major always 2010-03-15 22:23 2010-03-16 10:10
ve3meo AMD Athlone  
sharpplus Windows XP  
normal SP3  
closed 3.5.x  
no change required  
none    
none  
   
Long integer value in table displayed incorrectly. v3.6.2.458
Column defined as Integer. SELECT Sample value 5630062501345361932 from table Displayed value -1048564 but SELECT 5630062501345361932 displays correctly ORDER BY seems unaffected by this display error
Notes
(0000260)
sharpplus   
2010-03-16 09:00   
Thanks you for your report , I will check it as soon as possible
(0000262)
sharpplus   
2010-03-16 10:10   
Integer Field only accept 32 bit value . 5630062501345361932 is large than 2^32(4294967296)。So you should map the field to int64 instead of integer. SQLite Developer default maps the field type bigint to int64 , so you can change you field type to bigint to test it. Otherwise you should change you mapping with Option dialog | Data Mapping to change you field mapping to int64.





View Issue Details
1035 [Sqlite Developer] SQL Editor minor have not tried 2010-05-23 11:06 2010-05-23 11:06
sharpplus  
 
normal  
new  
open  
none    
none  
  3.6.x  
live syntax waveline was displayed at wrong position
Insert Into [AddressTable] ([AddressID],[Note]) Values("102", X"48616E64793A20303137322D3435382D35382D3135")
There are no notes attached to this issue.





View Issue Details
956 [Sqlite Developer] SQL Editor minor have not tried 2009-05-06 00:53 2009-05-07 02:12
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
live syntax check does not report error for some sql
Select * From MAIN.[City] where CountryCode=?aaa; and report error for Select * From MAIN.[City] where CountryCode=?; Select * From MAIN.[City] where city.id=@NNN and city.Name=$BBB
There are no notes attached to this issue.





View Issue Details
511 [Sqlite Developer] Parser minor always 2006-07-29 22:10 2007-02-25 06:20
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.5  
   
Live Sql Syntax Check(Beta)
Live Sql Syntax Check(Beta)
There are no notes attached to this issue.





View Issue Details
613 [Sqlite Developer] SQL Editor minor have not tried 2007-03-18 02:39 2007-03-18 03:38
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
Live sql syntax check drawed wavy line at wrong position for some sql with chinese fields
Live sql syntax check drawed wavy line at wrong position for some sql with chinese fields select 我是mao SELECT
There are no notes attached to this issue.





View Issue Details
409 [Sqlite Developer] SQL Editor minor always 2006-03-18 00:30 2007-03-18 02:16
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
keyword autocomplete will change the replace text charcase based upon the last inputed char.
keyword autocomplete will change the replace text charcase based upon the last inputed char.
There are no notes attached to this issue.





View Issue Details
175 [Sqlite Developer] DBA minor always 2005-09-02 22:58 2005-09-29 06:31
user2  
user2  
normal  
closed  
fixed  
none    
none 0.89  
   
judge SQL type to refresh db Explorer
create, drop , vacuum , etc
Notes
(0000026)
user2   
2005-09-15 09:40   
support drop commands
(0000027)
user2   
2005-09-16 12:49   
support create, drop , alter table commands





View Issue Details
987 [Sqlite Developer] Parser minor have not tried 2009-10-02 13:50 2009-10-06 09:48
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.5.x  
  3.5.x  
incorrectly format some sql
create temp trigger t1 before insert on abc for each row begin end
There are no notes attached to this issue.





View Issue Details
1042 [Sqlite Developer] Export/Import tweak always 2010-06-04 11:03 2010-07-24 00:20
rsotolongo Intel x86  
sharpplus Windows  
normal 7  
closed 3.6.x  
fixed  
none    
none 3.7.x  
   
Incorrect tables order on "Extract database schema and data
SQLite Developer export tables of database schema in the same order that the tables appears on the left exploration tree instead of export in the correct order according the the restrictions of some tables over other ones depending of the relationships.
If you have tables with relationships between them (table A and table B) if table A have a foreign key to table B in theory the table B should appear before than table A in the generated script in order to insert correctly the data records and reproduce the exact database.
TableOrder (ok).sql (3,636) 2010-07-16 04:52
http://mantis.sharpplus.com/file_download.php?file_id=21&type=bug
TableOrder (bug).sql (7,356) 2010-07-16 04:52
http://mantis.sharpplus.com/file_download.php?file_id=22&type=bug
Notes
(0000272)
sharpplus   
2010-06-05 13:25   
Thank you for your bug report. I will fix it in the next version
(0000273)
sharpplus   
2010-06-06 10:18   
I just fixed the problem. Please try with the latest version http://www.sqlitedeveloper.com/downloads/SqliteDev372.zip
(0000277)
rsotolongo   
2010-07-16 04:51   
(edited on: 2010-07-16 04:53)
The order was improved but not solved. The first .sql file ("TableOrder (ok).sql") is written at hand with the correct order of table according to the dependencies of foreign relationships. The second .sql file ("TableOrder (bug).sql") is the file that SQLite Developer generates in the "Export database schema and data" option. I think that this tool is amazing but I spend a lot of time fixing sql sentences to export and import schema and data. Thank you...
(0000278)
sharpplus   
2010-07-18 04:24   
Thank you for your report, I will check it as soon as possible.
(0000279)
sharpplus   
2010-07-24 00:20   
Dear Sir, I just fixed the incorrectly extracted sql , please try with http://www.sqlitedeveloper.com/downloads/SqliteDev377.zip.





View Issue Details
648 [Sqlite Developer] Schema Editor minor have not tried 2007-05-13 08:26 2009-02-10 03:45
sharpplus  
sharpplus  
normal  
closed 2.7  
fixed  
none    
none 2.7  
  2.7  
In View and Trigger Editor , that input dot in sql editor would cause access violation
In View and Trigger Editor , that input dot in sql editor would cause access vialation
There are no notes attached to this issue.





View Issue Details
583 [Sqlite Developer] GUI minor always 2006-11-12 05:53 2007-01-21 00:16
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.4  
  2.4  
Improved the visual database schema editor
Improved the visual database schema editor
Notes
(0000071)
user15   
2006-11-23 10:49   
Add Mouse Panning Function





View Issue Details
451 [Sqlite Developer] GUI minor always 2006-06-20 01:26 2009-02-10 03:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none  
   
improved the SQL Editor's Button State Control
improved the SQL Editor's Button State Control, use thread to execute query
There are no notes attached to this issue.





View Issue Details
443 [Sqlite Developer] Performance minor always 2006-05-28 12:45 2006-05-28 12:46
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.6  
   
Improved the loading speed of sqlite developer
Improved the loading speed of sqlite developer
There are no notes attached to this issue.





View Issue Details
531 [Sqlite Developer] Parser minor always 2006-08-20 02:19 2007-02-03 05:19
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.5  
   
Improved parsing the expression
Improve parsing the expression
There are no notes attached to this issue.





View Issue Details
403 [Sqlite Developer] DBA minor always 2006-02-26 06:05 2006-02-26 06:05
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.1RC1  
   
improve the unique constriants support
improve the unique constriants support
There are no notes attached to this issue.





View Issue Details
1021 [Sqlite Developer] DBA minor have not tried 2010-02-07 08:55 2010-03-12 09:34
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.6.x  
  3.6.x  
Improve the test data generator speed
Improve the test data generator speed
There are no notes attached to this issue.





View Issue Details
404 [Sqlite Developer] Install minor always 2006-02-26 10:53 2006-03-18 02:25
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.2RC2  
   
improve the sample database with constraints
improve the sample database with constraints
There are no notes attached to this issue.





View Issue Details
804 [Antlr For Delphi Target] General minor have not tried 2008-07-20 04:07 2008-07-20 04:07
sharpplus  
 
normal  
new  
open  
none    
none  
   
Improve the performance of DFA create which is very expensive now
Improve the performance of DFA create which is very expensive now
There are no notes attached to this issue.





View Issue Details
898 [Sqlite Developer] Performance minor have not tried 2009-01-17 05:54 2009-01-17 09:00
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.2.x  
  3.2.x  
Improve the performance for executing script
Improve the performance for executing script
There are no notes attached to this issue.





View Issue Details
510 [Sqlite Developer] Parser minor always 2006-07-27 10:12 2006-07-28 09:47
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.9  
   
Improve the multiple sql parsing
Improve the multiple sql parsing
There are no notes attached to this issue.





View Issue Details
666 [Sqlite Developer] Help minor have not tried 2007-07-24 11:25 2008-08-12 00:29
sharpplus  
 
normal  
closed  
fixed  
none    
none  
  3.0.x  
Improve the Help
Improve the Help
There are no notes attached to this issue.





View Issue Details
789 [Sqlite Developer] GUI minor have not tried 2008-03-15 05:27 2008-03-15 08:54
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
Improve Query Builder and Import Data Form GUI
Improve Query Builder and Import Data Form GUI
There are no notes attached to this issue.





View Issue Details
811 [Sqlite Developer] SQL Editor minor have not tried 2008-07-26 23:54 2008-07-26 23:54
sharpplus  
 
normal  
new  
open  
none    
none  
   
Improve FieldComplete
Now FieldComplete only can be invoked by dot , should show field complete at expression input
There are no notes attached to this issue.





View Issue Details
581 [Sqlite Developer] Export/Import minor always 2006-11-05 06:45 2006-11-11 05:41
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.4  
   
Improve Field Mapping for CSV Import Wizard
Improve Field Mapping for CSV Import Wizard
There are no notes attached to this issue.





View Issue Details
819 [Sqlite Developer] Export/Import minor have not tried 2008-08-03 04:29 2008-08-12 07:18
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
  3.0.x  
Importing cvs to table which has data is now 10x faster than before.
Performance of Import and memory usage very poor
There are no notes attached to this issue.





View Issue Details
908 [Sqlite Developer] Export/Import major always 2009-02-09 15:16 2009-02-11 01:05
skneife  
sharpplus  
normal  
closed 3.1.x  
fixed  
none    
none 3.2.x  
  3.2.x  
Importation of Northwind from SQLServer failed
3 tables generated an exception. See attached file
ImportDbNorthwindErrors.jpg (51,125) 2009-02-09 15:16
http://mantis.sharpplus.com/file_download.php?file_id=12&type=bug
jpg
Notes
(0000224)
sharpplus   
2009-02-09 22:55   
Thank you for your bug report ,by the way would you please tell me the SQL Server version?
(0000225)
skneife   
2009-02-10 14:52   
Sql Server 2005
(0000226)
sharpplus   
2009-02-11 01:05   
I just fixed this problem, please try it with version 3.27 http://www.sqlitedeveloper.com/downloads/SqliteDev327.zip





View Issue Details
658 [Sqlite Developer] Export/Import minor have not tried 2007-07-16 01:15 2007-07-16 01:15
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
Import Sqlite Database feature
mport Sqlite Database feature
There are no notes attached to this issue.





View Issue Details
315 [Sqlite Developer] Export/Import minor always 2005-11-05 08:51 2005-11-06 04:20
user2  
user2  
normal  
closed  
fixed  
none    
none 1.02Alpha2  
   
Import data from CSV when edit table data
Import data from CSV when edit table data
There are no notes attached to this issue.





View Issue Details
494 [Sqlite Developer] DBA minor always 2006-07-13 08:51 2006-07-14 22:25
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.8  
   
Import Data from csv also broken in ver 1.75
Import Data from csv also broken in ver 1.75
There are no notes attached to this issue.





View Issue Details
948 [Sqlite Developer] Export/Import minor have not tried 2009-04-09 10:19 2009-04-09 10:19
sharpplus  
 
normal  
new  
open  
none    
none  
  3.4.x  
Import csv with any column and any length data
Import csv with any column and any length data
There are no notes attached to this issue.





View Issue Details
795 [Sqlite Developer] SQL Editor feature have not tried 2008-06-29 08:36 2009-04-08 00:13
sharpplus  
 
normal  
new  
open  
none    
none  
  3.4.x  
implement structure highlight
implement structure highlight
There are no notes attached to this issue.





View Issue Details
218 [Sqlite Developer] DBA minor always 2005-09-13 11:49 2009-05-19 08:39
user2  
 
normal  
new  
open  
none    
none  
  3.4.x  
implement sqlite analyzer function
implement sqlite analyzer function
There are no notes attached to this issue.





View Issue Details
167 [Sqlite Developer] Parser minor always 2005-09-01 09:01 2005-09-29 06:27
user2  
user2  
normal  
closed  
fixed  
none    
none 0.84  
   
implement SQL AutoComplete
implement SQL AutoComplete
Notes
(0000025)
user2   
2005-09-10 09:38   
Focus was conflicted with Dock Form?





View Issue Details
796 [Sqlite Developer] SQL Editor minor have not tried 2008-07-05 15:36 2008-07-05 15:36
sharpplus  
 
normal  
new  
open  
none    
none  
  2.9  
Implement rename refactor function
Implement rename refactor function
There are no notes attached to this issue.





View Issue Details
849 [Sqlite Developer] Option minor have not tried 2008-09-06 12:38 2008-09-06 12:38
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
   
if date separator or time separator of options setting form is empty, press ok button to save settings will cause exception
if date separator or time separator of options setting form is empty, press ok button to save settings will cause exception
There are no notes attached to this issue.





View Issue Details
1024 [Sqlite Developer] GUI minor have not tried 2010-03-12 09:35 2010-03-12 09:40
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.6.x  
   
icon of field was not displayed (regression of 3.60)
icon of field was not displayed (regression of 3.60)
There are no notes attached to this issue.





View Issue Details
739 [Sqlite Developer] Help minor have not tried 2008-01-18 10:16 2008-01-19 09:58
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
Help of SQL Editor's shortcut was messed up
Help of SQL Editor's shortcut was messed up
There are no notes attached to this issue.





View Issue Details
449 [Sqlite Developer] SQL Editor minor always 2006-06-17 09:20 2006-06-17 09:20
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.6  
   
Get Previous SQL function was broken
Get Previous SQL function was broken
There are no notes attached to this issue.





View Issue Details
596 [Sqlite Developer] DBA minor have not tried 2007-01-26 06:56 2007-01-26 08:13
sharpplus  
 
normal  
closed  
fixed  
none    
none  
   
generated create index sql with one more semi
Begin Transaction; Create TABLE Temp_858603625( [COUNTRY] VARCHAR(15) NOT NULL ,[CURRENCY] VARCHAR(10) NOT NULL , Primary Key(COUNTRY) ); Insert Into Temp_858603625 ([COUNTRY],[CURRENCY]) Select [COUNTRY],[CURRENCY] From [COUNTRY]; Drop Table [COUNTRY]; Alter Table Temp_858603625 Rename To [COUNTRY]; CREATE INDEX [aaa] On [COUNTRY] ( [COUNTRY] , [CURRENCY] ) ; ; CREATE INDEX [ttt] On [COUNTRY] ( [COUNTRY] ) ; ; CREATE INDEX [gfg] On [COUNTRY] ( [COUNTRY] , [CURRENCY] ) ; ; Commit Transaction;
There are no notes attached to this issue.





View Issue Details
525 [Sqlite Developer] DBA minor always 2006-08-16 00:57 2006-08-16 00:57
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.0  
   
generate wrong create table sql for field name with space
generate wrong create table sql for field name with space
There are no notes attached to this issue.





View Issue Details
959 [Sqlite Developer] DBA minor have not tried 2009-05-09 22:23 2009-08-02 01:59
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
Generate trigger for foreign key fields
Generate trigger for foreign key fields
There are no notes attached to this issue.





View Issue Details
985 [Sqlite Developer] Print minor have not tried 2009-09-30 00:13 2009-11-08 06:25
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.5.x  
  3.5.x  
Generate Database Schema Report(RTF)
Generate Database Schema Report(RTF)
There are no notes attached to this issue.





View Issue Details
831 [Antlr For Delphi Target] General minor have not tried 2008-08-13 06:24 2008-08-13 06:24
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.1  
  3.1  
generate correct init value for type with uppercase char
will generate correct init value for type with uppercase char
There are no notes attached to this issue.





View Issue Details
980 [Sqlite Developer] Schema Editor minor have not tried 2009-09-23 03:41 2009-09-23 10:42
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.5.x  
  3.5.x  
Foreign Key will not be generated sometimes
Foreign Key will not be generated sometimes
There are no notes attached to this issue.





View Issue Details
990 [Sqlite Developer] Schema Editor minor have not tried 2009-10-18 05:58 2009-10-20 10:29
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.5.x  
  3.5.x  
foreign Key Editor supports oninsert , ondelete , deferrable and composite foreign key
foreign Key Editor supports oninsert , ondelete , deferrable and composite foreign key
There are no notes attached to this issue.





View Issue Details
850 [Sqlite Developer] Data Editor minor have not tried 2008-09-06 12:39 2008-09-06 12:40
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
   
Fixed: can not display and edit float correctly on germany system
Fixed: can not display and edit float correctly on germany system
There are no notes attached to this issue.





View Issue Details
280 [Sqlite Developer] DBA minor always 2005-10-14 11:42 2005-11-20 00:24
user2  
user2  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
Fixed some minor problem with creating temp index
Fixed some minor problem with creating temp index
Notes
(0000032)
user2   
2005-10-15 04:36   
should use temp, main to judge the table and view type





View Issue Details
639 [Sqlite Developer] Other minor have not tried 2007-05-01 00:34 2007-05-01 05:21
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
Fixed some memory leak and resource leak
Fixed some memory leak and resource leak
There are no notes attached to this issue.





View Issue Details
514 [Sqlite Developer] DBA minor always 2006-08-05 02:20 2006-08-05 05:47
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.0  
   
fixed several bugs of field data edit dialog
fixed several bugs of field data dialog
There are no notes attached to this issue.





View Issue Details
587 [Sqlite Developer] GUI minor have not tried 2007-01-22 08:45 2007-01-22 08:45
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.4  
   
Fixed several bugs introduced in ver 2.36
Fixed several bugs introduced in ver 2.36
There are no notes attached to this issue.





View Issue Details
523 [Sqlite Developer] Parser minor always 2006-08-12 11:43 2006-08-12 11:47
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.0  
   
Fixed replace conflict clause parse (Introduced in ver 1.70)
Fixed replace conflict clause parse
There are no notes attached to this issue.





View Issue Details
607 [Sqlite Developer] Unicode minor have not tried 2007-02-23 22:14 2007-02-23 22:14
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.5  
   
Fixed load List index out of bounds(0) error when click option menu on some non-english locale systems.
Fixed load List index out of bounds(0) error when click option menu on some non-english locale systems.
There are no notes attached to this issue.





View Issue Details
588 [Sqlite Developer] GUI minor have not tried 2007-01-24 08:05 2007-01-24 08:05
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.4  
   
Fixed insert field bug introduced in ver2.36
Fixed insert field bug introduced in ver2.36
There are no notes attached to this issue.





View Issue Details
968 [Sqlite Developer] Other minor have not tried 2009-07-17 11:29 2009-07-19 04:08
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
Fix virtual store on vista problem
Fix virtual store on vista problem
There are no notes attached to this issue.





View Issue Details
662 [Sqlite Developer] GUI minor have not tried 2007-07-16 02:04 2007-07-23 22:36
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
   
Fix the Schema Editor's Save Icon
Fix the Schema Editor's Save Icon
There are no notes attached to this issue.





View Issue Details
628 [Sqlite Developer] Unicode minor have not tried 2007-04-21 08:47 2007-04-21 08:47
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
Fix some bugs with charencoding
Fix some bugs with charencoding
There are no notes attached to this issue.





View Issue Details
574 [Sqlite Developer] Parser minor always 2006-10-13 00:45 2006-10-13 10:01
sharpplus  
 
normal  
closed  
fixed  
none    
none  
   
Fix single comment without newline problem
Fix single comment without newline problem
There are no notes attached to this issue.





View Issue Details
798 [Antlr For Delphi Target] General minor have not tried 2008-07-06 03:48 2008-07-12 01:24
sharpplus  
 
normal  
closed  
fixed  
none    
none  
   
Fix Memory leak with Antlr 3.1b1 's setparent
Fix Memory leak with Antlr 3.1b1 's setparent
There are no notes attached to this issue.





View Issue Details
669 [Sqlite Developer] Other minor have not tried 2007-08-05 08:31 2007-08-05 08:31
sharpplus  
 
normal  
new  
open  
none    
none  
   
Fix Memory Leak
Fix Memory Leak
There are no notes attached to this issue.





View Issue Details
522 [Sqlite Developer] DBA minor always 2006-08-09 10:40 2006-08-11 20:50
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.0  
   
Fix an AV When execute large sql script
Fix an AV When execute large sql script
foods.sql (57,068) 2006-08-09 10:40
http://mantis.sharpplus.com/file_download.php?file_id=4&type=bug
sql.sql (16,584) 2006-08-09 10:41
http://mantis.sharpplus.com/file_download.php?file_id=5&type=bug
There are no notes attached to this issue.





View Issue Details
667 [Sqlite Developer] GUI minor have not tried 2007-07-31 10:46 2007-08-05 06:26
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
   
Fix all the font of controls
Fix all the font of controls
There are no notes attached to this issue.





View Issue Details
926 [Sqlite Developer] Export/Import major always 2009-02-24 16:47 2009-02-28 23:54
skneife  
 
normal  
closed 3.2.x  
fixed  
none    
none 3.3.x  
  3.3.x  
Fileds types are lost when Importing northwind database from SQL Server 2005
I have imported the northwind database from SQL Server 2005. All tables are fully imported but many fields types are lost !! For example the table customers has no type for all fields (see my attached file).
Northwind_customers.jpg (56,580) 2009-02-24 16:47
http://mantis.sharpplus.com/file_download.php?file_id=14&type=bug
jpg
Notes
(0000232)
sharpplus   
2009-02-24 19:13   
Thank you for your bug report, I will fix it as soon as possible
(0000236)
sharpplus   
2009-02-28 23:54   
I just fixed this problem, please try with http://www.sqlitedeveloper.com/downloads/SqliteDev331.zip





View Issue Details
399 [Sqlite Developer] Unicode major always 2006-01-31 05:44 2006-02-19 00:24
user15  
 
normal  
closed 1.1RC1  
fixed  
none    
none 1.1RC1  
   
Field of type text with char code above 127 doesn't show
If a field of type text has any char code above 127 nothing shows up. I attach a DB, look for the "message" field in the table CommitLog.
audit.sq3 (94,208) 2006-01-31 05:44
http://mantis.sharpplus.com/file_download.php?file_id=3&type=bug
There are no notes attached to this issue.





View Issue Details
937 [Sqlite Developer] SQL Editor minor have not tried 2009-04-03 22:28 2009-04-17 22:03
sharpplus  
 
normal  
new  
open  
none    
none  
  3.4.x  
Field Completion for Trigger New and Old keyword
Field Completion for Trigger New and Old keyword
There are no notes attached to this issue.





View Issue Details
817 [Sqlite Developer] SQL Editor minor have not tried 2008-08-03 01:32 2008-08-03 01:32
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
   
Field Complete sometimes was not invoked
Field Complete sometimes was not invoked
There are no notes attached to this issue.





View Issue Details
654 [Sqlite Developer] DBA minor have not tried 2007-07-06 23:06 2007-07-06 23:06
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
Failed to create database when locking mode was not specified (Introduced in ver2.67)
Failed to create database when locking mode was not specified (Introduced in ver2.67)
There are no notes attached to this issue.





View Issue Details
145 [Sqlite Developer] DBA minor always 2005-08-22 21:24 2005-09-29 06:31
user2  
user2  
normal  
closed  
fixed  
none    
none 0.89  
   
Extract Database Schema
Extract Database Schema
There are no notes attached to this issue.





View Issue Details
657 [Sqlite Developer] Export/Import minor have not tried 2007-07-15 07:40 2007-07-15 10:12
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
Exporting Data as sql, xls, html, xml always generated csv file on vista (regression of ver2.60)
Exporting Data as sql, xls, html, xml always generated csv file on vista (regression of ver2.60)
There are no notes attached to this issue.





View Issue Details
570 [Sqlite Developer] Export/Import minor always 2006-10-09 07:55 2006-10-14 22:04
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.3  
   
exported drop schema sql does not support table name with space
exported drop schema sql does not support table name with space
There are no notes attached to this issue.





View Issue Details
890 [Sqlite Developer] Export/Import minor have not tried 2008-12-02 08:37 2008-12-10 08:23
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.2.x  
  3.2.x  
Export to Xls and word do not work (regression of ver3.00)
Export to Xls and word do not work (regression of ver3.00)
There are no notes attached to this issue.





View Issue Details
364 [Sqlite Developer] Export/Import minor always 2005-11-26 02:01 2005-12-13 07:28
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 1.08Beta2  
   
Export Data as SQL
Export Data as SQL
There are no notes attached to this issue.





View Issue Details
498 [Sqlite Developer] Export/Import minor always 2006-07-15 23:12 2006-09-14 09:16
sharpplus  
 
normal  
new  
open  
none    
none  
   
export audit commitlog table generate wrong csv file
export audit commitlog table generate wrong csv file
Notes
(0000063)
sharpplus   
2006-09-14 09:16   
because data has 0a linebreak char and has "XXXX" data





View Issue Details
192 [Sqlite Developer] DBA minor always 2005-09-04 21:06 2005-09-29 06:28
user2  
user2  
normal  
closed  
fixed  
none    
none 0.84  
   
Explain does not have result show
Explain does not have result show
There are no notes attached to this issue.





View Issue Details
893 [Sqlite Developer] DBA minor have not tried 2008-12-19 20:27 2008-12-19 21:16
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.2.x  
  3.2.x  
executing query multiple times will cause exception(regression of ver3.20)
executing query multiple times will cause exception(regression of ver3.20)
There are no notes attached to this issue.





View Issue Details
546 [Sqlite Developer] DBA minor always 2006-09-13 08:38 2006-09-13 10:41
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.2  
   
executing pragma xxx return multiple same records instead of one record (introduced in 1.75)
executing pragma xxx return multiple same records instead of one record (introduced in 1.75)
There are no notes attached to this issue.





View Issue Details
675 [Sqlite Developer] Parser minor have not tried 2007-09-19 08:27 2007-09-21 22:01
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
   
executing pragma index_list(tablename) will not display the results in dbgrid (regression of Ver2.69)
executing pragma index_list(tablename) will not display the results in dbgrid (regression of Ver2.69)
There are no notes attached to this issue.





View Issue Details
651 [Sqlite Developer] SQL Editor minor have not tried 2007-07-05 09:48 2007-07-07 00:01
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
executing pragma function(arg) caused the result grid to be displayed
executing pragma function(arg) caused the result grid to be displayed
There are no notes attached to this issue.





View Issue Details
242 [Sqlite Developer] DBA minor always 2005-09-23 23:25 2005-10-08 22:14
user2  
user2  
normal  
closed  
fixed  
none    
none 0.93  
   
Execute sql does not hide the result tab
Execute sql does not hide the result tab create temp view view3 as select * from sqlite_master
Notes
(0000030)
user2   
2005-09-25 07:51   
reproduce steps: Execute view view "View1"





View Issue Details
957 [Sqlite Developer] DBA minor have not tried 2009-05-07 02:13 2009-05-07 03:40
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
execute paramerize query with $ parameter will report no such column error
execute paramerize query with $ parameter will report no such column error Select * From MAIN.[City] where city.id=@NNN and city.Name=$BBB
There are no notes attached to this issue.





View Issue Details
933 [Sqlite Developer] Export/Import minor have not tried 2009-03-26 09:29 2009-03-26 09:30
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.3.x  
   
EXCEPTION:Too many fields, or too many long string fields in this record.You must increase the internal record size of the csvDa
EXCEPTION:Too many fields, or too many long string fields in this record.You must increase the internal record size of the csvDataSet
There are no notes attached to this issue.





View Issue Details
906 [Sqlite Developer] Parser block always 2009-02-04 16:28 2009-02-09 15:12
skneife  
sharpplus  
normal  
closed  
fixed  
none    
none 3.2.x  
  3.2.x  
Error when opening a Table : MismatchedTokenException (10<>169)
I have registered a database created with sqliteadmin.exe with 4 tables. Only one opened without error. The others throw this exception : MismatchedTokenException (10<>169). Notice that tere is no records inside. This database is well opened with SQLite2008 Pro Enterprise Manager.
CartesDB.s3db (11,264) 2009-02-04 16:28
http://mantis.sharpplus.com/file_download.php?file_id=11&type=bug
Notes
(0000221)
sharpplus   
2009-02-06 08:08   
Thank you for your bug report, I will check it this weekend
(0000222)
sharpplus   
2009-02-07 03:01   
I just fixed this problem , You can test it with new version 3.26 http://www.sqlitedeveloper.com/downloads/SqliteDev326.zip





View Issue Details
876 [Sqlite Developer] Option minor have not tried 2008-10-05 23:45 2008-10-05 23:45
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
   
Error reading seOption.Lines.WideStrings: Property WideStrings does not exist.( regression of 3.01)
Error reading seOption.Lines.WideStrings: Property WideStrings does not exist.( regression of 3.01)
There are no notes attached to this issue.





View Issue Details
1048 [Sqlite Developer] SQL Editor minor have not tried 2010-07-31 06:59 2010-07-31 06:59
sharpplus  
 
normal  
new  
open  
none    
none  
   
editor change was displayed incorrectly.
editor change was displayed incorrectly.
There are no notes attached to this issue.





View Issue Details
556 [Sqlite Developer] GUI minor always 2006-09-16 22:14 2006-09-16 22:14
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.2  
   
editing table, index, etc will check previous edit form existence before invoking a new edit form
editing table, index, etc will check previous edit form existence before invoking a new edit form
There are no notes attached to this issue.





View Issue Details
414 [Sqlite Developer] GUI minor always 2006-03-18 02:02 2006-03-18 03:05
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.2RC2  
   
editboxes in Schema Edit Forms did not support clipboard operations
editboxes in Schema Edit Forms did not support clipboard operations
There are no notes attached to this issue.





View Issue Details
1030 [Sqlite Developer] SQL Editor minor have not tried 2010-03-30 08:12 2010-03-30 08:23
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.6.x  
  3.6.x  
duplicate keywords were added in Auto complete list
duplicate keywords were added in Auto complete list
There are no notes attached to this issue.





View Issue Details
292 [Sqlite Developer] DBA minor always 2005-10-22 21:51 2005-10-29 13:15
user2  
user2  
normal  
closed  
fixed  
none    
none 0.97Alpha1  
   
drop table, view and refresh the indexes and triggers at the same time
drop table, view and refresh the indexes and triggers at the same time
There are no notes attached to this issue.





View Issue Details
592 [Sqlite Developer] GUI minor have not tried 2007-01-24 08:12 2007-01-26 08:14
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.4  
   
drag drop function in Visual Schema Editor
drag drop function in Visual Schema Editor
There are no notes attached to this issue.





View Issue Details
863 [Sqlite Developer] Schema Editor minor have not tried 2008-09-28 08:09 2008-09-28 08:09
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
   
double click on Trigger List of Table Editor will cause list out of index error
double click on Trigger List of Table Editor will cause list out of index error
There are no notes attached to this issue.





View Issue Details
1006 [Sqlite Developer] GUI minor have not tried 2009-11-13 19:52 2009-11-13 19:52
sharpplus  
 
normal  
new  
open  
none    
none  
  3.5.x  
double click in treeview will induce strange view
double click in treeview will induce strange view
There are no notes attached to this issue.





View Issue Details
166 [Sqlite Developer] Parser minor always 2005-09-01 09:01 2005-09-29 06:29
user2  
user2  
normal  
closed  
fixed  
none    
none 0.84  
   
Does not Show Pragma Result
Does not Show Pragma Result,need to hide datagrid when execute pragma name=value
There are no notes attached to this issue.





View Issue Details
763 [Sqlite Developer] Schema Editor minor have not tried 2008-02-07 09:23 2008-02-07 09:48
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
does not show old ddl for index or trigger when executing index/trigger edition from table schema editor
does not show old ddl for index or trigger when executing index/trigger edition from table schema editor
There are no notes attached to this issue.





View Issue Details
1025 [Sqlite Developer] GUI minor always 2010-03-12 23:19 2010-03-16 09:09
Gillissie Windows  
sharpplus Vista  
normal  
closed 3.5.x  
fixed  
none    
none 3.6.x  
  3.6.x  
Does not save changs?
This confirmation dialog box makes no sense. I think what you're trying to ask is, "Close without saving changes?" (note the "e" in the word "changes")
Make a change to a table schema. Close the window without saving the changes first.
Notes
(0000258)
sharpplus   
2010-03-16 08:58   
Thank you for your bug report, Sorry for my bad English. I will fix it as soon as possible
(0000261)
sharpplus   
2010-03-16 09:09   
Fixed . Will be available in the next version





View Issue Details
340 [Sqlite Developer] DBA minor always 2005-11-18 08:22 2005-11-20 00:26
user2  
user2  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
does not refresh the display order in treeview after renaming the table
does not refresh the display order in treeview after renaming the table
There are no notes attached to this issue.





View Issue Details
622 [Sqlite Developer] SQL Editor minor have not tried 2007-04-08 02:59 2007-04-08 03:27
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
does not prompt table/view complete for some sql
does not prompt table/view complete for some sql for example: Select * from [COUNTRY] c, de| where 1>2
There are no notes attached to this issue.





View Issue Details
625 [Sqlite Developer] SQL Editor minor have not tried 2007-04-08 04:01 2007-04-14 10:53
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
does not prompt field complete for some sql
Select * from [COUNTRY] c, department d where c.COUNTRY<>d.|
There are no notes attached to this issue.





View Issue Details
676 [Sqlite Developer] SQL Editor minor have not tried 2007-09-23 12:48 2007-12-28 22:49
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
  2.8  
Do syntax check before executing sql script
Do syntax check before executing sql script
There are no notes attached to this issue.





View Issue Details
216 [Sqlite Developer] Parser minor always 2005-09-12 04:49 2005-09-29 06:32
user2  
user2  
normal  
closed  
fixed  
none    
none 0.89  
   
Do not invoke autocomplete in comment block
Do not invoke autocomplete in comment block
Notes
(0000028)
user2   
2005-09-17 00:28   
and disable autocomplete when in Qutoed String Block





View Issue Details
944 [Sqlite Developer] Schema Editor minor have not tried 2009-04-08 00:05 2009-04-08 10:57
sharpplus  
 
normal  
new  
open  
none    
none  
  3.4.x  
do not close the schema editor after commit the schema change
do not close the schema editor after commit the schema change
There are no notes attached to this issue.





View Issue Details
246 [Sqlite Developer] GUI minor always 2005-09-25 01:35 2005-10-08 22:25
user2  
user2  
normal  
closed  
fixed  
none    
none 0.93  
   
display sqlite3 DLL version in About Dialog
display sqlite3 DLL version in About Dialog
There are no notes attached to this issue.





View Issue Details
955 [Sqlite Developer] SQL Editor minor have not tried 2009-05-05 09:41 2009-05-05 22:12
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
Display Modified line on Gutter
Display Modified line on Gutter
There are no notes attached to this issue.





View Issue Details
738 [Sqlite Developer] GUI minor have not tried 2008-01-13 05:45 2008-02-01 09:59
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
Display Attached DB Path
Display Attached DB Path
There are no notes attached to this issue.





View Issue Details
521 [Sqlite Developer] Export/Import minor always 2006-08-05 22:00 2006-08-05 22:00
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.0  
   
Disable the auto quotes for filename include space in Export/Import dialog which will cause import to fail
Disable the auto quotes for filename include space in Export/Import dialog which will cause import to fail
There are no notes attached to this issue.





View Issue Details
425 [Sqlite Developer] DBA minor always 2006-04-09 06:58 2006-04-09 09:37
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.3  
   
disable rename table function for system tables such as sqlite_master
disable rename table function for system tables such as sqlite_master
There are no notes attached to this issue.





View Issue Details
614 [Sqlite Developer] SQL Editor minor have not tried 2007-03-18 06:26 2007-03-31 07:49
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
disable keyword complete in string
disable keyword complete in string
There are no notes attached to this issue.





View Issue Details
182 [Sqlite Developer] DBA minor always 2005-09-04 00:25 2005-09-29 06:26
user2  
user2  
normal  
closed  
fixed  
none    
none 0.84  
   
disable Edit Table for System Table
disable Edit Table for System Table
There are no notes attached to this issue.





View Issue Details
293 [Sqlite Developer] DBA minor always 2005-10-22 22:30 2005-10-29 13:18
user2  
user2  
normal  
closed  
fixed  
none    
none 0.97Alpha1  
   
disable edit system table
disable edit system table
There are no notes attached to this issue.





View Issue Details
455 [Sqlite Developer] GUI minor always 2006-06-20 05:44 2006-06-20 07:21
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.7  
   
disable double click edit function for system objects(Introduced in ver1.5)
disable double click edit function for system objects
There are no notes attached to this issue.





View Issue Details
310 [Sqlite Developer] DBA minor always 2005-10-31 10:08 2005-11-06 04:25
user2  
user2  
normal  
closed  
fixed  
none    
none 1.02Alpha2  
   
disable blob and string editor when there is not data in dataset
disable blob and string editor when there is not data in dataset
There are no notes attached to this issue.





View Issue Details
463 [Sqlite Developer] GUI minor always 2006-06-24 22:04 2006-06-24 22:04
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.7  
   
did not validate the empty index, trigger, table, view name when editing the db schema
did not validate the empty index, trigger, table, view name when editing the db schema
There are no notes attached to this issue.





View Issue Details
838 [Sqlite Developer] Schema Editor minor have not tried 2008-08-20 08:33 2008-08-20 08:35
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
  3.0.x  
Delete Trigger was not disabled even when there was no trigger (regression of 2.36)
Delete Trigger was not disabled even when there was no trigger(regression of 2.36)
There are no notes attached to this issue.





View Issue Details
636 [Sqlite Developer] Schema Editor minor have not tried 2007-04-27 21:31 2007-04-28 05:44
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
delete index and trigger from view and table editor will raise access violation(Introduced in 2.39)
delete index and trigger from view and table editor will raise access violation(Introduced in 2.39)
There are no notes attached to this issue.





View Issue Details
900 [Sqlite Developer] Data Editor minor have not tried 2009-01-24 00:59 2009-02-10 03:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.2.x  
  3.2.x  
Delete , Post , Cancel, Copy button in Data Edit Form were always disabled (regression of ver3.15)
Delete , Post , Cancel, Copy button in Data Edit Form were always disabled (regression of ver3.15)
There are no notes attached to this issue.





View Issue Details
459 [Sqlite Developer] DBA minor always 2006-06-23 22:20 2006-06-23 22:20
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.7  
   
Default Cache Size and Page Size Settings was not setted on Creating database
Default Cache Size and Page Size Settings was not setted on Creating database
There are no notes attached to this issue.





View Issue Details
1017 [Sqlite Developer] Data Access Component crash have not tried 2010-01-08 09:27 2010-01-08 21:37
sharpplus  
sharpplus  
normal  
resolved  
fixed  
none    
none 3.5.x  
  3.5.x  
Deadlock when open a table which has a size larger than 8192 data in string field .
Deadlock when open a table which has a size larger than 8192 data in string field .
There are no notes attached to this issue.





View Issue Details
231 [Sqlite Developer] DBA minor always 2005-09-19 05:54 2005-09-29 06:33
user2  
user2  
normal  
closed  
fixed  
none    
none 0.89  
   
DBExplorer will show plus sign before node when childcount=0 and sys-objects not equal 0
DBExplorer will show plus sign before node when childcount=0 and sys-objects not equal 0
There are no notes attached to this issue.





View Issue Details
180 [Sqlite Developer] DBA minor always 2005-09-03 22:18 2005-09-29 06:26
user2  
user2  
normal  
closed  
fixed  
none    
none 0.84  
   
DataGrid can not display multi line data
DataGrid can not display multi line data
Notes
(0000023)
user2   
2005-09-06 10:13   
Now double Click on field data can show multi_line Memo content





View Issue Details
437 [Sqlite Developer] DBA minor always 2006-05-26 12:03 2006-05-26 12:13
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.5  
   
Database Intergration Check was broken (introduced in ver 1.42)
Database Intergration Check was broken (introduced in ver 1.42)
There are no notes attached to this issue.





View Issue Details
572 [Sqlite Developer] DBA minor always 2006-10-10 21:59 2006-10-14 05:11
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.3  
   
database encoding was persisted incorrectly
database encoding was persisted incorrectly
There are no notes attached to this issue.





View Issue Details
535 [Sqlite Developer] Export/Import minor always 2006-08-26 19:55 2008-11-26 09:22
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.1.x  
  3.1.x  
Data Transfer Wizard and Import Data from Ado
Data Transfer Wizard and Import Data from Ado
There are no notes attached to this issue.





View Issue Details
978 [Sqlite Developer] Schema Editor minor have not tried 2009-09-11 10:08 2009-09-11 10:15
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.5.x  
  3.5.x  
data tabset should not be shown when creating the new table
data tabset should not be shown when creating the new table
There are no notes attached to this issue.





View Issue Details
341 [Sqlite Developer] Unicode minor always 2005-11-18 08:49 2005-11-20 00:31
user2  
user2  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
Data Grid can not show unicode text
Data Grid can not show unicode text
Notes
(0000035)
user2   
2005-11-19 00:47   
need to implement our extended TntDBGrid AlternateRowColor = clMoneyGreen MaxColumnWidth = 300 MinColumnWidth = 10





View Issue Details
354 [Sqlite Developer] GUI minor always 2005-11-22 09:53 2005-11-23 01:08
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
Data Grid Alternate Row Color was messed when scroll the data
Data Grid Alternate Row Color was messed when scroll the data
There are no notes attached to this issue.





View Issue Details
479 [Sqlite Developer] Export/Import minor always 2006-07-09 02:32 2006-07-09 03:32
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.8  
   
Data Export was broken (Which is introduced in ver 1.42)
Data Export was broken (Which is introduced in ver 1.42)
There are no notes attached to this issue.





View Issue Details
601 [Sqlite Developer] Unicode minor have not tried 2007-02-12 23:04 2007-02-13 06:48
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.5  
   
Data Edit Dlg does not support multi language(Introduced in ver2.45)
Data Edit Dlg does not support multi language
err.JPG (16,638) 2007-02-12 23:04
http://mantis.sharpplus.com/file_download.php?file_id=7&type=bug
jpg
There are no notes attached to this issue.





View Issue Details
617 [Sqlite Developer] SQL Editor minor have not tried 2007-03-24 05:07 2007-03-24 08:35
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
Ctrl+A will invoke the autocomplete list
Ctrl+A will invoke the autocomplete list
There are no notes attached to this issue.





View Issue Details
377 [Sqlite Developer] DBA minor always 2005-12-12 07:22 2005-12-13 07:27
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 1.08Beta2  
   
created database was not added to opened database list
created database was not added to opened database list
There are no notes attached to this issue.





View Issue Details
635 [Sqlite Developer] Schema Editor minor have not tried 2007-04-27 20:49 2007-04-27 21:32
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
Create Trigger will raise access violation under some condition(Introduced in 2.45)
Create Trigger will raise access violation under some condition(Introduced in 2.45)
There are no notes attached to this issue.





View Issue Details
384 [Sqlite Developer] Unicode minor always 2005-12-14 20:15 2005-12-14 20:17
sharpplus  
 
normal  
new  
open  
none    
none  
   
create table with japanese field name will display strangely
create table with japanese field name will display strangely, under japanese encoding system
japfield.JPG (23,475) 2005-12-14 20:16
http://mantis.sharpplus.com/file_download.php?file_id=2&type=bug
jpg
There are no notes attached to this issue.





View Issue Details
797 [Antlr For Delphi Target] General minor have not tried 2008-07-06 03:47 2008-07-06 03:47
sharpplus  
 
normal  
new  
open  
none    
none  
   
Create AutoFlowchart component with antlr
Create AutoFlowchart component with antlr
There are no notes attached to this issue.





View Issue Details
855 [Sqlite Developer] Data Editor crash always 2008-09-21 05:19 2008-09-24 06:41
spirit_only  
 
normal  
closed 2.9  
fixed  
none    
none 3.0.x  
  3.0.x  
Crash when I delete the last row in the table.(regression of Ver2.67)
I use Sqlite Developer to insert one row data in my table. Then I commit it. Then I reopen the editor. Then I delete the data add above. 。。。 The program crashed! And open a messagebox showing "Access Violation at address 005DE338 in module 'Sqlite Developer'. Read of address 00000000". I try to close the messagebox, it can not. And another messagebox the same as above was opend.
After I wrote something here, I tab to Sqlite Developer again, then another messagebox the same as above is opend again.
Notes
(0000218)
sharpplus   
2008-09-23 11:20   
I just duplicate the bug you reported , Thank you very much. I will fix it at this weekend
(0000219)
sharpplus   
2008-09-24 06:41   
Fixed in 3.0.0 beta





View Issue Details
901 [Sqlite Developer] Data Editor minor have not tried 2009-01-24 01:22 2009-02-10 03:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.2.x  
  3.2.x  
Copy Record sometimes will cause Grid show two empty record(regression of ver3.10)
Copy Record sometimes will cause Grid show two empty record
There are no notes attached to this issue.





View Issue Details
611 [Sqlite Developer] Unicode minor have not tried 2007-03-04 07:22 2007-05-05 23:03
sharpplus  
sharpplus  
normal  
feedback  
reopened  
none    
none 2.7  
   
copy chinese text(utf8) to clipboard was failed
copy chinese text(utf8) to clipboard was failed
There are no notes attached to this issue.





View Issue Details
802 [Antlr For Delphi Target] General minor have not tried 2008-07-19 07:01 2008-07-19 07:01
sharpplus  
 
normal  
new  
open  
none    
none  
   
Convert all test from antlr
Convert all test from antlr
There are no notes attached to this issue.





View Issue Details
391 [Sqlite Developer] GUI minor always 2005-12-18 09:49 2006-01-15 05:34
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.1RC1  
   
context menu can not be displayed for Grid of Query Form
context menu can not be displayed for Grid of Query Form
There are no notes attached to this issue.





View Issue Details
446 [Sqlite Developer] GUI minor always 2006-05-30 06:16 2006-05-30 10:13
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.6  
   
Constraints edit table was aligned incorrectly
Constraints edit table was aligned incorrectly
There are no notes attached to this issue.





View Issue Details
689 [Sqlite Developer] GUI minor have not tried 2007-11-03 09:33 2007-11-03 09:54
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
   
clicking the icon before node will not set the node to focused state
clicking the icon before node will not set the node to focused state
There are no notes attached to this issue.





View Issue Details
475 [Sqlite Developer] Parser minor always 2006-06-28 09:08 2006-07-01 02:27
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.7  
   
clean the parser to remove the non keywords
clean the parser to remove the non keywords
Notes
(0000057)
sharpplus   
2006-06-28 09:21   
parser should be able to parse below sql correctly CREATE TABLE test ( f1 auto_vacuum )





View Issue Details
332 [Sqlite Developer] DBA minor always 2005-11-09 01:55 2005-11-20 00:21
user2  
user2  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
check duplicate database before register database
check duplicate database before register database
There are no notes attached to this issue.





View Issue Details
520 [Sqlite Developer] Export/Import minor always 2006-08-05 21:54 2006-08-20 02:28
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.0  
   
check csv file existence before import data
check csv file existence before import data
There are no notes attached to this issue.





View Issue Details
857 [Sqlite Developer] Schema Editor minor have not tried 2008-09-23 04:32 2008-09-23 04:32
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
   
Changing Table for creating index should clear all fields in current list (regression of 2.36)
Changing Table for creating index should clear all fields in current list (regression of 2.36)
There are no notes attached to this issue.





View Issue Details
673 [Sqlite Developer] Parser minor have not tried 2007-09-17 21:07 2007-09-17 21:07
sharpplus  
 
normal  
new  
open  
none    
none  
   
Change to use filter parsing to implement autocomplete
Change to use filter parsing to implement autocomplete
There are no notes attached to this issue.





View Issue Details
782 [Sqlite Developer] Query Builder minor have not tried 2008-02-16 11:00 2008-02-16 21:03
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
Change the SQL Editor of Query Builder
Change the SQL Editor of Query Builder
There are no notes attached to this issue.





View Issue Details
540 [Sqlite Developer] Parser minor always 2006-09-04 06:16 2009-02-10 03:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none  
   
change no such table error messsage
change no such table error messsage
There are no notes attached to this issue.





View Issue Details
786 [Sqlite Developer] DBA minor have not tried 2008-03-08 09:50 2008-03-08 10:29
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
Change Integer Field Mapping from 32 bit Integer to 64 bit Integer
Change Integer Field Mapping from 32 bit Integer to 64 bit Integer
There are no notes attached to this issue.





View Issue Details
547 [Sqlite Developer] GUI minor always 2006-09-13 21:31 2006-09-14 06:04
sharpplus  
 
normal  
closed  
fixed  
none    
none  
   
change indexes to indices
change indexes to indices
There are no notes attached to this issue.





View Issue Details
914 [Sqlite Developer] Export/Import minor have not tried 2009-02-11 09:00 2009-02-21 00:04
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.2.x  
  3.2.x  
Change Export/Import default encoding to ANSI ,
Change Export/Import default encoding to ANSI ,
There are no notes attached to this issue.





View Issue Details
422 [Sqlite Developer] GUI minor always 2006-04-02 11:23 2006-04-04 05:59
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 1.3  
   
Change edit view, table, index, trigger form from dialog to mdi style
Change edit view, table, index, trigger form to mdi style
There are no notes attached to this issue.





View Issue Details
740 [Sqlite Developer] SQL Editor minor have not tried 2008-01-19 08:32 2008-01-19 08:32
sharpplus  
 
normal  
new  
open  
none    
none  
   
change autocomplete to treeview like popupwindow(used to support attached databases )
change autocomplete to treeview like popupwindow(used to support attached databases )
There are no notes attached to this issue.





View Issue Details
637 [Sqlite Developer] GUI minor have not tried 2007-04-28 05:54 2007-12-28 22:44
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
  2.8  
Canvas does not allow drawing bug (Introduced in 2.60)
Canvas does not allow drawing bug (Introduced in 2.60)
There are no notes attached to this issue.





View Issue Details
874 [Sqlite Developer] SQL Editor minor have not tried 2008-10-05 23:43 2008-10-05 23:43
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
   
Cancel runing sql was broken
Cancel runing sql was broken
There are no notes attached to this issue.





View Issue Details
872 [Sqlite Developer] Extension feature always 2008-10-05 05:21 2009-03-07 07:59
ghl2150  
 
normal  
closed 2.9  
fixed  
none    
none 3.3.x  
  3.3.x  
Can't open encypted database
I know the databse's password, but there is no way to enter it. I can only select the file of the database. You may see the warning message in my upload file.
encrypt.JPG (5,306) 2008-10-05 05:21
http://mantis.sharpplus.com/file_download.php?file_id=10&type=bug
jpg
Notes
(0000220)
sharpplus   
2008-10-05 23:41   
sorry , because the SQLite3.dll does not support encypted database, SQLite Developer can not open encypted database.
(0000240)
sharpplus   
2009-03-03 03:53   
support air
(0000242)
sharpplus   
2009-03-07 07:59   
We just add support for encrypted database using System.Data.SQLite. please download the latest version from http://www.sqlitedeveloper.com/downloads/SqliteDev332.zip





View Issue Details
417 [Sqlite Developer] SQL Editor minor always 2006-03-18 04:33 2006-03-18 04:40
sharpplus  
 
normal  
new  
open  
none    
none  
   
can show table name in database with highlighter
can show table name in database with highlighter SQL Code Completion that supports table aliases
There are no notes attached to this issue.





View Issue Details
725 [Sqlite Developer] Schema Editor minor have not tried 2008-01-10 08:13 2008-01-11 22:14
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
  2.8  
Can not show exception message when failed to create table, trigger , view, index (regression of ver2.75)
Can not show exception message when failed to create table, trigger , view, index (regression of ver2.75)
There are no notes attached to this issue.





View Issue Details
638 [Sqlite Developer] Schema Editor minor have not tried 2007-04-30 05:38 2007-04-30 05:51
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
can not remove column in Index Editor(Introduced in 2.39)
can not remove column in Index Editor(Introduced in 2.39)
There are no notes attached to this issue.





View Issue Details
598 [Sqlite Developer] Parser minor have not tried 2007-02-11 23:21 2007-02-12 05:02
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.5  
   
can not parse trigger and tables shipped with sample database (Introduced in ver 2.42)
can not parse trigger and tables shipped with sample database (Introduced in ver 2.42)
There are no notes attached to this issue.





View Issue Details
1019 [Sqlite Developer] Parser minor have not tried 2010-01-20 10:07 2010-01-20 10:08
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.6.x  
  3.6.x  
Can not parse the script with some special create table sql correctly
Can not parse the script with some special create table sql correctly
There are no notes attached to this issue.





View Issue Details
549 [Sqlite Developer] Parser minor always 2006-09-14 09:26 2006-09-16 00:57
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.2  
   
Can not parse sql with Temp named table, view or trigger
Can not parse sql with Temp named table, view or trigger
There are no notes attached to this issue.





View Issue Details
555 [Sqlite Developer] Parser minor always 2006-09-16 21:32 2006-09-22 21:38
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.2  
   
can not parse sql with named contraint
CREATE TABLE [COUNTRY] ( [COUNTRY] VARCHAR(15), [CURRENCY] VARCHAR(10), CONSTRAINT [sqlite_autoindex_COUNTRY_1] PRIMARY KEY ([COUNTRY], [CURRENCY]))'.
There are no notes attached to this issue.





View Issue Details
471 [Sqlite Developer] Parser minor always 2006-06-28 01:53 2006-07-01 02:27
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.7  
   
Can not parse some table schema with null field or smallint field
Can not parse some table schema with null field or smallint field
Notes
(0000055)
sharpplus   
2006-06-28 01:56   
when can not parse table , should do not show the table edit gui
(0000056)
sharpplus   
2006-06-28 02:36   
and sqlite analyzer's also can not be parse correctly
(0000058)
sharpplus   
2006-06-28 21:08   
CREATE TABLE Options (Section TEXT NOT NULL, Key TEXT NOT NULL, Value, UNIQUE (Section, Key))





View Issue Details
318 [Sqlite Developer] Parser minor always 2005-11-05 21:40 2005-11-06 04:21
user2  
user2  
normal  
closed  
fixed  
none    
none 1.02Alpha2  
   
can not parse some create table sql which include varchar, char, nchar, double ,numeric etc field type columns
can not parse some create table sql which include varchar, char, nchar, double ,numeric etc field type column
There are no notes attached to this issue.





View Issue Details
603 [Sqlite Developer] Parser minor have not tried 2007-02-13 07:57 2007-02-13 07:57
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.5  
   
can not parse some chinese sql correctly
can not parse some chinese sql correctly
There are no notes attached to this issue.





View Issue Details
558 [Sqlite Developer] Parser crash always 2006-09-20 19:01 2006-09-23 02:20
raminf  
sharpplus  
normal  
closed 2.1  
fixed  
none    
none 2.2  
   
Can not parse Django auto-generated SQL
I'm using SQLite with the python framework Django (www.djangoproject.com). Django provides a python-based Object Request Mapper (ORM) to translate to/from python objects and SQL data. I tried to open one of the tables it generates in SQlite Developer and I got this error: ERROR: can not parse following sql correctly, please report the bug to sharpplus corp. SQL: CREATE TABLE "user_paluser" ( "id" integer NOT NULL PRRIMARY KEY, "user_id" integer NOT NULL UNIQUE REFERENCES ("auth_user")("id"), "level" varchar(1) NOT NULL, "version" numeric(4,2) NOT NULL, "dateExpired" datetime NOT NULL, "status" varchar(1) NOT NULL ) (I'm transcribing this from the modal dialog box. Hopefully I didn't mis-type anything ;-) Not sure if this is the reason, but the table was working fine until I added the foreign key reference.
Thank you for bug report, I will try to fix the parser problem as soon as possible
Notes
(0000064)
raminf   
2006-09-20 19:03   
I forgot to mention that right after I hit OK on the dialog box, the program quits (hence the 'Crash') designation.
(0000065)
sharpplus   
2006-09-22 09:25   
the bug reason is that current the parser does not support REFERENCES syntax, "user_id" integer NOT NULL UNIQUE REFERENCES ("auth_user")("id"), I will fix it in this weekend
(0000066)
sharpplus   
2006-09-23 02:14   
I just add partly references syntax support





View Issue Details
343 [Sqlite Developer] Parser minor always 2005-11-18 09:20 2005-11-20 00:25
user2  
user2  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
Can not parse Create Table Sql with NULLType Field
Can not parse Create Table Sql with NULLType Field
There are no notes attached to this issue.





View Issue Details
971 [Sqlite Developer] Parser minor have not tried 2009-08-02 03:13 2009-08-02 03:13
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
Can not parse == token
Can not parse == token
There are no notes attached to this issue.





View Issue Details
258 [Sqlite Developer] Parser minor always 2005-10-07 11:40 2005-10-08 22:19
user2  
user2  
normal  
closed  
fixed  
none    
none 0.93  
   
Can not parse 'XXX' and "YYY" type table name
CREATE TRIGGER trigger1 BEFORE DELETE ON 'Test1' FOR EACH ROW BEGIN --Test END
There are no notes attached to this issue.





View Issue Details
327 [Sqlite Developer] DBA minor always 2005-11-07 08:14 2005-11-07 08:14
user2  
 
normal  
closed  
fixed  
none    
none 1.02Alpha2  
   
Can not load ParserDll.dll on windows 2000 system
Can not load ParserDll.dll on windows 2000 system
There are no notes attached to this issue.





View Issue Details
759 [Sqlite Developer] Schema Editor minor have not tried 2008-02-04 09:41 2008-02-07 09:21
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
can not load corresponding trigger and index for attached database table or view
can not load corresponding trigger for attached database table or view
There are no notes attached to this issue.





View Issue Details
910 [Sqlite Developer] Export/Import minor have not tried 2009-02-11 02:33 2009-02-12 10:30
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.2.x  
  3.2.x  
Can not import table which has field name with space and can not edit field which has space in name
Can not import table which has field name with space and can not edit field which has space in name
There are no notes attached to this issue.





View Issue Details
977 [Sqlite Developer] Export/Import minor have not tried 2009-09-11 10:06 2009-09-11 10:12
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.5.x  
  3.5.x  
Can not import more than 1000 records with sqlite database importation
Can not import more than 1000 records with sqlite database importation
There are no notes attached to this issue.





View Issue Details
818 [Sqlite Developer] Export/Import minor have not tried 2008-08-03 04:21 2008-08-03 04:28
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
   
Can not import csv file with non-comma separator and no header row
Can not import csv file with non-comma separator and no header row
There are no notes attached to this issue.





View Issue Details
672 [Sqlite Developer] Export/Import minor have not tried 2007-09-16 20:58 2007-09-17 00:30
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
   
Can not extract virtual table schema when generate if not script option was specified
Can not extract virtual table schema when generate if not script option was specified
There are no notes attached to this issue.





View Issue Details
1036 [Sqlite Developer] Export/Import minor have not tried 2010-05-24 08:49 2010-05-24 08:57
sharpplus  
sharpplus  
normal  
resolved  
fixed  
none    
none 3.6.x  
   
Can not export more than 1000 records with sqlite database with extract data wizard
Can not export more than 1000 records with sqlite database with extract data wizard
There are no notes attached to this issue.





View Issue Details
757 [Sqlite Developer] SQL Editor minor have not tried 2008-02-04 07:38 2008-02-09 04:38
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
can not execute query with limit
can not execute query with limit
There are no notes attached to this issue.





View Issue Details
708 [Sqlite Developer] DBA minor have not tried 2007-12-29 20:28 2008-01-13 01:29
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
  2.8  
Can not drop table with name with dot like [sample.abc]
Can not drop table with name with dot like [sample.abc]
There are no notes attached to this issue.





View Issue Details
348 [Sqlite Developer] Unicode minor always 2005-11-19 06:42 2005-11-20 00:27
user2  
user2  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
Can not display unicode FieldName
Can not display unicode FieldName
There are no notes attached to this issue.





View Issue Details
436 [Sqlite Developer] DBA minor always 2006-04-30 00:42 2006-05-26 12:14
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 1.4  
   
can not display and input length > 255 string in table, now the default data size is 8192 and you can change it to larger size
can not display and input length > 255 string in table, now the default data size is 8192 and you can change it to larger size by changing Options | SQL Editor | Max Data Size option value.
There are no notes attached to this issue.





View Issue Details
655 [Sqlite Developer] Schema Editor minor have not tried 2007-07-07 04:45 2007-07-07 04:45
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
Can not create table with check constraints (Introduced in ver2.39)
Can not create table with check constraints (Introduced in ver2.39)
There are no notes attached to this issue.





View Issue Details
981 [Sqlite Developer] Schema Editor minor have not tried 2009-09-23 20:30 2009-09-25 22:12
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.5.x  
  3.5.x  
Can not create foreign keys for temporary tables
Can not create foreign keys for temporary tables
There are no notes attached to this issue.





View Issue Details
378 [Sqlite Developer] Unicode minor always 2005-12-12 07:23 2005-12-13 07:26
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 1.08Beta2  
   
Can not create encoding=utf16 database
Can not create encoding=utf16 database
There are no notes attached to this issue.





View Issue Details
1018 [Sqlite Developer] Schema Editor minor have not tried 2010-01-13 22:07 2010-01-13 22:08
sharpplus  
 
normal  
new  
open  
none    
none  
  3.6.x  
Can not correctly edit table schema with foreign key
Can not correctly edit table schema with foreign key
There are no notes attached to this issue.





View Issue Details
539 [Sqlite Developer] GUI minor always 2006-09-02 11:31 2006-09-02 21:33
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.1  
   
Can not add constraints when edit exist table
Can not add constraints when edit exist table
There are no notes attached to this issue.





View Issue Details
381 [Sqlite Developer] Unicode minor always 2005-12-13 07:34 2006-06-24 21:31
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.7  
   
besides utf8, now you can use ansi, utf16 to encode and decode the data in database
besides utf8, now you can use ansi, utf16 to encode and decode the data in database
There are no notes attached to this issue.





View Issue Details
821 [Sqlite Developer] Extension minor have not tried 2008-08-03 06:35 2008-08-11 05:42
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
  3.0.x  
because sqlite now with fts3 build in support ,so remove fts1, fts2 dll
Remove fts1, fts2
There are no notes attached to this issue.





View Issue Details
895 [Sqlite Developer] Data Editor minor have not tried 2009-01-09 09:33 2010-05-09 10:49
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.6.x  
  3.6.x  
Be able to paste data from clipboard
Be able to paste data from clipboard
There are no notes attached to this issue.





View Issue Details
969 [Sqlite Developer] Schema Editor minor have not tried 2009-07-26 03:44 2009-07-26 03:44
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
be able to edit foreign keys
be able to edit foreign keys
There are no notes attached to this issue.





View Issue Details
571 [Sqlite Developer] DBA minor always 2006-10-10 02:15 2006-10-14 05:10
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.3  
   
basic loadable extension support
basic loadable extension support
Notes
(0000067)
sharpplus   
2006-10-10 08:03   
execute SELECT load_extension('libfts1.dll') will make the program into dead loop
(0000068)
sharpplus   
2006-10-13 10:31   
Add virtual , using keywords limit alter virtual table add different virtual ico





View Issue Details
1047 [Sqlite Developer] SQL Editor minor have not tried 2010-07-31 02:48 2010-07-31 07:00
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.7.x  
  3.7.x  
AV after clicking begin transaction button (regression of 3.15)
AV after executing begin transaction
There are no notes attached to this issue.





View Issue Details
1002 [Sqlite Developer] DBA minor have not tried 2009-11-10 19:51 2009-11-13 10:48
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.5.x  
  3.5.x  
Automaticlly load the recent attached database
Automaticlly load the recent attached database
There are no notes attached to this issue.





View Issue Details
824 [Sqlite Developer] SQL Editor minor have not tried 2008-08-06 10:52 2008-08-12 00:36
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
  3.0.x  
Automatic disable/enable transaction buttons upon the database transaction status
Disable begin transaction button when database in transactionmode
There are no notes attached to this issue.





View Issue Details
1046 [Sqlite Developer] SQL Editor minor have not tried 2010-07-24 08:44 2010-07-31 07:01
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.7.x  
   
Automatic detect sql encoding in the sql open dialog
Automatic detect sql encoding in the sql open dialog
There are no notes attached to this issue.





View Issue Details
829 [Sqlite Developer] SQL Editor minor have not tried 2008-08-12 01:31 2008-08-12 01:31
sharpplus  
 
normal  
new  
open  
none    
none  
   
automatic append table name to fieldname
automatic append table name to fieldname
There are no notes attached to this issue.





View Issue Details
650 [Sqlite Developer] Schema Editor minor have not tried 2007-06-02 03:57 2007-06-02 04:12
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
At the same time only one table can be edited by schema editor.(Introduced in ver2.64)
At the same time only one table can be edited by schema editor.(Introduced in ver2.64)
There are no notes attached to this issue.





View Issue Details
630 [Sqlite Developer] GUI minor have not tried 2007-04-23 21:04 2007-04-27 20:47
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
Application was not shown on application toolbar(Introduced in 2.60)
Application was not shown on application toolbar
There are no notes attached to this issue.





View Issue Details
1029 [Sqlite Developer] SQL Editor minor have not tried 2010-03-20 22:52 2010-03-21 07:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.6.x  
  3.6.x  
append [] for field name selected from autocomplete list
append [] for field name selected from autocomplete list
There are no notes attached to this issue.





View Issue Details
324 [Sqlite Developer] Export/Import minor always 2005-11-06 04:39 2005-11-20 00:16
user2  
user2  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
always export empty data when data type is float
always export empty data when data type is float
There are no notes attached to this issue.





View Issue Details
807 [Sqlite Developer] GUI minor have not tried 2008-07-21 06:31 2008-08-11 06:01
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
  3.0.x  
Allow using mouse to adjust grid column width
Allow using mouse to adjust grid column width
There are no notes attached to this issue.





View Issue Details
567 [Sqlite Developer] DBA minor always 2006-10-07 06:40 2006-10-07 06:41
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.2  
   
Allow user to view sqlite auto-generated index
Allow user to view sqlite auto-generated index
There are no notes attached to this issue.





View Issue Details
843 [Sqlite Developer] Export/Import minor have not tried 2008-08-28 08:08 2008-11-10 21:54
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.1.x  
  3.1.x  
Allow user to specify the output data format
Allow user to specify the output data format
There are no notes attached to this issue.





View Issue Details
986 [Sqlite Developer] GUI minor have not tried 2009-09-30 21:29 2009-10-18 05:57
sharpplus  
 
normal  
new  
open  
none    
none  
  3.5.x  
Allow user to fix the dbgrid column and advanced sort
Allow user to fix the dbgrid column
There are no notes attached to this issue.





View Issue Details
504 [Sqlite Developer] GUI minor always 2006-07-22 10:28 2006-07-25 08:25
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.9  
   
allow user to delete the database objects with delete key
allow user to delete the database objects with delete key
There are no notes attached to this issue.





View Issue Details
485 [Sqlite Developer] Export/Import minor always 2006-07-10 21:33 2006-07-15 23:11
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.8  
   
Allow user to cancel the export process
Allow user to cancel the export process
There are no notes attached to this issue.





View Issue Details
881 [Sqlite Developer] Print minor have not tried 2008-10-24 00:48 2008-11-10 21:53
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.1.x  
  3.1.x  
Allow Print Grid Data
Allow Print Grid Data
There are no notes attached to this issue.





View Issue Details
940 [Sqlite Developer] SQL Editor minor have not tried 2009-04-04 06:39 2009-05-07 02:27
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
Allow input parameter in sql
Allow input parameter in sql
There are no notes attached to this issue.





View Issue Details
867 [Sqlite Developer] GUI minor have not tried 2008-09-28 08:19 2008-12-06 01:58
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.2.x  
  3.2.x  
After switching to other application then switch back . The docking explorer was displayed at wrong position
After switching to other application then switch back . The docking explorer was displayed at wrong position
There are no notes attached to this issue.





View Issue Details
909 [Sqlite Developer] Schema Editor minor have not tried 2009-02-11 00:58 2009-04-17 22:03
sharpplus  
 
normal  
new  
open  
none    
none  
  3.4.x  
After renaming the productid of order details table, the generated sql was not wrong
After renaming the productid of order details table, the generated sql was not wrong
There are no notes attached to this issue.





View Issue Details
905 [Sqlite Developer] Schema Editor minor have not tried 2009-02-01 08:20 2009-02-11 01:00
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.2.x  
  3.2.x  
After renaming the job_country field of Job table to country , the generated sql was wrong
After renaming the job_country field of Job table to country , the generated sql was wrong
Notes
(0000223)
sharpplus   
2009-02-07 22:26   
Primary Keys syndication was finished, but Unique Constraints were not fixed.





View Issue Details
412 [Sqlite Developer] GUI minor always 2006-03-18 01:09 2006-03-18 03:07
sharpplus  
 
normal  
closed  
fixed  
none    
none  
   
After remove skin support , the status bar has problem
After remove skin support , the status bar has problem
There are no notes attached to this issue.





View Issue Details
992 [Sqlite Developer] Schema Editor minor have not tried 2009-10-27 09:38 2009-10-27 09:38
sharpplus  
 
normal  
new  
open  
none    
none  
  3.5.x  
After pressing the down key in field type combobox Editor , new field row was not inserted
After pressing the down key in field type combobox Editor , new field row was not inserted
There are no notes attached to this issue.





View Issue Details
1043 [Sqlite Developer] Export/Import minor have not tried 2010-06-06 09:42 2010-06-06 10:18
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.7.x  
  3.7.x  
After Moving the Node , Virtual Table Image Index disappeared. (In Extract Wizard)
After Moving the Node , Virtual Table Image Index disappeared. (In Extract Wizard)
There are no notes attached to this issue.





View Issue Details
889 [Sqlite Developer] Query Builder minor have not tried 2008-12-02 08:36 2008-12-04 07:42
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.2.x  
  3.2.x  
After inserting diagram into view, Primary and foreign Key were not drawn immediately
After inserting diagram into view, Primary and foreign Key were not drawn immediately
There are no notes attached to this issue.





View Issue Details
993 [Sqlite Developer] Data Editor minor have not tried 2009-11-01 04:04 2009-11-01 04:04
sharpplus  
 
normal  
new  
open  
none    
none  
  3.5.x  
After inserting a record with primary autoinc field , the primary key value was not displayed
After inserting a record with primary autoinc field , the primary key value was not displayed
There are no notes attached to this issue.





View Issue Details
925 [Sqlite Developer] GUI minor have not tried 2009-02-24 10:18 2009-02-28 08:25
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.3.x  
  3.3.x  
After fixed the problem with performance, the filter was not worked as expected
After fixed the problem with performance, the filter was not worked as expected
There are no notes attached to this issue.





View Issue Details
579 [Sqlite Developer] GUI minor always 2006-10-31 08:55 2006-11-04 07:40
sharpplus  
 
normal  
closed  
fixed  
none    
none  
   
After Emptying the table, the grid column length is messed up
After Emptying the table, the grid column length is messed up
There are no notes attached to this issue.





View Issue Details
492 [Sqlite Developer] DBA minor always 2006-07-13 08:42 2006-07-14 22:25
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.8  
   
after deleting the data in table, the data grid show strange data.(Which is introduced in ver 1.75)
after deleting the data in table, the data grid show strange data.
There are no notes attached to this issue.





View Issue Details
495 [Sqlite Developer] Export/Import minor always 2006-07-13 12:01 2009-02-10 03:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none  
   
After delete all data in table country, then import the csv will show a country is not unique error
After delete all data in table country, then import the csv will show a country is not unique error
There are no notes attached to this issue.





View Issue Details
305 [Sqlite Developer] DBA minor always 2005-10-29 22:06 2005-11-06 04:16
user2  
user2  
normal  
closed  
fixed  
none    
none 1.02Alpha2  
   
After Creating Table, automaticlly refresh Indexes
After Creating Table, automaticlly refresh Indexes
There are no notes attached to this issue.





View Issue Details
460 [Sqlite Developer] GUI minor always 2006-06-24 08:37 2006-06-24 08:40
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.7  
   
after closing the database, the related table, trigger, view , index form was not closed
after closing the database, the related table, trigger, view , index form was not closed
There are no notes attached to this issue.





View Issue Details
462 [Sqlite Developer] GUI minor always 2006-06-24 09:52 2006-06-24 10:31
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.7  
   
after changing the options , the Edit Table, Trigger, Index, View Forms was not affected .
after changing the options , the Edit Table, Trigger, Index, View Forms was not changed .
There are no notes attached to this issue.





View Issue Details
887 [Sqlite Developer] GUI minor have not tried 2008-12-02 08:33 2008-12-03 08:15
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.2.x  
  3.2.x  
After Changing the database name the database list of SQL Editor was not refreshed.
After Changing the database name the database list of SQL Editor was not refreshed.
There are no notes attached to this issue.





View Issue Details
237 [Sqlite Developer] DBA minor always 2005-09-22 21:24 2005-10-08 22:14
user2  
user2  
normal  
closed  
fixed  
none    
none 0.93  
   
Advanced Trigger Management
Advanced Trigger Management
There are no notes attached to this issue.





View Issue Details
188 [Sqlite Developer] DBA minor always 2005-09-04 04:29 2005-10-29 13:14
user2  
user2  
normal  
closed  
fixed  
none    
none 0.97Alpha1  
   
Advanced Index Management
Advanced Index Management
There are no notes attached to this issue.





View Issue Details
301 [Sqlite Developer] DBA minor always 2005-10-29 07:40 2005-10-29 13:20
user2  
user2  
normal  
closed  
fixed  
none    
none 0.97Alpha1  
   
adjust too large string field display length in Data Grid
adjust too large string field display length in Data Grid
There are no notes attached to this issue.





View Issue Details
1041 [Sqlite Developer] GUI minor have not tried 2010-05-30 08:49 2010-05-30 08:54
sharpplus  
 
normal  
new  
open  
none    
none  
  3.7.x  
Added options to set the selected cells to NULL or to a specific value.
Added options to set the selected cells to NULL or to a specific value.
There are no notes attached to this issue.





View Issue Details
128 [Sqlite Developer] GUI minor always 2005-08-21 04:46 2005-11-06 04:13
user2  
user2  
normal  
closed  
fixed  
none    
none 1.02Alpha2  
   
Add Windows Menu
Add Windows Menu
There are no notes attached to this issue.





View Issue Details
963 [Sqlite Developer] DBA minor have not tried 2009-06-03 22:01 2009-06-06 01:43
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
Add view support to master detail browser
Add view support to master detail browser
There are no notes attached to this issue.





View Issue Details
503 [Sqlite Developer] DBA minor always 2006-07-20 00:30 2006-09-10 05:52
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.1  
   
Add View blob data as bmp , jpg, gif
Add View data as bmp , jpg, gif, png
There are no notes attached to this issue.





View Issue Details
519 [Sqlite Developer] DBA minor always 2006-08-05 21:42 2006-08-05 21:42
sharpplus  
 
normal  
new  
open  
none    
none  
   
Add View As RTF
Add View As RTF
There are no notes attached to this issue.





View Issue Details
660 [Sqlite Developer] GUI minor have not tried 2007-07-16 01:31 2007-07-16 01:31
sharpplus  
 
normal  
new  
open  
none    
none  
   
Add Type Filter Text to Filter Edit
Add Type Filter Text to Filter Edit
There are no notes attached to this issue.





View Issue Details
252 [Sqlite Developer] GUI minor always 2005-10-02 08:35 2005-10-08 22:18
user2  
user2  
normal  
closed  
fixed  
none    
none 0.93  
   
Add two new filter(All non-system and non-temporary Objects, All non-temporary Objects)
Add Tempory Db Objects Filter All non-system and non-temporary Objects All non-temporary Objects
There are no notes attached to this issue.





View Issue Details
551 [Sqlite Developer] DBA minor always 2006-09-15 08:45 2006-10-28 10:54
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.3  
   
Add Trigger Tab to Table Editor
Add Trigger Tab to Table Editor
There are no notes attached to this issue.





View Issue Details
988 [Antlr For Delphi Target] General minor have not tried 2009-10-04 13:36 2009-10-05 23:54
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.2  
  3.2  
Add Tree Filter Example
Add Tree Filter Example
There are no notes attached to this issue.





View Issue Details
441 [Sqlite Developer] DBA minor always 2006-05-28 08:32 2006-07-19 09:11
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.9  
   
Add Transaction button to SQL Editor
Add Transaction button to SQL Editor
There are no notes attached to this issue.





View Issue Details
506 [Sqlite Developer] Export/Import minor always 2006-07-26 08:47 2006-07-27 09:40
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.9  
   
Add Transaction , drop statement to extracted schema
Add Transaction , drop statement to extracted schema
There are no notes attached to this issue.





View Issue Details
591 [Sqlite Developer] GUI minor have not tried 2007-01-24 08:08 2007-01-24 08:11
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.4  
   
Add Toolbar for Constraints Editor
Add Toolbar for Constraints Editor
There are no notes attached to this issue.





View Issue Details
624 [Sqlite Developer] SQL Editor minor have not tried 2007-04-08 03:42 2007-04-08 03:42
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
Add Table Field AutoComplete with table alias support
Add Table Field AutoComplete with table alias support
There are no notes attached to this issue.





View Issue Details
500 [Sqlite Developer] Query Builder minor always 2006-07-19 00:11 2006-07-20 09:33
sharpplus  
 
normal  
closed  
fixed  
none    
none  
   
Add Table Alias column to query builder
Add Table Alias column to query builder
There are no notes attached to this issue.





View Issue Details
499 [Sqlite Developer] Query Builder minor always 2006-07-17 10:06 2006-07-22 10:37
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.9  
   
add table alias column and allow user to insert the same table into query builder multiple times
add table alias column and allow user to insert the same table into query builder multiple times
There are no notes attached to this issue.





View Issue Details
701 [Sqlite Developer] Parser minor have not tried 2007-12-02 06:01 2007-12-15 22:21
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.8  
   
add support for new sql syntax introduced in sqlite 3.5.3
add support for new sql syntax introduced in sqlite 3.5.3
There are no notes attached to this issue.





View Issue Details
799 [Antlr For Delphi Target] General minor have not tried 2008-07-06 03:48 2009-11-11 01:11
sharpplus  
 
normal  
new  
open  
none    
none  
  3.3  
Add stringtemplate support
Add stringtemplate support
There are no notes attached to this issue.





View Issue Details
119 [Sqlite Developer] Parser minor always 2005-08-09 11:35 2007-05-01 08:16
user2  
 
normal  
closed  
fixed  
none    
none 2.7  
   
Add SQL Formatter(Alpha)
Add SQL Formatter(Alpha)
There are no notes attached to this issue.





View Issue Details
300 [Sqlite Developer] Option minor always 2005-10-29 03:01 2005-11-06 04:12
user2  
user2  
normal  
closed  
fixed  
none    
none 1.02Alpha2  
   
Add SQL Editor Font Option to configure the Font and Font size.
Add SQL Editor Font Option to configure the Font and Font size.
There are no notes attached to this issue.





View Issue Details
245 [Sqlite Developer] GUI minor always 2005-09-23 23:36 2005-10-08 22:16
user2  
user2  
normal  
closed  
fixed  
none    
none 0.93  
   
Add some icon to menuitem
Add some icon to menuitem
There are no notes attached to this issue.





View Issue Details
428 [Sqlite Developer] GUI minor always 2006-04-22 03:41 2006-04-22 05:49
sharpplus  
 
normal  
closed  
fixed  
none    
none  
   
add smart filter to Extract Schema Dialog
add smart filter to Extract Schema Dialog
There are no notes attached to this issue.





View Issue Details
362 [Sqlite Developer] GUI minor always 2005-11-25 22:12 2005-12-13 07:53
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 1.08Beta2  
   
Add Skin Support , you can enable and disable it by switching the option
Add Skin Support , you can enable and disable it by switching the option
There are no notes attached to this issue.





View Issue Details
309 [Sqlite Developer] SQL Editor minor always 2005-10-31 08:06 2005-11-06 04:16
user2  
user2  
normal  
closed  
fixed  
none    
none 1.02Alpha2  
   
Add Save SQL and Load SQL function to SQL Editor
Add Save SQL and Load SQL function to SQL Editor
There are no notes attached to this issue.





View Issue Details
806 [Sqlite Developer] Extension minor have not tried 2008-07-21 00:00 2008-07-26 23:57
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
Add rtree and icu support to sqlite dll
Compile sqlite dll with rtree and icu support
There are no notes attached to this issue.





View Issue Details
265 [Sqlite Developer] GUI minor always 2005-10-08 20:51 2005-11-06 04:17
user2  
user2  
normal  
closed  
fixed  
none    
none 1.02Alpha2  
   
Add Rows Affected Information to Log
Add Rows Affected Information to Log
There are no notes attached to this issue.





View Issue Details
566 [Sqlite Developer] DBA minor always 2006-10-03 03:17 2006-10-07 22:52
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.3  
   
Add reindex to database to rebuild all indices in the database
Add reindex to database to rebuild all indices in the database
There are no notes attached to this issue.





View Issue Details
962 [Sqlite Developer] DBA minor have not tried 2009-06-01 05:41 2009-06-05 23:59
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.4.x  
  3.4.x  
Add quick check support
Add quick check support
There are no notes attached to this issue.





View Issue Details
552 [Sqlite Developer] DBA minor always 2006-09-15 08:47 2006-09-23 02:22
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.2  
   
Add Precison Length input box to Table Editor
Add Precison Length input box to Table Editor
There are no notes attached to this issue.





View Issue Details
1045 [Sqlite Developer] Export/Import minor have not tried 2010-07-24 08:43 2010-07-31 10:22
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.7.x  
   
Add Pragma foreign_keys=false
Add Pragma foreign_keys=false
There are no notes attached to this issue.





View Issue Details
883 [Sqlite Developer] DBA minor have not tried 2008-11-10 21:56 2008-11-10 21:57
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.1.x  
   
Add PNG support
Add PNG support
There are no notes attached to this issue.





View Issue Details
618 [Sqlite Developer] SQL Editor minor have not tried 2007-03-24 08:37 2007-03-24 08:37
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
Add parentheis matching
Add parentheis matching
There are no notes attached to this issue.





View Issue Details
938 [Sqlite Developer] DBA minor have not tried 2009-04-04 05:34 2009-04-07 09:54
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.3.x  
  3.3.x  
Add Page and FreeList Count display
Add Page and FreeList Count display
There are no notes attached to this issue.





View Issue Details
481 [Sqlite Developer] Export/Import minor always 2006-07-09 04:05 2006-09-02 10:31
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.1  
   
Add Open exported file after exporting option to extract schema and export data wizard
Add Open exported file after exporting option to extract schema and export data wizard
There are no notes attached to this issue.





View Issue Details
432 [Sqlite Developer] GUI minor always 2006-04-22 05:51 2009-04-06 10:43
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.3.x  
  3.3.x  
Add node hint to Database Explorer
Add node hint to Database Explorer
There are no notes attached to this issue.





View Issue Details
897 [Sqlite Developer] Parser minor have not tried 2009-01-17 01:50 2009-02-10 03:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.2.x  
   
Add new savepoint syntax support to parser
Add new savepoint syntax support to parser
There are no notes attached to this issue.





View Issue Details
808 [Sqlite Developer] DBA minor have not tried 2008-07-26 11:29 2008-07-26 11:30
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
Add New Collation Command
Add New Collation Command
There are no notes attached to this issue.





View Issue Details
590 [Sqlite Developer] GUI minor have not tried 2007-01-24 08:08 2007-01-24 08:10
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.4  
   
Add mouse pan with mouse middle key
Add mouse pan with mouse middle key
There are no notes attached to this issue.





View Issue Details
541 [Sqlite Developer] GUI minor always 2006-09-06 09:35 2006-09-08 08:56
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.1  
   
add more predefined data type autocomplete list of data type input combobx
add more predefined data type autocomplete list of data type input combobx
There are no notes attached to this issue.





View Issue Details
644 [Sqlite Developer] SQL Editor minor have not tried 2007-05-05 10:10 2007-05-14 10:46
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
  2.7  
Add more option for SQL Formatter , such as return after comma and added format sql to SQL Editor context menu
Add more option for SQL Formatter , such as return after comma
There are no notes attached to this issue.





View Issue Details
421 [Sqlite Developer] SQL Editor minor always 2006-04-02 06:40 2006-04-02 06:41
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.2RC2  
   
add more functions to highlighter , such as typeof, length, substr, etc
add more functions to highlighter , such as typeof, length, substr, etc
There are no notes attached to this issue.





View Issue Details
420 [Sqlite Developer] SQL Editor minor always 2006-04-02 06:28 2006-04-02 06:29
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.2RC2  
   
add more functions to autocomplete , such as typeof, length, substr, etc
add more functions to autocomplete , such as typeof, length, substr, etc
There are no notes attached to this issue.





View Issue Details
879 [Sqlite Developer] DBA minor have not tried 2008-10-24 00:36 2008-11-10 21:51
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.1.x  
  3.1.x  
Add more data type mappings
Add more data type mappings
There are no notes attached to this issue.





View Issue Details
768 [Sqlite Developer] Extension minor have not tried 2008-02-09 03:54 2009-09-17 00:10
sharpplus  
 
normal  
new  
open  
none    
none  
  3.5.x  
Add menuitem to load extension manully
Add menuitem to load extension manully
There are no notes attached to this issue.





View Issue Details
932 [Sqlite Developer] DBA minor have not tried 2009-03-14 06:28 2009-04-04 05:30
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.3.x  
  3.3.x  
Add Max Page Count Setting
Add Max Page Count Setting
There are no notes attached to this issue.





View Issue Details
665 [Sqlite Developer] Extension minor have not tried 2007-07-24 11:20 2008-08-12 01:20
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.0.x  
  3.0.x  
Add lots of additional math, string and aggregate functions to Sqlite
extension-functions.tgz
Notes
(0000206)
sharpplus   
2007-07-24 11:23   
ICU Extension String and Math Extension





View Issue Details
155 [Sqlite Developer] SQL Editor minor always 2005-08-27 05:42 2005-09-29 06:30
user2  
user2  
normal  
closed  
fixed  
none    
none 0.89  
   
Add Log Tab to QueryForm
Add Log Tab to QueryForm
There are no notes attached to this issue.





View Issue Details
469 [Sqlite Developer] DBA minor always 2006-06-27 03:10 2006-09-16 00:53
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.2  
   
Add legacy file format option to create database dialog
Add legacy file format option to create database dialog
There are no notes attached to this issue.





View Issue Details
612 [Sqlite Developer] Option minor have not tried 2007-03-04 10:30 2007-03-18 01:51
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
Add keyword autocomplete option
Add disable keyword autocomplete option
There are no notes attached to this issue.





View Issue Details
605 [Sqlite Developer] Unicode minor have not tried 2007-02-18 03:04 2007-02-18 03:04
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.5  
   
Add Japanese Support
Add Japanese Support
There are no notes attached to this issue.





View Issue Details
529 [Sqlite Developer] Option minor always 2006-08-19 20:56 2006-08-27 04:45
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.1  
   
Add Integer , Float Field Mapping to Data Type Mapping Options
Add Integer , Float Field Mapping to Data Type Mapping Options
There are no notes attached to this issue.





View Issue Details
484 [Sqlite Developer] DBA minor always 2006-07-09 07:20 2006-10-21 08:25
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.3  
   
Add Indexes Tab to Table Editor
Add Indexes Tab to Table Editor
There are no notes attached to this issue.





View Issue Details
652 [Sqlite Developer] DBA minor have not tried 2007-07-05 10:11 2007-07-06 22:34
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.7  
   
Add incremental vacuum option
Add incremental vacuum option
There are no notes attached to this issue.





View Issue Details
1039 [Sqlite Developer] Export/Import minor have not tried 2010-05-28 12:09 2010-06-12 01:29
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.7.x  
  3.7.x  
Add import sql option into import wizard
Add import sql option into import wizard
Notes
(0000274)
sharpplus   
2010-06-12 01:29   
Now it is over 10x faster than executing sql script in sql editor





View Issue Details
493 [Sqlite Developer] GUI minor always 2006-07-13 08:43 2006-07-13 08:43
sharpplus  
 
normal  
new  
open  
none    
none  
   
Add Import Data command to table context menu.
Add Import Data command to table context menu.
There are no notes attached to this issue.





View Issue Details
508 [Sqlite Developer] Export/Import minor always 2006-07-27 09:17 2006-10-12 09:31
sharpplus  
 
normal  
closed  
fixed  
none    
none  
   
Add if not exists statement to Extract Schema Dialog
Add if not exists statement to Extract Schema Dialog
There are no notes attached to this issue.





View Issue Details
382 [Sqlite Developer] GUI minor always 2005-12-13 08:25 2006-05-29 08:21
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.6  
   
Add icon to context menu
Add icon to context menu
There are no notes attached to this issue.





View Issue Details
573 [Sqlite Developer] Web minor always 2006-10-11 03:58 2007-04-10 03:31
sharpplus  
 
normal  
closed  
fixed  
none    
none  
   
Add i18n module
Add i18n module
There are no notes attached to this issue.





View Issue Details
918 [Sqlite Developer] Export/Import minor have not tried 2009-02-17 19:11 2009-03-14 01:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.3.x  
  3.3.x  
Add hot backup and restore database wizard
Add hot backup and restore database wizard
There are no notes attached to this issue.





View Issue Details
444 [Sqlite Developer] GUI minor always 2006-05-29 07:45 2006-05-29 07:49
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.6  
   
add hints to some toolbar buttons
add hints to some toolbar buttons
There are no notes attached to this issue.





View Issue Details
868 [Sqlite Developer] Schema Editor minor have not tried 2008-09-28 08:20 2008-10-24 00:36
sharpplus  
 
normal  
new  
open  
none    
none  
  3.1.x  
Add hints to inplace editor's toolbar buttons of Schema Editor Grid
Add hints to inplace editor's toolbar buttons of Schema Editor Grid
There are no notes attached to this issue.





View Issue Details
951 [Sqlite Developer] Help minor have not tried 2009-04-12 22:02 2009-04-15 09:09
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.3.x  
  3.3.x  
Add help button to import/export wizard
Add help button to import/export wizard
There are no notes attached to this issue.





View Issue Details
1032 [Sqlite Developer] GUI minor have not tried 2010-05-17 11:28 2010-06-26 13:36
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.7.x  
   
Add grid font option
Add grid font option
There are no notes attached to this issue.





View Issue Details
621 [Sqlite Developer] SQL Editor minor have not tried 2007-04-01 10:27 2007-04-01 10:27
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
Add From Table/View AutoComplete(Schema AutoComplete)
Add From Table/View AutoComplete(Schema AutoComplete)
There are no notes attached to this issue.





View Issue Details
1028 [Sqlite Developer] Other minor have not tried 2010-03-20 22:44 2010-03-22 00:57
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.6.x  
  3.6.x  
Add File Association Setting
Add File Association Setting
There are no notes attached to this issue.





View Issue Details
894 [Sqlite Developer] DBA minor have not tried 2009-01-09 09:33 2009-04-12 03:48
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.3.x  
  3.3.x  
Add Field Node to DB Explorer
Add Field Node to DB Explorer, show field to filter result and find in db result
There are no notes attached to this issue.





View Issue Details
483 [Sqlite Developer] Export/Import minor always 2006-07-09 05:00 2006-11-04 08:04
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.3  
   
Add Field Mapping to CSV Import Wizard
Add Field Mapping to CSV Import Wizard
There are no notes attached to this issue.





View Issue Details
232 [Sqlite Developer] DBA minor always 2005-09-19 11:09 2005-09-29 06:33
user2  
user2  
normal  
closed  
fixed  
none    
none 0.89  
   
Add Explain Query Plan Function
Add Explain Query Plan Function
There are no notes attached to this issue.





View Issue Details
575 [Sqlite Developer] Parser minor always 2006-10-13 00:46 2007-02-25 06:19
sharpplus  
 
normal  
closed  
fixed  
none    
none  
   
Add error recovery to parser
Add error recovery to parser
There are no notes attached to this issue.





View Issue Details
753 [Sqlite Developer] GUI minor have not tried 2008-02-03 04:59 2008-02-03 05:06
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
Add Enter shortcut to edit selected object
Add Enter shortcut to edit selected object
There are no notes attached to this issue.





View Issue Details
497 [Sqlite Developer] DBA minor always 2006-07-14 00:08 2006-09-15 09:05
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.2  
   
Add Empty Table command
Add Empty Table command
Notes
(0000062)
sharpplus   
2006-09-14 07:17   
Data Edit need Empty Table Command





View Issue Details
562 [Sqlite Developer] DBA minor always 2006-09-23 21:07 2006-11-12 05:35
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.4  
   
Add DateTime Mapping
Add DateTime Mapping
There are no notes attached to this issue.





View Issue Details
1004 [Sqlite Developer] Help minor have not tried 2009-11-11 09:51 2009-11-12 07:36
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.5.x  
  3.5.x  
Add Database Schema Report Help
Add Database Schema Report Help
There are no notes attached to this issue.





View Issue Details
515 [Sqlite Developer] Option minor always 2006-08-05 02:21 2006-08-20 02:29
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.0  
   
Add Data Type Mapping Options , allow user to mapping data type to blob field
Add Data Type Mapping Options , allow user to mapping data type to blob field
There are no notes attached to this issue.





View Issue Details
943 [Sqlite Developer] Schema Editor minor have not tried 2009-04-06 23:47 2009-04-16 09:49
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.3.x  
  3.3.x  
Add Data Tabsheet to View Editor
Add Data Tabsheet to View Editor
There are no notes attached to this issue.





View Issue Details
941 [Sqlite Developer] DBA minor have not tried 2009-04-04 09:46 2009-04-04 09:47
sharpplus  
 
normal  
new  
open  
none    
none  
  3.4.x  
Add Data Analysis
Add Data Analysis
There are no notes attached to this issue.





View Issue Details
533 [Sqlite Developer] GUI minor always 2006-08-21 11:11 2006-08-26 09:52
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.1  
   
Add Context menu to Table Edit Form to allow user to insert, drop field and adjust field order
Add Context menu to Table Edit Form to allow user to insert, drop field and adjust field order
There are no notes attached to this issue.





View Issue Details
882 [Sqlite Developer] GUI minor have not tried 2008-11-10 21:56 2008-11-10 21:56
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.1.x  
   
Add Context Menu for Hex Editor
Add Context Menu for Hex Editor
There are no notes attached to this issue.





View Issue Details
564 [Sqlite Developer] DBA minor always 2006-10-03 02:24 2006-11-04 08:06
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.3  
   
Add collations Tree and reindex collation function
Add collations Tree and reindex collation function
There are no notes attached to this issue.





View Issue Details
538 [Sqlite Developer] SQL Editor minor always 2006-09-02 11:16 2009-04-20 00:31
sharpplus  
 
normal  
new  
open  
none    
none  
  3.4.x  
Add Code folding
Add Code folding
Notes
(0000208)
sharpplus   
2008-04-28 08:15   
Todo: Show Hint after the Collpased Text(...)
(0000209)
sharpplus   
2008-04-28 08:19   
Todo:When input enter , expand the collaped text.
(0000210)
sharpplus   
2008-04-28 09:15   
(edited on: 2008-04-28 09:28)
Todo:Allow to Copy Collapsed Block but prohibit copy Collapsed Block under column mode





View Issue Details
474 [Sqlite Developer] GUI minor always 2006-06-28 08:58 2006-06-30 09:13
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.7  
   
Add Close all command to windows menu
Add Close all command to windows menu
There are no notes attached to this issue.





View Issue Details
544 [Sqlite Developer] DBA minor always 2006-09-10 05:49 2006-09-12 10:37
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.2  
   
Add clipboard support to db image
Add clipboard support to db image
There are no notes attached to this issue.





View Issue Details
534 [Sqlite Developer] GUI minor always 2006-08-26 09:51 2006-08-26 09:51
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.1  
   
Add Clipboard , Edit Data As ... commands to Data Edit Grid context menu
Add Clipboard , Edit Data As ... commands to Data Edit Grid context menu
There are no notes attached to this issue.





View Issue Details
554 [Sqlite Developer] DBA minor always 2006-09-15 21:52 2007-03-04 09:08
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.6  
   
add case_sensitive_like option to database options
add case_sensitive_like option to database options
There are no notes attached to this issue.





View Issue Details
891 [Sqlite Developer] GUI minor have not tried 2008-12-02 08:43 2008-12-06 00:28
sharpplus  
 
normal  
closed  
fixed  
none    
none 3.2.x  
  3.2.x  
Add Card View
Add Card View
There are no notes attached to this issue.





View Issue Details
426 [Sqlite Developer] GUI minor always 2006-04-09 09:23 2006-04-09 09:23
sharpplus  
 
normal  
new  
open  
none    
none  
   
add capture output to user tools
add capture output to user tools
There are no notes attached to this issue.





View Issue Details
445 [Sqlite Developer] SQL Editor minor always 2006-05-29 08:37 2006-06-17 09:22
sharpplus  
 
normal  
closed  
fixed  
none    
none 1.6  
   
Add cancel query button to SQL Editor to cancel long time query operation
Add cancel query button to SQL Editor to cancel long time query operation
There are no notes attached to this issue.





View Issue Details
457 [Sqlite Developer] Performance minor always 2006-06-22 03:00 2009-02-10 03:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none  
   
Add Busy time out support
Add Busy time out support
Notes
(0000052)
sharpplus   
2006-06-22 21:48   
min value should be 0





View Issue Details
353 [Sqlite Developer] Help minor always 2005-11-22 07:39 2009-02-10 03:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none  
   
Add Bug Report to help
Add Bug Report to help
There are no notes attached to this issue.





View Issue Details
222 [Sqlite Developer] Web minor always 2005-09-15 09:31 2005-11-20 00:19
user2  
user2  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
Add bug report menu
Add bug report menu
There are no notes attached to this issue.





View Issue Details
486 [Sqlite Developer] DBA minor always 2006-07-10 21:36 2006-07-10 21:36
sharpplus  
 
normal  
new  
open  
none    
none  
   
Add Bookmark , Filter , Find to DBGrid
Add Bookmark , Filter , Find to DBGrid
There are no notes attached to this issue.





View Issue Details
210 [Sqlite Developer] DBA minor always 2005-09-11 05:22 2005-11-06 04:12
user2  
user2  
normal  
closed  
fixed  
none    
none 1.02Alpha2  
   
Add basic clipborad operation to Data Grid
Add basic clipborad operation to Data Grid
There are no notes attached to this issue.





View Issue Details
833 [Sqlite Developer] SQL Editor minor have not tried 2008-08-13 23:45 2008-08-13 23:45
sharpplus  
 
normal  
new  
open  
none    
none  
   
Add back and forward function
Add back and forward function
There are no notes attached to this issue.





View Issue Details
755 [Sqlite Developer] SQL Editor minor have not tried 2008-02-03 07:35 2008-02-04 09:03
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
Add attached database support for Schema Complete
Add attached database support to Schema Complete
There are no notes attached to this issue.





View Issue Details
737 [Sqlite Developer] Query Builder minor have not tried 2008-01-13 03:20 2008-02-16 10:59
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
Add attached database support for query builder
Add attached database support for query builder
There are no notes attached to this issue.





View Issue Details
785 [Sqlite Developer] DBA minor have not tried 2008-02-22 07:20 2008-02-23 08:04
sharpplus  
 
normal  
closed  
fixed  
none    
none 2.9  
  2.9  
Add attached database support for Find in Database
Add attached database support for Find in Database
There are no notes attached to this issue.





View Issue Details
238 [Sqlite Developer] DBA minor always 2005-09-22 21:25 2005-10-08 22:13
user2  
user2  
normal  
closed  
fixed  
none    
none 0.93  
   
Add advanced view management
Add advanced view management
There are no notes attached to this issue.





View Issue Details
923 [Sqlite Developer] Unicode minor have not tried 2009-02-23 01:14 2009-02-23 01:14
sharpplus  
 
normal  
new  
open  
none    
none  
   
Add a001916 traditional translate
Add a001916 traditional translate
There are no notes attached to this issue.





View Issue Details
1049 [Sqlite Developer] SQL Editor minor always 2010-08-04 22:15 2010-08-05 08:08
zengfd  
 
normal  
new 3.6.x  
open  
none    
none  
   
add a shortcut key to excute sql script
I wish you will add a shortcut key(F5) to excute sql script in next version.
Notes
(0000280)
sharpplus   
2010-08-05 08:08   
Dear zengfd, There already has a Ctrl+Enter shortcut to execute the current query.Would you please try with it.





View Issue Details
164 [Sqlite Developer] Install minor always 2005-09-01 05:51 2005-11-06 04:13
user2  
user2  
normal  
closed  
fixed  
none    
none 1.02Alpha2  
   
Add a sample sqlite db to install package
Add a sample sqlite db to install package
There are no notes attached to this issue.





View Issue Details
361 [Sqlite Developer] GUI minor always 2005-11-25 21:39 2009-02-10 03:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none  
   
Action Binding Button Flick very much
Action Binding Button Flick very much
There are no notes attached to this issue.





View Issue Details
902 [Sqlite Developer] Data Access Component minor have not tried 2009-01-24 02:02 2009-02-10 03:45
sharpplus  
sharpplus  
normal  
closed  
fixed  
none    
none 3.2.x  
  3.2.x  
"Get XXX Fields failed(''xx,x'' is not a valid integer value) " error openning the table or trigger(regression of 3.10)
"Get XXX Fields failed(''xx,x'' is not a valid integer value) " error message when open the table or trigger which has a field has following column Name(xx,x).(regression of version3.10)
There are no notes attached to this issue.





View Issue Details
1050 [Sqlite Developer] GUI minor always 2010-08-13 04:27 2010-08-19 08:30
datac  
sharpplus  
high  
closed  
fixed  
none    
none 3.7.x  
   
"Access violation" error on CTRL-C
In multiple places a "Access violation" error is shown when using the copy/paste shortcuts (CTRL-c or CTRL-v). Interestingly CTRL-x works. Full text of the error message box: Access violation at address 00BF571D in module 'SqliteDev.exe'. Read of address 0000001AC.
Double click any table to open it. In the "edit" tab double click the first columns name to select the text. Hit CTRL-c or CTRL-v.
I'm using Win7 x32 (but if I remember correctly that error was also on my old machine with WinXP). I'm using a German keyboard layout (but I don't think this changes anything).
Notes
(0000281)
sharpplus   
2010-08-13 09:09   
Thank you for your bug report, I will reproduce it and fix it as soon as possible.
(0000282)
sharpplus   
2010-08-19 08:30   
Dear Datac, I just fixed this bug which is a regression bug of ver 3.38. Please try with http://www.sqlitedeveloper.com/downloads/SqliteDev379.zip Thank you





View Issue Details
345 [Sqlite Developer] SQL Editor minor always 2005-11-19 01:34 2005-11-20 00:27
user2  
user2  
normal  
closed  
fixed  
none    
none 1.05Beta1  
   
use /* */ to comment multi line error message in log message
use /* */ to comment multi line error message in log message
There are no notes attached to this issue.