DbVis 6 - error when executing table level commands in object view
a
anonymous
started a topic
about 17 years ago
[This topic is migrated from our old forums. The original author name has been removed]
Hi,
If I right click a table and choose 'empty table' or 'drop table', in the left frame of the object view, they give me syntax errors when I choose 'execute'.
The drop table syntax comes out as: drop table informix.racehdr_barrier_log_temp (null) - the '(null)' on the end gives the syntax error - it did not show this in the sql preview.
The empty table using truncate comes out as: truncate table "informix"."racehdr_barrier_log_temp" - the quotes around the table name are the syntax error.
Similarly with emtpy table using delete, it puts quotes around the table name.
Is there somewhere I can set the correct syntax for these options? Working against Informix IDS 10 databases.
Product: DbVisualizer Personal 6.0 Build: #1247 (2007/07/09 19:06) Java VM: Java HotSpot(TM) Client VM Java Version: 1.5.0_12-b04 Java Vendor: Sun Microsystems Inc. OS Name: Windows XP OS Arch: x86 OS Version: 5.1
Informix Dynamic Server 10.00.TC6 IBM Informix JDBC Driver for IBM Informix Dynamic Server 3.00.JC3
[This reply is migrated from our old forums.] [Attachment has been removed.]
Re: DbVis 6 - error when executing table level commands in object view
Hi Bryce,
The "Drop Table" works fine if you select one of the "Mode" choices (this is however an issue as at least one should be selected by default).
The other one is a bug and will be fixed.
Both of these are solved in the updated database profile for Informix which you'll find attached to this post.
Save it as [b]DBVIS-HOME/resources/profiles/informix.xml[/b]
Regards
Roger
Roger Bjärevall
said
about 17 years ago
[This reply is migrated from our old forums.]
Re: DbVis 6 - error when executing table level commands in object view
Bryce,
Note also that there is a 6.0.2 version available. I recommend that you upgrade.
Regards
Roger
a
anonymous
said
about 17 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: DbVis 6 - error when executing table level commands in object view
Thanks Roger, I'll go download 6.0.2 and check it out. Regards, Bryce.
anonymous
If I right click a table and choose 'empty table' or 'drop table', in the left frame of the object view, they give me syntax errors when I choose 'execute'.
The drop table syntax comes out as:
drop table informix.racehdr_barrier_log_temp (null)
- the '(null)' on the end gives the syntax error - it did not show this in the sql preview.
The empty table using truncate comes out as:
truncate table "informix"."racehdr_barrier_log_temp"
- the quotes around the table name are the syntax error.
Similarly with emtpy table using delete, it puts quotes around the table name.
Is there somewhere I can set the correct syntax for these options?
Working against Informix IDS 10 databases.
Product: DbVisualizer Personal 6.0
Build: #1247 (2007/07/09 19:06)
Java VM: Java HotSpot(TM) Client VM
Java Version: 1.5.0_12-b04
Java Vendor: Sun Microsystems Inc.
OS Name: Windows XP
OS Arch: x86
OS Version: 5.1
Informix Dynamic Server
10.00.TC6
IBM Informix JDBC Driver for IBM Informix Dynamic Server
3.00.JC3
Regards,
Bryce Stenberg.