Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
1794	[IB LogManager] IBLMPump	block	always	2009-05-20 21:23	2010-03-03 11:01
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	high	OS Version:
Status:	closed	Product Version:	2.10.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	IBLMPump is not compatible with databases prepared with IBLM 2.10
Description:	IBLMPump is not compatible with databases prepared with IBLM 2.10
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
1739	[Database Workbench] NexusDB Module	major	always	2009-04-09 16:56	2009-04-09 18:06
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	high	OS Version:
Status:	closed	Product Version:	3.3.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Modifying a nullable column to not null can overwrite existing values
Description:	Modifying a nullable column to not null can overwrite existing values. If you select to enter a value when the Table Editor prompts you for it, this will overwrite any not null values in the column as well.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
1737	[Database Workbench] MS SQL Module	major	always	2009-04-09 15:45	2009-04-09 18:06
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	high	OS Version:
Status:	closed	Product Version:	3.3.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Modifying a nullable column to not null can overwrite existing values
Description:	Modifying a nullable column to not null can overwrite existing values. If you select to enter a value when the Table Editor prompts you for it, this will overwrite any not null values in the column as well.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
344	[NDB LogManager] NDB LogManager	major	always	2006-03-04 16:50	2006-03-22 18:21
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	high	OS Version:
Status:	closed	Product Version:	1.5.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Log data queries fail if there is date/time information included
Description:	Log data queries fail with a "Type mismatch" error message if there is date/time filter criteria included.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
298	[MS SQL LogManager] MS SQL LogManager	major	always	2006-02-25 15:09	2006-02-28 16:34
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	high	OS Version:
Status:	closed	Product Version:
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Support for Microsoft SQL Server 2005
Description:	Support for Microsoft SQL Server 2005
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
301	[MS SQL LogManager] MS SQL LogManager	major	always	2006-01-25 19:07	2006-02-28 16:33
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	high	OS Version:
Status:	closed	Product Version:
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Detecting changes in character fields with trailing spaces will fail
Description:	Detecting changes in character fields with trailing spaces will fail.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
192	[IB LogManager] IB LogManager	major	always	2006-01-25 18:54	2006-02-15 22:49
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	high	OS Version:
Status:	closed	Product Version:	2.5
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Can't connect to Firebird 2.0 database
Description:	I get an error message when connecting to a Firebird 2.0 database. It seems some system table queries aren't compatible with Firebird 2.0.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
195	[IB LogManager] IB LogManager	major	always	2006-01-25 19:07	2006-02-15 22:49
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	high	OS Version:
Status:	closed	Product Version:	2.5
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Detecting changes in character fields with trailing spaces will fail
Description:	Detecting changes in character fields with trailing spaces will fail.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
193	[IB LogManager] IB LogManager	major	always	2006-01-25 18:58	2006-02-15 22:49
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	high	OS Version:
Status:	closed	Product Version:	2.5
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Field names and reserved keywords
Description:	Field names equal to particular reserved keywords can't be used when defining the logging schema. The following field names caused an error when defining a logging schema: TIME, TIMESTAMP, TEMPORARY. There are probably more which aren't supported right now.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
99	[Database Workbench] MS SQL Module	major	always	2006-01-02 10:08	2006-02-10 16:45
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	high	OS Version:
Status:	closed	Product Version:	2.8.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	SQL2005: altering a column to a User Defined Type doesn't include schema name
Description:	When altering a column datatype to a user defined type, the schema name is not included and thus the ALTER statement fails if the UDT is not in the same schema. Eg: CREATE TYPE Test.T_INT FROM Int NULL ALTER TABLE dbo.TestTable   ALTER COLUMN i T_INT <save> Column, parameter, or variable 0000003: Cannot find data type T_INT
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
98	[Database Workbench] MS SQL Module	major	always	2005-12-30 17:22	2006-02-10 16:45
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	high	OS Version:
Status:	closed	Product Version:	2.8.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	User Defined Types are listed including OWNER name - which is invalid in SQL < 2005
Description:	Example: CREATE TABLE dbo.ARTIKEL (     ARTIKELID dbo.KEY_INT IDENTITY NOT NULL,     ARTIKELKENMERKID dbo.KEY_INT,     SORTERINGSKENMERKCODE1 dbo.SORTERINGSKENMERK_CODE,     SORTERINGSKENMERKCODE3 dbo.SORTERINGSKENMERK_CODE,     SORTERINGSKENMERKCODE2 dbo.SORTERINGSKENMERK_CODE,     SORTERINGSKENMERKCODE4 dbo.SORTERINGSKENMERK_CODE,     HOOFDGROEPID dbo.KEY_INT NOT NULL,     VBNCODE dbo.VBNCODE DEFAULT '00000',     BTWCODE dbo.BTWSOORT DEFAULT 'GN',     VBNDEFAULT dbo.D_BOOLEAN DEFAULT 'F',     INVOERDATUM DateTime DEFAULT getdate(),     WIJZIGINGSDATUM DateTime,     OMSCHRIJVING dbo.ARTIKEL_OMSCHRIJVING,     MODIFICATIEDATUMTIJD DateTime DEFAULT getdate(),     SORTERINGSKENMERKCODE34 Int,     CONSTRAINT PK_ARTIKEL PRIMARY KEY CLUSTERED (       ARTIKELID     ) ) ON "PRIMARY" GO
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
51	[Database Workbench] Firebird Module	major	always	2005-12-08 16:42	2006-02-10 16:45
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	high	OS Version:
Status:	closed	Product Version:	2.8.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	AV when disconnecting from DB after certain actions
Description:	This is what I do. 1. Restore the DB. 2. Open the DB in DBW. 3. Click on the + sign besides TABLES 4. Locate the table KUNDEDATA. 5. Dobbeltclick on kundedata 6. Go to page TABLE OBJECT 7. Go to page TRIGGERS 8. Mark the trigger KUNDEDATA_C5KUNDER_ 9. Press the button with an X (The delete trigger button) 10. Press the button the apply changes (Create/Alter table CTRL+S) 11. Locate table C5KUNDER 12. Right click on this, select DROP TABLE 13. Click on the + sign besides GENERATORS 14. Locate C5KUNDER_GEN 15. Right click on this and select DROP GENERATOR 16. Close connection to the DB This gave me this error 5 times in a row. Access violation at address 40009600 in module 'rtl70.bpl'. Read of address 00000100
Steps To Reproduce:
Additional Information:	See database backup
Attached Files:

Notes
(0000032) martijntonies    2005-12-08 17:23	Affects the InterBase module as well.
(0000033) martijntonies    2005-12-09 10:56	Fix available: http://misc.upscene.com/280_updates/dbwo_fb_issue51.zip [^] http://misc.upscene.com/280_updates/dbwo_ib_issue51.zip [^]

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
52	[Database Workbench] MySQL Module	major	always	2005-12-09 10:51	2006-02-10 16:45
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	high	OS Version:
Status:	closed	Product Version:	2.8.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Cannot access field "Non_unique" as type "Integer" on MySQL 5
Description:	Loading index information fails with the above message
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000034) martijntonies    2005-12-09 11:25	Hotfix: http://misc.upscene.com/280_updates/dbwo_mysql_issue52.zip [^]
(0000035) martijntonies    2005-12-10 14:39	Issue fixed with MySQL 4, but not with MySQL 5 - which worked fine before.
(0000036) martijntonies    2005-12-10 14:40	Right. MySQL 5 and MySQL 4 have this field behaving differently. In one, it's a 0 or 1, in the others it's recognized as a Boolean in the CoreLab MySQL access components. That would most probably explain why this error occured in teh first place. It's not solved in our abstract data access layer instead of the business components.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
104	[Database Workbench] MySQL Module	major	always	2006-01-02 11:46	2006-02-10 16:45
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	high	OS Version:
Status:	closed	Product Version:	2.8.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:	MySQL, any
Summary:	User Manager doesn't display any users
Description:	User Manager doesn't display any users - probably due to the new connectivity set.
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000073) martijntonies    2006-01-02 12:29	two issues: 1 - connectivity set fails a USE `mysql` on a cursor 2 - FieldAsBoolean failed on character 'Y', 'N' field.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
185	[Database Workbench] Schema Compare	major	always	2006-01-25 18:12	2006-02-10 16:45
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	high	OS Version:
Status:	closed	Product Version:	2.8.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Schema Compare only fetches objects in default/first schema in destination database
Description:	When performing a schema compare an on target database that supports multiple schemas, the Schema Compare will only check against the first available schema. It should check against all available schemas. For example, try on SQL 2005, comparing the AdventureWorks database against itself. It will bark on each object "not found in destination" that's not in the "dbo" schema (in my test setup).
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
213	[Database Workbench] Schema Compare	major	always	2006-01-26 08:13	2006-02-10 16:45
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	high	OS Version:
Status:	closed	Product Version:	2.8.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	On a "reverse lookup" the schema compare only checks first/default schema
Description:	When doing a reverse lookup, to see if there are objects inthe target datasource that don't exist in the source, only the first or default schema in the source is checked.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
1	[Database Workbench] MS SQL Module	major	always	2005-10-01 18:25	2005-12-05 18:05
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	high	OS Version:
Status:	closed	Product Version:	2.7.5
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	MSSQL can block Database Workbench
Description:	When fetching metadata info, DBW can be blocked if there's another user blocking resources at the server. After this, you often have to kill DBW in the Task Manager. When you have several scripts open or unsaved changes, you will loose the changes. Very very annoying.
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000001) martijntonies    2005-10-01 18:34	code adjusted to handle a "lock timeout". MS SQL queries now have a lock timeout so any resources locked will - after a couple of seconds - cause DBW to return a lock error. DBW will "unfreeze" in case of a blocking query.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2192	[Database Workbench] General	major	sometimes	2010-09-10 18:43	2010-09-10 19:26
Reporter:	scarleton	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	feedback	Product Version:	4.0.3
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:	IB 7.5.1
Summary:	"Not enough storage is available to process this command." when clicking on Data tab
Description:	I was working in DBW Pro. I opened one of our primary tables which have 39 columns and only two rows. I clicked on the Data table and got the error "Not enough storage is available to process this command." I had to click on the <Ok> button 3 times to make it go away. When I clicked on the Data tab again, it happened, but then I came to write this bug report, I went back and clicked on the Data tab to get the row count and it worked fine.
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000887) martijntonies    2010-09-10 18:56	What DBMS?
(0000888) scarleton    2010-09-10 19:22	Interbase, when I bring up the version in IBConsole, it states WI-V7.5.1.162
(0000889) martijntonies    2010-09-10 19:26	I have no idea why this would show up in DBW, Google reveals: http://support.microsoft.com/kb/225782 [^]

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2190	[Database Workbench] MS SQL Module	minor	always	2010-09-09 11:29	2010-09-09 12:14
Reporter:	edelcom	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.3
Product Build:		Resolution:	no change required
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Add progress indication when executing a lot of update statements
Description:	I was executing +/- 7500 update statements from within an Sql script window. These updates take a long time to run, but I have no way of knowing where in the update process the program currently is. The status bar displays 'running...' , the run query button is disabled, the stop button is enabled, but since I can click the rest of the menu options, I have no way of knowing if the updates are still running or not. Can you add a progress bar in these kind of scripts ?
Steps To Reproduce:
Additional Information:	Sample of the update statements: update artikel set a_catcodes = 'aab;aag;abo;aaw;ack;ajv;afw' where a_datum = '2001.10.16' and a_tmp = 1959 update artikel set a_catcodes = ' ' where a_datum = '2001.10.16' and a_tmp = 1963 update artikel set a_catcodes = 'ass;alr;aau;amh;afy;afz;aal;atu;aab;ani;acb' where a_datum = '2001.10.16' and a_tmp = 1966 So nothing special here.
Attached Files:

Notes
(0000882) martijntonies    2010-09-09 11:32	The Script Editor has a small progress bar in the bottom statusbar, didn't this run for you?
(0000883) edelcom    2010-09-09 11:45	I am doing the udpates now per 500 update statements. You execute the script ... it says running ... no progress bar, after a while you see the update statements appearing in the output windows, still no progress bar, than after a short period, the output says 'Script processed ...' and you see the progress bar very quickly moving from 0% to 100%. Is there some sort of post processing going on, which does not update the progress bar. When I was executing the 7500 statements, the output windows was empty all time and no progress bar was visible. It's like the program is builing some internal list during which no screen update is taking place. Anyway 500 lines is done fairly quickly, the 7500 upates I had to stop after 20 minutes ... and even that cancel took a long time.
(0000884) martijntonies    2010-09-09 11:47	Hm, it could be the MS module and the script parsing: what about if you end each statement with a ";" character? If not, the complete script is sent to the server as a single statement (ADO & MS SQL allow this).
(0000885) edelcom    2010-09-09 12:02	If you add the ';' character you see each line being processed in the output window, and now the progress bar is running. Maybe you could add a warning when update or insert statements are found without a ';' ending character ?
(0000886) martijntonies    2010-09-09 12:14	The parser is not that advanced. And it is allowed in MS SQL & ADO.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2191	[Database Workbench] General	feature	always	2010-09-09 12:07	2010-09-09 12:07
Reporter:	edelcom	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	new	Product Version:	4.0.3
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Add a feature to export to text without the last column being padded (or the one column being padded).
Description:	I was creating update statements from a table in my database like ' select 'update artikel set a_catcodes = ''' + a_catcodes + ''' where a_datum = ''' + Convert( Varchar(25), a_datum , 102) + ''' and a_tmp = ' + Cast( a_tmp as varchar(10)) + ';' as UpdText from artikel where not a_catcodes is null in order to run these updates another remote database. I wanted to export these statements to clipboard (or a text file), but the program added trailing spaces behind each statement up to and including the longest value created in this way. This made the output about 3 times longer than it should be. I would like to add an option to trim the last column (only column in this case).
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2168	[Database Workbench] Firebird Module	major	always	2010-08-04 12:57	2010-09-09 11:30
Reporter:	edelcom	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:	4.0.3
Product Build:	DbW 4.0.3 en 3.4.4	Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Opening table in FB1.5 in DBW4 gives 'arithmetic exception, numeric overflow, or string trunction' error, open it in DBW 3 is ok
Description:	I have a Firebird 1.5 database with several tables. Opening two out of these tables in DBW 4.0.3 produces a 'arithmetic exception, numeric overflow, or string trunction' error. Opening the same tables in the same database on the same server using DBW 3.4.4 works fine. As far as I can see , no special data is present in the row which produce the error (I can select and display some rows upto a certain point (using select * from ...) , but as soon as a specific row is reached, DBW 4 throws the error.
Steps To Reproduce:
Additional Information:	The screen dump shown is from a previous pc where DBW 3 was still installed (version .4.4) and om which DBW 4.0.2 was installed also). This pc runs XP Pro. The error remains in version 4.0.3 (installed on a new Windows 7 Prof pc).
Attached Files:

Notes
(0000875) edelcom    2010-08-27 12:16	Where you able to recreate this error in your development environment ? If so, any idea when it could be fixed ?
(0000881) edelcom    2010-09-09 11:30	Do you receive the database I send by email ?

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2189	[Database Workbench] General	minor	have not tried	2010-09-07 14:54	2010-09-07 14:54
Reporter:	martijntonies	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:	4.0.3
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Minor user interface errors
Description:	- "prompt for password"-functionality when connecting to a database shows the password in plain text
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2188	[Database Workbench] Firebird Module	minor	always	2010-09-06 09:56	2010-09-06 10:21
Reporter:	edelcom	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	feedback	Product Version:
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Executing a concatenation with data from the trigger system table truncates the name on first '_' character
Description:	As per an answer for one of my questions on StackOverflow : http://stackoverflow.com/questions/3599185/how-to-drop-all-triggers-in-a-firebird-1-5-database/3645346#3645346 [^] I tried the following select in a Firebird 1.5 database: select 'DROP TRIGGER ' || rdb$trigger_name || ';' from rdb$triggers   where (rdb$system_flag = 0 or rdb$system_flag is null) The resultset was as follows : CONCATENATION --------------- DROP TRIGGER BI DROP TRIGGER BI DROP TRIGGER BI ... DROP TRIGGER BI DROP TRIGGER BI Either the result is truncates at the third character (I have BIU_NAMED... and BI_NAMED... trigger names, or on the first '_' character, but the result is wrong. It might also be a Firebird fault (although a normal select from the same system table does produce a correct result).
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000880) martijntonies    2010-09-06 10:21	Seems to be caused by using Unicode in the connection charset (internally), not sure where this goes wrong. As a workaround, connect using charset = NONE

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2187	[Database Workbench] Firebird Module	minor	always	2010-08-29 14:07	2010-09-02 10:19
Reporter:	doychin	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:	4.0.3
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:	Firebird 2.1.2
Summary:	Reordering fields on New table shoud not produce ALTER POSITION
Description:	When you create new table there is not need to append "alter fields position" in the SQL when you decide to change the order of the fields in the table. 1. Create new Table. While defining fields change the order of any of the fields. 2. Check modification SQL and you will see that there is alter position statement. This one is not needed at all since fields in Create Table are properly ordered.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2180	[Database Workbench] General	feature	always	2010-08-18 15:19	2010-08-27 14:23
Reporter:	edelcom	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:	4.0.3
Product Build:	4.0.3.5	Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Extend 'Copy special - Copy to Delphi' to surround each line with Sql.Add(' and ');
Description:	It would be cool if the 'Copy to Delphi' would give an option to add the Sql.Add(' and '); around each line, so that this could be pasted into the Delphi editor to be used in Query components.
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000871) martijntonies    2010-08-19 09:57	Do note that with "Custom" you can add these if you like.
(0000874) edelcom    2010-08-27 12:13	Yes, but as far as I can tell, the values in this popup form are not saved, so you have to enter them again and again. When testing this can occur a lot of times.
(0000876) martijntonies    2010-08-27 12:16	What about the ability to create several custom entries (in the Preferences) that can be used from a sub-menu?
(0000877) edelcom    2010-08-27 13:39	... ok and than save the last selected entry ? Great :)
(0000878) martijntonies    2010-08-27 13:58	And then use any of your "persistent custom" ones and have the "add-hoc" custom one keep the last settings.
(0000879) edelcom    2010-08-27 14:23	:)

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2178	[Database Workbench] SQL Anywhere Module	minor	always	2010-08-16 00:58	2010-08-26 12:09
Reporter:	Bradley Bell	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	feedback	Product Version:	4.0.3
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:	v9 on Windows 2008
Summary:	Field name not found in TSybASAUniqueConstraint.GetColumns: ITEM
Description:	I run the following script: CREATE TABLE DBA.MASTER_TLMC (     RID Integer NOT NULL DEFAULT autoincrement,     ITEM NVarChar(50) NOT NULL,     ATA SmallInt NOT NULL,     ITYPE NVarChar(2) NOT NULL,     POS NVarChar(25) NOT NULL,     FREQ NVarChar(10) NOT NULL,     UOM NVarChar(5) NOT NULL,     ACTYPE NVarChar(10) NOT NULL,     ACMODEL NVarChar(10) NOT NULL,     REF NVarChar(50),     CONSTRAINT PK_MASTER_TLMC_RI PRIMARY KEY (       RID     ) )  IN traxdata ALTER TABLE DBA.MASTER_TLMC ADD CONSTRAINT U_MASTER_TLMC   UNIQUE (ITEM, ATA, ITYPE, POS, FREQ, UOM, ACTYPE, ACMODEL) CREATE INDEX I_MASTER_TLMC_ACMODEL_ACTYPE  ON DBA.MASTER_TLMC(ACMODEL, ACTYPE)  IN traxdata After refreshing the screen information from the screen I try and select the unique constraint from above. It gives me the error shown in the summary above. If I pull up the DDL from the table it shows the following: CREATE TABLE DBA.MASTER_TLMC (     RID Integer NOT NULL DEFAULT autoincrement,     ITEM NVarChar(50) NOT NULL,     ATA SmallInt NOT NULL,     ITYPE NVarChar(2) NOT NULL,     POS NVarChar(25) NOT NULL,     FREQ NVarChar(10) NOT NULL,     UOM NVarChar(5) NOT NULL,     ACTYPE NVarChar(10) NOT NULL,     ACMODEL NVarChar(10) NOT NULL,     REF NVarChar(50),     CONSTRAINT PK_MASTER_TLMC_RI PRIMARY KEY (       RID     ) )  IN traxdata GO ALTER TABLE DBA.MASTER_TLMC ADD CONSTRAINT U_MASTER_TLMC   UNIQUE ) GO CREATE INDEX I_MASTER_TLMC_ACMODEL_ACTYPE  ON DBA.MASTER_TLMC(ACMODEL, ACTYPE)  IN traxdata GO The Unique constraint information is gone. However, in the constraints tab I can see U_MASTER_TLMC except in the columns field there is ITEM followed by about 60 spaces followed by a comma and then ATA, followed by about 60 spaces... and so on and so forth. Looks like a little bug. Additionally, none of the columns show up under the Constrain Columns pick list.
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000873) martijntonies    2010-08-26 12:09	Hello Bradley, I've been trying, but I cannot reproduce this problem. Can you tell me more about this?

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2164	[Database Workbench] General	minor	always	2010-07-19 14:13	2010-08-26 11:00
Reporter:	doychin	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	4.0.2
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:	Firebird 2.1.2
Summary:	Access violation when deleting focused row on single row resultset
Description:	When I try to delete a records from result grid that was selected by the following query results in AV. select CASH_ROW_PROMO.* from CASH_ROW_PROMO join SRV_CONTRACTROW on ((CASH_ROW_PROMO.ROWFKID = SRV_CONTRACTROW.ID) AND CASH_ROW_PROMO.ROWFKEXP = SRV_CONTRACTROW.EXPIRING) join CRM_CONTRACT on ((SRV_CONTRACTROW.CONTRACTFKID = CRM_CONTRACT.ID) AND SRV_CONTRACTROW.CONTRACTFKEXP = CRM_CONTRACT.EXPIRING) where CRM_CONTRACT.CONTRACTNO = '4002000624'
Steps To Reproduce:
Additional Information:	In my case if this query produces 1 record and I select it in the grid and then try to delete it using delete button I get Access violation at address 00521E0D in module 'DBW4.exe'. Read of address 00000000 If I have 2 records and I try to delete second record it works.
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2176	[Database Workbench] General	major	always	2010-08-12 13:16	2010-08-26 10:54
Reporter:	heimey	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:	4.0.3
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:	Firebird 2.1.3.18185_0
Summary:	Not possible to insert a time in combined date & time fields within the Table Editor or SQL Editor
Description:	If I want to change a Table-entry of a Timestamp field within the table editor I'm only able to enter/change the date but not the time!
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2173	[Database Workbench] Data Export/Import	minor	always	2010-08-05 08:44	2010-08-26 10:39
Reporter:	mivi71dk	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:	4.0.3
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Data export should use number formatting settings like SQL Editor does
Description:	If I do a select I can in settings decide how numbers are presented. i.e. #0.000 When I press "Export resultset" the results are not presented in that way. Its just presented as is. Ex. Value: 12,78787878787 Resultset: 12,78 Export: 12,7878878787
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2186	[Database Workbench] Firebird Module	feature	N/A	2010-08-26 09:00	2010-08-26 09:00
Reporter:	doychin	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:	4.0.3
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:	Firebird 2.1.2
Summary:	Add support for debugging execute block statements
Description:	Right now in order to debug execute block statement for firebird i have to write it into Stored procedure and then debug it.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2182	[Database Workbench] General	trivial	always	2010-08-25 02:12	2010-08-25 13:35
Reporter:	jeroenp	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	4.0.3
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	text editor: search replace has two UI controls bound to &C
Description:	Alt-C is bound to both the "Case sensitive" checkbox and the "Cancel" button. It would be wise if the Cancel buttons were only bound to the Esc key. --jeroen
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2185	[Database Workbench] Data Export/Import	major	have not tried	2010-08-25 13:31	2010-08-25 13:32
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	4.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Exported CSV data with date/time in Windows format can not be imported
Description:	Exported CSV data with date/time in Windows format can not be imported
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2183	[Database Workbench] Data Export/Import	minor	have not tried	2010-08-25 11:16	2010-08-25 13:30
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	4.0.3
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Import of multi-line CSV data in a single column fails
Description:	Import of multi-line CSV data in a single column fails, see test file by Jack.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2181	[Database Workbench] Firebird Module	minor	always	2010-08-20 14:08	2010-08-25 09:51
Reporter:	J	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:	3.4.4
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:	Firebird v2.1.3
Summary:	unsupported column type:0 error
Description:	Using Database Workbench v3.4.4.4Pro and firebird server v2.1.3 "unsupported column type:0" error is returned when a select query is run before a CTE query for example: 1. run "select * from x" returns data from x 2. run "with y as (select * from z) select * from y" returns "unsupported column type: 0" error at this point I have to disconnect from database and connect back to the databse 3. run "with y as (select * from z) select * from y" again and data is returned This will happen if the sequence is ran from same SQL editor window or different pages from within that window. The error will also occur if I run cte query first (in which case data will be returned) then run palin select query (returns data) and run cte query again (error is returned) However if queries are run from separate SQL editor windows the error doesn't occur. The column type of tables plays no role in this.
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000872) J    2010-08-20 14:10	after the error occurs it is actually not necessary to disconnect from the database and connect back; closing the offending sql editor window is enough

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2174	[Database Workbench] Diagramming	minor	always	2010-08-09 17:46	2010-08-18 12:06
Reporter:	Rich Ackerson	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:	4.0.3
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:	SQL Server 2000
Summary:	Errors adding descriptions if MS_Description does not exist
Description:	I was testing the features of your diagrammer. I connected to a MSSQL session and dragged some existing tables onto a diagram. After visualizing the foreign keys, I double-clicked on some tables in the diagram to add descriptions. Without saving the diagram, I clicked on DBW's navigation tree and DBW asked if I wanted to save the changes I made in the diagram. I answered YES and received an error indicating "MS_Description does not exist". I don't understand why DBW would report that MS_Description does not exist for my tables as they used to have extended properties defined. Perhaps I somehow deleted this property when I removed the extended property description for my table? Either way, I know it is possible for an editor to re-add a missing MS_Description to a table because I was able to do just this using another SQL editor. So whether my issue is a bug or "by-design", do you think it would be possible for DBW to be able to handle the re creation of MS_Description if/when necessary?
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2179	[Database Workbench] General	minor	always	2010-08-18 12:04	2010-08-18 12:06
Reporter:	davesellers	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:	4.0.2
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:
Summary:	SQL Insight can interfere with text literals
Description:	Entering SQL: Select * from table where field = 'dave' The problem is, when I get as far as: Select * from table where field = If there is even a very slight pause before I hit the ' key, what happens is the list of available fields pops up and the ' key selects the first in the list and I end up with: Select * from table where field = somefieldname'dave' My feeling is that the ' key should not select an item from the SQL Insight list of fields but should, instead, dismiss the list.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2167	[Database Workbench] General	tweak	always	2010-07-30 07:59	2010-08-01 11:12
Reporter:	doychin	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	confirmed	Product Version:	4.0.3
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Wrapped text for checkboxes
Description:	- Print Options: Press Ctrl+P while in Single SQL Editor.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2166	[Database Workbench] General	feature	N/A	2010-07-28 18:27	2010-08-01 11:11
Reporter:	scarleton	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:	3.4.4
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:
Summary:	new Copy Special for C# strings
Description:	In C# the when a string spans multiple lines, the quote is not needed at the end of the first line and the beginning of the next line. it looks like this: string sqlStmt = @"SELECT *                      FROM aTable                     WHERE id > 10"; Currently I am using the Copy to C/C++ and it would be great to have a Copy to C#.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2165	[Database Workbench] Visual Query Builder	minor	always	2010-07-23 15:16	2010-07-23 15:22
Reporter:	plillejo	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:	4.0.3
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:	Firebird 2.1.3
Summary:	Can not use Stored procedure with parameters
Description:	SELECT IW.F_CABLE_ID, e.TAG_NO FROM   GET_IW(10051) IW   LEFT JOIN EQUIPMENT_TABLE e ON IW.OUT_EQ_ID = e.EQ_ID
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2158	[Database Workbench] SQL Anywhere Module	minor	have not tried	2010-07-14 16:46	2010-07-20 13:34
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	No OWNER drop down box for Materialized Views
Description:	No OWNER drop down box for Materialized Views
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2163	[IB LogManager] IBLMRedo_CommandLine	minor	always	2010-07-19 14:06	2010-07-20 08:33
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	2.10.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Support for empty string PKEYn_VALUE values
Description:	N.A.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2162	[IB LogManager] IBLMRedo_CommandLine	major	always	2010-07-19 13:53	2010-07-19 14:05
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	2.10.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Infinite loop when processing log records with no/empty primary key values (PKEYn, PKEYn_VALUE)
Description:	N.A.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2154	[Database Workbench] SQL Anywhere Module	minor	have not tried	2010-07-14 11:43	2010-07-19 11:41
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	4.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	SQL Anywhere 11 Text Index based tables are listed as normal tables
Description:	SQL Anywhere 11 Text Index based tables are listed as normal tables, these shouldn't be listed
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2160	[Database Workbench] SQL Anywhere Module	minor	have not tried	2010-07-15 18:14	2010-07-19 11:41
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	4.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Grant Manager fails on Materialized Views (SQL Anywhere 11)
Description:	Grant Manager fails on Materialized Views (SQL Anywhere 11)
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2161	[Database Workbench] SQL Anywhere Module	minor	have not tried	2010-07-19 10:03	2010-07-19 10:04
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	4.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Grant Manager sometimes lists Stored Procedures twice
Description:	Grant Manager sometimes lists Stored Procedures twice
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2159	[Database Workbench] ADO/ODBC Explorer	feature	always	2010-07-15 07:42	2010-07-15 13:55
Reporter:	LachlanG	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:	3.4.5
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Make SQL Insight available for ODBC Explorer
Description:	There is no SQL Insight for ODBC databases.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2155	[Database Workbench] Firebird Module	minor	always	2010-07-14 13:07	2010-07-14 14:31
Reporter:	heimey	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:	4.0.3
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:	Firebird 2.1.3.18185
Summary:	Overlay Function unknown in Procedur editor
Description:	If I want to use the OVERLAY() function within a procedure there comes a message "Unknown command 'OVERLAY'." If I use it within a normal SQL like this SELECT    OVERLAY('00000' placing '1' from 1 for 1) FROM    RDB$DATABAS it works fine
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000868) heimey    2010-07-14 14:31	The same behavior occures with the LPAD() function. If I find another one I will open a new track with a list of not supported functions

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2157	[Database Workbench] Firebird Module	minor	always	2010-07-14 14:23	2010-07-14 14:26
Reporter:	heimey	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.3
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	LPAD Function unknown in Procedur editor
Description:	If I want to use the internal LPAD() function within a procedure there comes a message "Unknown command 'LPAD'." If I use it within a normal SQL like this SELECT   LPAD('1111',31,'0') FROM    RDB$DATABASE it works fine
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000867) martijntonies    2010-07-14 14:26	Can you group these with 0002155 ? Make it "several Firebird 2.1 functions not supported" or something. Thanks.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2156	[Database Workbench] Firebird Module	tweak	always	2010-07-14 13:49	2010-07-14 13:59
Reporter:	heimey	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:	4.0.3
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:	Firebird 2.1.3.18185
Summary:	Function Highlighting of some function is not implemented
Description:	Some firebird internal functions are not highlighted as known functions. For example Dateadd, Reverse, Overlay etc.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2030	[Database Workbench] Firebird Module	feature	have not tried	2010-03-24 10:12	2010-07-14 11:37
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	assigned	Product Version:
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Support Firebird 2.5 features
Description:	Support Firebird 2.5 features
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2153	[Database Workbench] SQL Anywhere Module	feature	have not tried	2010-07-13 16:12	2010-07-14 11:29
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	assigned	Product Version:
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Full SQL Anywhere 12 support
Description:	Full SQL Anywhere 12 support
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2144	[Database Workbench] General	block	always	2010-06-16 06:10	2010-07-13 17:13
Reporter:	mduncan47	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.2
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Valid blob field name causes "fieldname_Indicator" is not a valid component name for some specific names
Description:	A common first field name in many Firebird tables I use is "MFK$GUID". When I try to go into data view I get the error "MFK$GUID_Indicator" is not a valid component name.
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000852) martijntonies    2010-06-16 08:28	What's its datatype?
(0000858) mduncan47    2010-06-16 16:17	It is Char(16) OCTETS - Not Null

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2143	[Database Workbench] MS SQL Module	minor	have not tried	2010-06-15 12:09	2010-07-13 17:13
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.2
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Refresh List on Tables in MS SQL 2005 and up fails when there are new tables created by SQL
Description:	Refresh List on Tables in MS SQL 2005 and up fails
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2142	[Database Workbench] General	minor	always	2010-06-15 11:17	2010-07-13 17:13
Reporter:	doychin	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.2
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:	Firebird 2.1.2
Summary:	Prepare Query stays pressed in case of error in the query
Description:	When you try to prepare query that contains some errors a message about the error is displayed but prepare button stays pressed. It should not stay pressed in case of error.
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000857) martijntonies    2010-06-16 14:27	it's behaviour wasn't affected though

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2141	[Database Workbench] DataPump	minor	have not tried	2010-06-15 08:51	2010-07-13 17:13
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.2
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Column sizing issue
Description:	There's an issue with resizing the columns of the tables/fields - some are fixed, other respond in a less-than-obvious manner.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2138	[Database Workbench] DataPump	block	always	2010-06-10 09:08	2010-07-13 17:13
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.2
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Error: The requested properties cannot be supported on MS SQL Server connection
Description:	Error: The requested properties cannot be supported on MS SQL Server connection. Connect to a SQL Server db and try transferring data from it to another destination.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2137	[Database Workbench] MySQL Module	minor	always	2010-06-09 15:00	2010-07-13 17:13
Reporter:	doychin	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:	MySQL 5.0.X
Summary:	MySQL raises "#42000 Query was empty" on several occasions
Description:	- When I use Drop from DB Navigator I get error message #42000Query was empty - when trying to open user manager from Enterprise Manager you get an error message "#42000 Query was empty"
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2136	[Database Workbench] General	minor	always	2010-06-09 14:59	2010-07-13 17:13
Reporter:	doychin	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.2
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:	Firebird 2.1.2
Summary:	Can't load no-bom UTF-8 encoded file in Script Editor, works fine in SQL Editor
Description:	The script is loaded as ANSI so UTF-8 encoded characters are not properly displayed in SQL Editor.
Steps To Reproduce:
Additional Information:	Probably an option to specify the encoding to use when loading SQL script will be good solution
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2151	[Database Workbench] Data Export/Import	crash	have not tried	2010-07-08 15:05	2010-07-13 17:13
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.2
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	DWX Import fails with Access Violation in options screen
Description:	DWX Import fails with Access Violation in options screen
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2148	[Database Workbench] Firebird Module	minor	always	2010-06-25 13:32	2010-07-13 17:13
Reporter:	heimey	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.3
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:	Firebird 2.1.3.18185
Summary:	EXTRACT(week from sometimestamp) produces error in psql
Description:	There seems to be a Problem with using the EXTRACT-Function within stored Procedures at a Firebird 2.1 Database. If I use “woy=EXTRACT(WEEK FROM current_timestamp)” with woy declared as integer their comes an error message “Undeclared identifier: ‘WEEK’ ” But in a normal SQL-Window this functions without problems: “SELECT EXTRACT (week from current_timestamp) FROM RDB$DATABASE”
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2147	[Database Workbench] MySQL Module	minor	have not tried	2010-06-23 09:18	2010-07-13 17:13
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.2
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Missing images for buttons in Constraint Editor column lists
Description:	Missing images for buttons in Constraint Editor column lists
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2145	[Database Workbench] General	feature	always	2010-06-22 09:17	2010-07-13 17:13
Reporter:	jeroenp	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.3
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	in "Search, Find in Database" add buttons for "all" and "none"
Description:	When searching for meta data, I usually want to search all or most categories. Right now that takes some 6 mouse clicks (depending on the DBMS). It would be nice if the buttons "All" and "None" were added.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2140	[Database Workbench] DataPump	minor	always	2010-06-14 05:56	2010-07-13 17:13
Reporter:	MariusTurnkey	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.2
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:	Firebird 2.1.3 from MS SQL Server 2005
Summary:	DataPump to Firebird/InterBase works incorrectly when committing at intervals
Description:	When you make use of Datapump in 4.0.2 and you select that it will commit every lets say 1000 transactions, all the records you are pumping after the first commit only includes the first character of the data are you are porting. If you select to only commit all as one transaction, all the data is ported correctly. My source database is a MS SQL Server 2005 database, which I access through ODBC.
Steps To Reproduce:
Additional Information:	Have not tried to port from other ODBC or Native Databases.
Attached Files:

Notes
(0000850) martijntonies    2010-06-15 10:21	Does this happen with CHAR or NCHAR data? Can you get me sample table metadata for both databases?
(0000851) MariusTurnkey    2010-06-16 05:22	Hi Martijn, Its VARCHAR data in both cases (Source and Target) Source Metadata (MS SQL Server) SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[COMMODITY](     [IRN] [int] IDENTITY(1,1) NOT NULL,     [COMCODE] [varchar](20) NOT NULL,     [DESCRIPTION] [varchar](60) NULL,     [GL_ACCOUNT] [varchar](10) NULL,     [DEPTCODE] [varchar](10) NULL, PRIMARY KEY CLUSTERED (     [IRN] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF Target Metadata (Firebird 2.1.3) Domains are in this form: CREATE DOMAIN D_VC60 AS  VARCHAR(60)  COLLATE NONE; CREATE TABLE COMMODITY (   IRN INTEGER NOT NULL,   COMCODE D_VC20 ,   DESCRIPTION D_VC60 ,   GL_ACCOUNT D_VC10 ,   DEPTCODE D_VC10 ,  CONSTRAINT PK_COMMODITY PRIMARY KEY (IRN) ); SET TERM ^^ ; CREATE TRIGGER COMMODITY_ID FOR COMMODITY ACTIVE BEFORE INSERT POSITION 0 AS begin   if ( (new.IRN is null) or (new.IRN = 0) )   then new.IRN = gen_id(COMMODITY_GEN, 1); end ^^ SET TERM ; ^^
(0000853) martijntonies    2010-06-16 09:18	Before I started investigating this, I must say I had no idea why the "commit frequence" could cause the behaviour you're describing, and I still have no idea. I cannot reproduce this behaviour in any way. Make sure you use an ODBC driver that suits SQL Server 2005?
(0000854) MariusTurnkey    2010-06-16 09:50	Hi, I doubt that the ODBC driver can have anything to do with it, as it works 100% if you do not select the intermittent commit internal, and the commit interval has nothing to do with the MS SQL Server, but rather the Firebird Server, as far as I understand it. I can consistently reproduce it on my development machine. If you want to you can take over the machine via TeamViewer and have a look if it will assist in finding the problem. If you are interested in this please make contact with me on my Gtalk account. mj.labuschagne at gmail dot com , and I will give you the access codes over there. Regards Marius
(0000855) martijntonies    2010-06-16 09:54	Yes, the commit interval is related to the target database. Yet, I fail to understand how this can influence how the data is being transferred. You can send the details of TeamViewer to m.tonies @ upscene.com
(0000856) martijntonies    2010-06-16 12:31	Firebird database has NONE as the charset, this seems to be the cause.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2139	[Database Workbench] MySQL Module	minor	have not tried	2010-06-11 08:21	2010-07-13 17:13
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Cannot execute a Stored Routine with NCHAR parameter
Description:	Cannot execute a Stored Routine with NCHAR parameter
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2050	[Database Workbench] InterBase Module	tweak	always	2010-04-07 09:26	2010-07-13 17:13
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Make syntaxis check to recognize Stored procedure name when used in recursive algorithm
Description:	When you create new stored procedure and you want to use recursion you will use that procedure name in the code. In case you just wrote the procedure code and that procedure does not exists when you try to check it's syntax before creating it it will show error that there is no such procedure in the database. In this case you can check that procedure name is same like the one that is checked and in that case this error message can be avoided.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2037	[Database Workbench] Firebird Module	tweak	always	2010-03-28 13:09	2010-07-13 17:13
Reporter:	doychin	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:	Firebird 2.1.2
Summary:	Make syntaxis check to recognize Stored procedure name when used in recursive algorithm
Description:	When you create new stored procedure and you want to use recursion you will use that procedure name in the code. In case you just wrote the procedure code and that procedure does not exists when you try to check it's syntax before creating it it will show error that there is no such procedure in the database. In this case you can check that procedure name is same like the one that is checked and in that case this error message can be avoided.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
1881	[Database Workbench] Firebird Module	feature	always	2009-10-03 12:54	2010-07-13 17:13
Reporter:	doychin	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	3.4.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:	Firebird 2.1.2
Summary:	Stored procedure syntax check should recognize Merge syntax
Description:	Get some Merge sample and run it trough syntax check. It will display errors. SP compiles without problems and executes properly
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
1872	[Database Workbench] General	minor	always	2009-09-22 23:38	2010-07-09 11:17
Reporter:	rdebay	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	3.4.1
Product Build:		Resolution:	won't fix
Projection:	none
ETA:	none
DBMS and Version:	Firebird 1.5.3
Summary:	Open SQL editor locks resources
Description:	1. Open view editor 2. Execute query which uses the view, in SQL Editor 3. Unprepare query 4. Alter view Step four will fail to drop the view. In order to alter the view, you must close the SQL Editor. Unpreparing the query doesn't release the hold on the view.
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000760) rdebay    2009-09-28 16:02	1. Prepare Query containing stored procedure (insert into...select from sp) 2. Continue Prepared Query 3. Drop stored procedure & table it references This works as expected. 1. Run Query containing stored procedure 2. Drop stored procedure & table This fails, as the table is in use. To drop the table you must then prepare the query, which will fail as the SP has been dropped. However, the table is now free and silently dropped.
(0000866) martijntonies    2010-07-09 11:17	Apparently caused by metadata cache at the server side, cannot be fixed.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2040	[Database Workbench] Data Export/Import	major	always	2010-03-28 13:45	2010-07-09 10:52
Reporter:	doychin	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	3.4.3
Product Build:		Resolution:	unable to reproduce
Projection:	none
ETA:	none
DBMS and Version:	Firebird 2.1.2
Summary:	DWX Export or Import is not working
Description:	I did an export of 2 tables to a dwx file. After that I tried to import this same file into another database. Result was that one of the tables remained empty(original table contains lots of records) The other table contained some garbage. Use the DML from this report and create tables. Then use the attached DWX file to import data.
Steps To Reproduce:
Additional Information:	CREATE TABLE TMP_STORAGE_ARTICLE (   ID INTEGER NOT NULL,   EXPIRING NUMERIC( 18, 1) NOT NULL,   CREATING NUMERIC( 18, 1),   ACCOUNT INTEGER,   GROUP_ID INTEGER,   ENABLED INTEGER,   RAZFASOVKA_TYPE INTEGER,   RAZFASOVKA_QUANTITY INTEGER,   NAME VARCHAR( 128) ,   DESCRIPTION VARCHAR( 256) ,   GROUPFKID INTEGER,   GROUPFKEXP NUMERIC( 18, 1),   RAZFASOVKA_BRUTO DOUBLE PRECISION,   RAZFASOVKA_NETO DOUBLE PRECISION,   FKID INTEGER,   FKEXP NUMERIC( 18, 1),   PARENT_ID INTEGER,   QUANTITY DOUBLE PRECISION,   FIRM_ID INTEGER,   FIRM_FKID INTEGER,   FIRM_FKEXP NUMERIC( 18, 1),   CODE VARCHAR( 64) ,   CLIENTFKID INTEGER,   CLIENTID INTEGER,   REQUIRES_PART_NUMBER INTEGER,   WRAPPING_ID INTEGER,   WRAPPINGFKID INTEGER,   WRAPPINGFKEXP NUMERIC( 18, 1),   MATERIAL INTEGER,   QUANTITY_TYPE INTEGER,   CLIENTFKEXP NUMERIC( 18, 0),  CONSTRAINT PK_TMP_STORAGE_ARTICLE PRIMARY KEY (ID, EXPIRING) ); CREATE TABLE TMP_STORAGE_ARTICLE_GROUP (   ID INTEGER NOT NULL,   EXPIRING NUMERIC( 18, 1) NOT NULL,   ACCOUNT INTEGER,   CREATING NUMERIC( 18, 1),   DESCRIPTION VARCHAR( 256) ,   NAME VARCHAR( 128) ,   PARENTID INTEGER,   FKID INTEGER,   FKEXPDATE NUMERIC( 18, 1),   ORDERID INTEGER,   IDENTIFIER VARCHAR( 32) ,   ISMATERIAL INTEGER,  CONSTRAINT PK_TMP_STORAGE_ARTICLE_GROU PRIMARY KEY (ID, EXPIRING) );
Attached Files:	charly_articles.zip (13 KB) 2010-03-28 13:45

Notes
(0000862) martijntonies    2010-07-09 10:12	I can import the data just fine (Windows set to Bulgarian locale), but I'm not sure what it should look like, as I see all kind of unknown characters for me ;) I've just fixed an error in DBW 4 though that made it impossible to import data, does this work for you in 3.4.4?
(0000863) doychin    2010-07-09 10:43	In 3.4.4 only some records in TMP_STORAGE_ARTICLE_GROUP are imported. There is nothing in TMP_STORAGE_ARTICL. I suspect that this could be an encoding problem in 3.4.4
(0000864) martijntonies    2010-07-09 10:45	I cannot find anything wrong then, shall we ignore this and concentrate on v4?
(0000865) doychin    2010-07-09 10:51	If I'm the only one that complaints about this issue you can ignore it. Just make sure Import/Export in 4 works properly ;-)

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2150	[Database Workbench] General	feature	always	2010-07-06 06:45	2010-07-06 10:04
Reporter:	edelcom	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:	4.0.1
Product Build:	4.0.1.1	Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Extend 'Paste special' syntax to recognize string list syntax from Delphi's Evaluate/Modify form
Description:	When you inspect a string list (TQuery.Sql) from within Delphi, it shows its contents like : 'select k.naam, k.straat, k.PostCode + " " + p.Gemeente as Woonplaats,'#$D#$A'k.Email, k.Website, k.telefoonnr, k.faxnr from'#$D#$A'klanten k, postnrs p'#$D#$A'where k.PostCode = p.PostCode'#$D#$A'and k.PostCode_Uniek = p.PostCode_Uniek'#$D#$A'and k.Code = :Code'#$D#$A It would be great if the paste special command would filter out these #$D#$A strings (replacing them by Cr/Lf) and would strip the single quotes
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2149	[Database Workbench] Firebird Module	minor	always	2010-06-27 10:53	2010-07-05 15:30
Reporter:	doychin	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.2
Product Build:		Resolution:	duplicate
Projection:	none
ETA:	none
DBMS and Version:	FB 2.1.2
Summary:	Trying to open Data tab for table RDB$FIELDS produces error message
Description:	Open connection to FB 2.1.2 database and try to open RDB$FIELDS table. Table structure is displayed but when you try to switch to Data tab to browse data an error message is displayed: ''RDB$MISSING_VALUE_Indicator'' is not a valid component name
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000859) doychin    2010-06-27 10:58	Same happens with following tables: RDB$TRIGGERS, RDB$TRANSACTIONS Table RDB$SECURITY_CLASSES produces this message: ''RDB$ACL_Indicator'' is not a valid component name Tables RDB$RELATION_FIELDS and RDB$PROCEDURE_PARAMETERS produce message: ''RDB$DEFAULT_VALUE_Indicator'' is not a valid component name Table RDB$RELATIONS produces message: ''RDB$EXTERNAL_DESCRIPTION_Indicator'' is not a valid component name Table RDB$PROCEDURES produces message: ''RDB$DEBUG_INFO_Indicator'' is not a valid component name I suggest you test all system tables. Probably some other will produce similar error messages.
(0000860) doychin    2010-06-27 10:59	Also when you try to browse any of the above tables from Single SQL using Select statement same error message is displayed on the bottom of the window.
(0000861) martijntonies    2010-07-05 15:30	duplicate of 0002144

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2146	[Database Workbench] General	feature	always	2010-06-22 10:32	2010-06-22 10:35
Reporter:	jeroenp	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Add 'synchronize' button
Description:	When editing a stored procedure, table, or other object, it is often handy to be able to select that particular object in the treeview for the current server. It would be nice if a 'synchronize' button was added to all Object Editors that expands the treeview and select the object you are editing/viewing. --jeroen
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2054	[Database Workbench] Firebird Module	minor	have not tried	2010-04-07 15:41	2010-06-15 10:22
Reporter:	mspoor	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0
Product Build:		Resolution:	unable to reproduce
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Unexpected behaviour when running SQL script after 'unsuccessful metadata update object INDEX is in use'
Description:	In using SQL Script I came across the following strange behaviour: once I have seen an 'unsuccessful metadata update object INDEX is in use' error while executing my script, the following happens: - I choose 'Abort' - Now I rerun (or run from any point) the script - this seems to run fine until the first 'commit;' statement it runs into (I have a few scattered throughout my script), then it skips to the end of the script and says it has finished executing (no errors). - However, it has not committed (in the popup dialog it has the commit/rollback options active) and trying to commit will reshow the 'unsuccessful metadata update object INDEX is in use' error. I have seen this twice now. But I don't know how to force the initial 'unsuccessfull metadata update object INDEX is in use' error...
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000822) martijntonies    2010-04-07 15:47	Can I get a copy of the script and a database to run it? But even then, these can be hard to reproduce.
(0000823) mspoor    2010-04-07 16:39	I'm afraid I cannot give a database. I will try to create an example script.
(0000841) mspoor    2010-04-29 14:51	I cannot reproduce the INDEX is in use error here any more. The only way to check the signaled behaviour would be to 'force' an error in code, which ofcourse I cannot :-) So you can close this item.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2129	[Database Workbench] General	minor	have not tried	2010-05-26 16:58	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Some text items not saved in UTF8 when they should
Description:	Some text items not saved in UTF8 when they should.
Steps To Reproduce:
Additional Information:	- InterBase DB statistics - InterBase server log - Firebird DB statistics - Firebrid server log
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2128	[Database Workbench] General	crash	have not tried	2010-05-25 13:14	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Possible access violation when closing after using ODBC connectivity
Description:	Possible access violation when closing after using ODBC connectivity, the access violation would occur in ntdll.dll
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2126	[Database Workbench] Visual Query Builder	tweak	have not tried	2010-05-21 13:43	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Several usuability improvements
Description:	- list table & view column datatypes - list stored routine parameter datatypes - key columns in bold - number of selected columns in header
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2125	[Database Workbench] Visual Query Builder	minor	have not tried	2010-05-21 13:17	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Cancel button in Visual Query Builder aks for confirmation to accept query
Description:	Cancel button in Visual Query Builder aks for confirmation to accept query, on Cancel, it should just close.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2122	[Database Workbench] ADO/ODBC Explorer	minor	have not tried	2010-05-21 11:24	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Using "refresh list" on an ODBC datasource raises an Abstract Error
Description:	Using "refresh list" on an ODBC datasource raises an Abstract Error
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2119	[Database Workbench] ADO/ODBC Explorer	feature	have not tried	2010-05-21 10:34	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Support for ODBC 1.0 datasources
Description:	Support for ODBC 1.0 datasources
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2118	[Database Workbench] Visual Query Builder	minor	have not tried	2010-05-20 13:41	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Builder does not spread out tables on canvas but puts them all in top left corner
Description:	When editing an existing query, builder does not spread out tables on canvas but puts them all in top left corner.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2113	[Database Workbench] General	minor	always	2010-05-20 09:19	2010-06-14 08:52
Reporter:	mivi71dk	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Changes to Syntax Highlighting don't stick between sessions
Description:	If I change the settings in here to i.e. Twillight the Colors change to i.e. black background. But this will only be so until I close the program. Next time I start it its back to default (white background)
Steps To Reproduce:
Additional Information:	Running on Windows 7 64 bits
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2112	[Database Workbench] ADO/ODBC Explorer	minor	have not tried	2010-05-19 15:17	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	ODBC connection to SolidDB (ODBC 1.0) fails with "Field TABLE_SCHEM not found"
Description:	ODBC sometimes fails when fetching tables/views. SolidDB 2.2
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2110	[Database Workbench] ADO/ODBC Explorer	minor	have not tried	2010-05-18 12:54	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	ODBC data sources sometimes fail when fetching tables/views
Description:	ODBC data sources sometimes fail when fetching tables/views. - dbf sources for example
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2106	[Database Workbench] Data Export/Import	tweak	always	2010-05-11 21:17	2010-06-14 08:52
Reporter:	Patrick_NY	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	3.4.3
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:	Mysql - probably any
Summary:	Export Resultset file/folder selection should be more clear
Description:	If I run a simple Sql Select, then click the icon for Export Resultset, it appears to work but I see no output file. This gets me every time. The output is actually in the DBWB Program Directory with the DLLs and EXEs. As I run through the Export dialog I type in a filename, and I see the directory in the other box, and it looks good. But, they are not connected. That is the Edit box for "Folder". I'm not sure why that is populated and the File box is not. Maybe the Folder Edit box could be grayed out when folder is not selected. Also, always a dangerous thing when user errors get written to the program folder.
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000846) martijntonies    2010-05-11 22:40	The dialog has two boxes, including two radiobuttons: you select either one of them. They are not connected by design. For some exports, you can select a folder as the output cause it results in multiple files, for other types of export, you have to select an output file. If you enter a file specification without a folder, the application folder is used. Where did you get the impression that these two boxes -should- be "connected"?

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2105	[Database Workbench] General	tweak	have not tried	2010-05-11 11:28	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Faster sorting on header click of Data tab in Table/View Editor
Description:	Faster sorting on Data tab in Table/View Editor. Currently, the result set gets cached on the client, server side sorting is possible.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2104	[Database Workbench] Oracle Module	minor	have not tried	2010-05-11 08:54	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Quick Browse or Data tab in Table Editor fails on Index-Organized tables
Description:	Quick Browse or Data tab in Table Editor fails on Index-Organized tables with message ORA-03115: unsupported network datatype or representation
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2102	[Database Workbench] General	minor	have not tried	2010-05-10 10:34	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	BLOB Editor for text inserts (unicode) BOM
Description:	BLOB Editor for text inserts (unicode) BOM
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2095	[Database Workbench] General	minor	have not tried	2010-05-03 09:23	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	No images in status bar, like statement recorder doesn't flash red recording sign in status bar
Description:	Statement recorder doesn't flash red recording sign in status bar Also message images.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2094	[Database Workbench] General	major	always	2010-04-29 14:49	2010-06-14 08:52
Reporter:	mspoor	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:	Firebird 2.0.5
Summary:	select from table with BLOB view eats up LOT's of memory (compared to DBWB3)
Description:	When I do a simple    select * from table I see a very big difference in memory usage in the DBWB4 version compared to the DBWB3 version. Such a difference that it in fact becomes unworkable. Selects I used to be able to do without any problem, I now cannot anymore because DBWB4 crashes due to out-of-memory... Comparison:                          Reported memory usage (Windows taskmanager) :Tables WITH BLOB: DBWB3 DBWB4 ---------------------------------------------------------------------- Table A (48.699 rows) 40MB 157MB Table B (12.784 rows) 35MB 134MB Table C (17.317 rows) 41MB grows to 1.9GB and crashes... Table A & B contain a blob field with not so much data (a few textlines per blob). Table C contains JPG images, mostly <64KB per image. When I select one standard field from table C, it works fine (17.317 rows retrieved), if I do a select with only the BLOB field, I see the same effect as above: memory grows to 1.9GB and crash....
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2088	[Database Workbench] General	major	have not tried	2010-04-28 08:47	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Very slow response in SQL Editor, eg when editing data in larger resultsets
Description:	Very slow response while editing data in larger resultsets. Open a resultset 100.000+ rows, edit a value, move away from the record: it takes quite a while to do that.
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000845) martijntonies    2010-05-11 12:26	Slowness now only occurs after sorting by a header click as this requires caching all rows to the client. If you don't do this, editing is fast like it normally was, even for large resultsets.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2083	[Database Workbench] Visual Query Builder	major	always	2010-04-26 16:49	2010-06-14 08:52
Reporter:	scarleton	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	3.4.4
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Invalid SELECT statement on inner joins within left join
Description:	I have a complex select statement, one where I am doing a left join to a group of things that are all inner joined together. Visual Query Builder is not able to handle it. I will put the select statement in the additional information and will email Martijn the database in which this select is used.
Steps To Reproduce:
Additional Information:	SELECT   CAT.ITEMTEXT AS CATEGORY,   QI.UDA_HOST_MAPPING_ID,   (SELECT COUNT(QI2.UDA_QUESTIONITEM_ID) FROM UDA_QUESTIONITEM QI2 WHERE QI2.INSTANCE_ID = QI.INSTANCE_ID AND QI2.DATE_TIME_CREATED <= QI.DATE_TIME_CREATED) AS QI_VERSION_NUM,   QI.ITEMTEXT AS QI_ITEMTEXT,   QI.QUESTION AS QI_QUESTION,   QI.ENDDATE AS QI_ENDDATE,   T.TITLE AS TEMPLATE_TITLE,   (SELECT COUNT(TC3.UDA_AT_COMPONENT_ID) FROM UDA_AT_COMPONENT TC3 WHERE TC3.INSTANCE_ID = TC.INSTANCE_ID AND TC3.DATE_TIME_CREATED <= TC.DATE_TIME_CREATED) AS TEMPLATE_VERSION_NUM,   INT_IS_EQUAL(T.UDA_AT_TEMPLATE_ID, TC.INSTANCE_ID) INITIAL_VERSION,   (SELECT COUNT(*) FROM ASR3_MDS_MAIN WHERE UDA_AT_TEMPLATE_ID = TC.UDA_AT_COMPONENT_ID) USAGE_CNT,   T.STARTDATE AS TEMPLATE_STARTDATE,   TC.ENDDATE AS TEMPLATE_ENDDATE FROM   UDA_QUESTIONITEM QI   INNER JOIN UDA_CATEGORY CAT ON CAT.UDA_CATEGORY_ID = QI.UDA_CATEGORY_ID   LEFT JOIN (     UDA_AT_COMPONENT TC       INNER JOIN UDA_AT_TEMPLATE T ON T.UDA_AT_TEMPLATE_ID = TC.UDA_AT_COMPONENT_ID AND TC.ENDDATE = (SELECT Max(TC2.ENDDATE) FROM UDA_AT_COMPONENT TC2 WHERE TC2.ENDDATE > 'now' AND T.UDA_AT_TEMPLATE_ID = TC2.UDA_AT_COMPONENT_ID)       INNER JOIN UDA_AT_TEMPLATE_SECTION TS ON TS.UDA_AT_TEMPLATE_ID = T.UDA_AT_TEMPLATE_ID       INNER JOIN UDA_AT_SECTION_QUESTION SQ ON SQ.UDA_AT_SECTION_ID = TS.UDA_AT_SECTION_ID       INNER JOIN UDA_AT_QUESTION_BOX QB ON SQ.UDA_AT_QUESTION_BOX_ID = QB.UDA_AT_QUESTION_BOX_ID   ) ON QB.UDA_QUESTIONITEM_ID = QI.UDA_QUESTIONITEM_ID WHERE   (     QI.ENDDATE = (SELECT Max(Q.ENDDATE) FROM UDA_QUESTIONITEM Q WHERE Q.ENDDATE > 'now' AND Q.INSTANCE_ID = Q.INSTANCE_ID)     OR     TC.ENDDATE = (SELECT Max(TC4.ENDDATE) FROM UDA_AT_COMPONENT TC4 WHERE TC4.ENDDATE > 'now' AND TC4.UDA_AT_COMPONENT_ID = TC.UDA_AT_COMPONENT_ID)   )
Attached Files:

Notes
(0000839) scarleton    2010-04-26 17:03	Here is the link to the DB, it is good through May 3rd: https://www.yousendit.com/download/OHo1eFVlUzdsMHl4dnc9PQ [^]
(0000842) martijntonies    2010-05-03 14:12	Confirmed, forwarded to the creators of this 3rd party control.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2070	[Database Workbench] General	tweak	have not tried	2010-04-21 08:39	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Add ability to specify file encoding when saving text files
Description:	Replace file open (where required) and save dialogs for text with dialogs that have an "Encoding" box, this allows people to manually select an encoding if no encoding indicator is available.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2134	[Database Workbench] Firebird Module	minor	always	2010-06-07 10:16	2010-06-14 08:52
Reporter:	doychin	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:	Firebird 2.1.2
Summary:	Setting transaction isolation after opening SQL Editor doesn't appear to work
Description:	When you run a select and rerun that select many times with read commited the results reported by query should change in case there are other transactions running on that DB and making changes to data. Instead ReadCommiited behaves like Snapshot isolation.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2132	[Database Workbench] Firebird Module	minor	have not tried	2010-05-27 16:31	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Problems with "local" connection in Firebird
Description:	Problems with "local" connection in Firebird
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2131	[Database Workbench] General	minor	have not tried	2010-05-27 15:10	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Object Templates are listed twice in Preferences
Description:	Object Templates are listed twice in Preferences
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2130	[Database Workbench] General	feature	have not tried	2010-05-27 10:40	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Free Lite Editions for MySQL, InterBase and Firebird
Description:	Free Lite Editions for MySQL, InterBase and Firebird
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2101	[Database Workbench] InterBase Module	minor	have not tried	2010-05-06 11:20	2010-06-14 08:52
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Cannot connect to InterBase Desktop Edition
Description:	Cannot connect to InterBase Desktop Edition, raises a message about not being able to connect to (local).
Steps To Reproduce:
Additional Information:
Attached Files:	iblocal.bmp (464 KB) 2010-05-06 11:20

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2135	[Database Workbench] DataPump	major	have not tried	2010-06-08 11:17	2010-06-08 13:23
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.1
Product Build:		Resolution:	no change required
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Out of range values on larger NUMERIC value when transferring from Firebird to SQL Server
Description:	Out of range values on larger NUMERIC value when transferring from Firebird to SQL Server
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2133	[Database Workbench] General	feature	N/A	2010-06-03 13:46	2010-06-07 10:42
Reporter:	MariusTurnkey	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:	4.0.2
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:	Firebird 2.1.3
Summary:	Continuous save of SQL Pages
Description:	Hi, Please add a feature where DBW continuously saves your SQL Pages to a work or log file. This will allow the user to retrieve SQL's created for a particular session.
Steps To Reproduce:
Additional Information:	My motivation for this is that I did not save my constructed queries which took me at least 5 hours to construct this morning and then Windows decided to give me a Blue Screen resulting in me loosing all my work for the morning. Its not the fault of DBW, I know I should have saved it myself, but most developers do not do that while they are focusing on constructing solutions.
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2127	[Database Workbench] General	tweak	have not tried	2010-05-25 08:20	2010-05-25 13:18
Reporter:	martijntonies	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	confirmed	Product Version:	4.0.1
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:
Summary:	SQL Editor "autocommit" flag should be restored after (un)checking and re-opening Editor
Description:	SQL Editor "autocommit" flag should be restored after (un)checking and re-opening Editor
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2123	[Database Workbench] ADO/ODBC Explorer	minor	have not tried	2010-05-21 11:26	2010-05-21 15:04
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	3.4.4
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Using "refresh list" on an ODBC datasource raises an Abstract Error
Description:	Using "refresh list" on an ODBC datasource raises an Abstract Error
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2124	[Database Workbench] General	feature	N/A	2010-05-21 12:19	2010-05-21 12:46
Reporter:	mspoor	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	acknowledged	Product Version:	3.4.4
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:	Fi
Summary:	Add popup menu item in Role object popup to jump to grant manager for that specific role
Description:	It would be ever so easy, if one could open the grant manager on a specific role right from the popup menu in treeview.
Steps To Reproduce:
Additional Information:
Attached Files:	Role popup.JPG (17 KB) 2010-05-21 12:19

Notes
(0000849) mspoor    2010-05-21 12:20	DBMS and version should read 'Firebird, but probably others too...'

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2121	[IB LogManager] IBLMPump	feature	always	2010-05-21 11:18	2010-05-21 11:20
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	2.10.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Remove detailed processing debug output
Description:	N.A.
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000848) thomassteinmaurer    2010-05-21 11:19	A status line after each transaction commit is now printed.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2120	[IB LogManager] IBLMPump	feature	always	2010-05-21 11:17	2010-05-21 11:20
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	2.10.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Print throughput (records per second) in statistic
Description:	N.A.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2109	[IB LogManager] IBLMPump	feature	always	2010-05-18 09:24	2010-05-21 11:10
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	2.10.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Configurable commit interval for DML operations in destination database
Description:	N.A.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2117	[IB LogManager] IBLMRedo_CommandLine	feature	always	2010-05-20 11:01	2010-05-20 11:03
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	2.10.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Improve performance (throughput)
Description:	N.A.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2116	[IB LogManager] IB LogManager	feature	always	2010-05-20 10:58	2010-05-20 11:00
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	2.10.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Make storing the SQL trace in a redo project optionally
Description:	N.A.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2114	[IB LogManager] IBLMRedo_CommandLine	feature	always	2010-05-20 10:31	2010-05-20 10:58
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	2.10.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Make storing the SQL trace optionally
Description:	N.A.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2115	[IB LogManager] IBLMRedo_CommandLine	feature	always	2010-05-20 10:57	2010-05-20 10:57
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	2.10.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Show statistic about skipped records
Description:	These are UPDATE/INSERT records without column log records.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2108	[IB LogManager] IBLMPump	minor	always	2010-05-18 09:21	2010-05-20 10:29
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	2.10.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	An error/exception doesn't get displayed, if the verbose switch (-v) is not used
Description:	An error/exception should always be printed, even if the -v switch is not used.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2107	[IB LogManager] IBLMRedo_CommandLine	minor	always	2010-05-18 09:21	2010-05-20 10:29
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	2.10.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	An error/exception doesn't get displayed, if the verbose switch (-v) is not used
Description:	An error/exception should always be printed, even if the -v switch is not used.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2111	[Database Workbench] General	major	always	2010-05-19 01:00	2010-05-19 10:54
Reporter:	1222tmiller	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	feedback	Product Version:	4.0.1
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:	Oracle 10g
Summary:	Blob Editor when view a CLOB does not use regular fonts and you are unable to select and copy characters.
Description:	Blob Editor when view a CLOB does not use regular fonts and you are unable to select and copy characters. Using Oracle 11 local driver, Oracle 10g database. I like the ideal of having fixed font as an option (like the Use Word-Wrap), but I would prefer the default font be the old font.
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000847) martijntonies    2010-05-19 10:54	I have no problems selecting or copying characters, can you clarify?

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2103	[Database Workbench] Oracle Module	minor	have not tried	2010-05-11 08:54	2010-05-11 09:18
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	3.4.4
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Quick Browse or Data tab in Table Editor fails on Index-Organized tables
Description:	Quick Browse or Data tab in Table Editor fails on Index-Organized tables with message ORA-03115: unsupported network datatype or representation
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2100	[IB LogManager] IB LogManager	feature	always	2010-05-06 09:39	2010-05-06 09:51
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	2.10.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Configurable commit interval for DML operations in redo project
Description:	N.A.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2097	[IB LogManager] IBLMRedo_CommandLine	feature	always	2010-05-06 00:03	2010-05-06 09:39
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	2.10.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Configurable commit interval for DML operations
Description:	N.A.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2099	[IB LogManager] IBLMRedo_CommandLine	minor	always	2010-05-06 00:07	2010-05-06 00:12
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	2.10.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Separate transactions for iterating through log data from distributed DML operations
Description:	Isolation level, read-only, 2PC etc.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2098	[IB LogManager] IBLMRedo_CommandLine	feature	always	2010-05-06 00:04	2010-05-06 00:12
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	2.10.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	Calculate, display and store records/sec. throughput per redo cycle
Description:	N.A.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2096	[IB LogManager] IB LogManager	minor	always	2010-05-04 08:34	2010-05-04 10:18
Reporter:	thomassteinmaurer	Platform:
Assigned To:	thomassteinmaurer	OS:
Priority:	normal	OS Version:
Status:	resolved	Product Version:	2.10.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
Summary:	IB LogManager turns FORCED WRITES automatically ON for the primary connected database
Description:	This setting should be left as is.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2057	[Database Workbench] Diagramming	feature	have not tried	2010-04-07 17:14	2010-05-03 15:18
Reporter:	daltoncalford	Platform:
Assigned To:		OS:
Priority:	normal	OS Version:
Status:	feedback	Product Version:
Product Build:		Resolution:	open
Projection:	none
ETA:	none
DBMS and Version:	Any
Summary:	White Board/Scratch Designer
Description:	Very often when specifying a database design, you are not sure of what you are doing until well into the design process. With most E/R tools, you are required to fill out detailed information that you may not have yet decided upon. For example, you may decide you need a surrogate key, but have not decided to use auto-incrementing numbers, generated UUIDs or even what domain/datatype will hold that generated value. If you had the ability to enter a list of strings (each representing a column within the table design), then come back later in the design process to assign datatypes, you make the design process flow easier. The biggest problem with large project design, is loosing the design due to the details (loosing the forest for the trees). To have the diagrammer's entity box have one more tab that is more free-form, would make the diagramming tool a very powerful development group design feature.
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000843) martijntonies    2010-05-03 14:18	Dalton, When creating a conceptual diagram, the Entity Editor has a Notes box on the first tab and you can freely add attributes without datatypes. Is this what you mean?
(0000844) daltoncalford    2010-05-03 15:18	Not really, From the standpoint of a design session, you may know you need some form of entity to hold a specific type of data. You may even know some of the basic columns you will need in that entity, but that may change. So, from a designers standpoint, you need to be able to drop an entity onto the diagram, give it a description, perhaps give it a name, and have a (Delphi Coder Hat coming on) Tstringlist that you populate with the idea of one column per line. No data/domain type, no description. No other tabs on the entity. The whole diagram has a button on it called "realize" (or something like that) and it's first job would be to go through all the entities and put together a list of unique names, which in turn becomes the domain list. Once the domain list is produced, a process goes through all the entities, and changes the scratch column list to a real column list with domains. The current system works from there. This would allow for white board design of the underlying data structures without worrying about assigning/deciding upon datatypes until the overall structure is complete. Just remember, the name, notes and column list are all different elements in the design process and any one of them may change at any time. Keeping them separate until a physical model is required is a very powerful tool. It would also be interesting if you had certain types of entities that never would be realized in metadata - ie, diagram objects that represent Servers, Databases, Schema, Client Applications, Middle Tier objects etc. All of these things impact and must be designed for in the database, and there are no tools that currently aid the developer to do this. Right now, I am using Agilian (http://www.visual-paradigm.com/product/ag/) [^] Sql Maestro and Morfik to coordinate my dev./design team. We develope it in Agilian, redo all the work into SQL Maestro, and then code the front end with Morfik. It would be nice to replace Agilian and Sql Maestro with a single package that is customized for database design/firebird.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2093	[Database Workbench] General	minor	have not tried	2010-04-29 08:26	2010-04-29 18:18
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	SQL Editor doesn't say "all rows: <number>" when using Fetch All
Description:	SQL Editor doesn't say "all rows: <number>" when using Fetch All, it says: "rows fetched" despite fetching all rows.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2092	[Database Workbench] General	minor	have not tried	2010-04-29 08:25	2010-04-29 18:18
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0.1
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Delay with large resultset and running another query
Description:	Delay with large resultset and running another query, there's a noticeable delay if all rows are fetched and another query is run.
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2084	[Database Workbench] Data Export/Import	minor	have not tried	2010-04-26 20:46	2010-04-29 18:18
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	Excel export truncates data & headers to single char
Description:	Excel export truncates data & headers to single char
Steps To Reproduce:
Additional Information:
Attached Files:

There are no notes attached to this issue.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2082	[Database Workbench] SQL Anywhere Module	minor	always	2010-04-26 14:57	2010-04-29 18:18
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none
DBMS and Version:
Summary:	When creating new database you can't specify in the Select file dialog non-existing file (also other dialogs)
Description:	Usually when you create new Database you have to specify non-existing file. I use the select dialog to select the folder where my database will be stored. I also sometimes select existing file from that directory and change it's name. At this point i can't click Open because there is no such file an error message is displayed. Instead I have to select existing file and then change the file name in DBW dialog.
Steps To Reproduce:
Additional Information:
Attached Files:

Notes
(0000838) martijntonies    2010-04-26 15:00	Also in Backup/Restore options for database archive/file.

Viewing Issue Advanced Details
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2081	[Database Workbench] General	minor	have not tried	2010-04-26 14:51	2010-04-29 18:18
Reporter:	martijntonies	Platform:
Assigned To:	martijntonies	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	4.0
Product Build:		Resolution:	fixed
Projection:	none