Start a new topic

DbVis 6 - error when executing table level commands in object view

[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

Regards,
  Bryce Stenberg.

[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
[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
[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.