Start a new topic

In-cell editing bug

[This topic is migrated from our old forums. The original author name has been removed]

Trying to do in-cell editing in the grid: (cell datatype is varchar(500) null) Original cell value Y|7:00 PM Need to add a pipe character | THe value becomes Y|7:00 PM| After Update is clicked, the pipe char is not saved.. Look at the logs below.. something is throwing the dbVis off.. If i add a space after a pipe, then it works.. but i end up with an extra space at the end.. please check sorry for a messy post.. ; ------------------------- Product Information ------------------------ Product: DbVisualizer Personal 7.1.5 Build: #1587 (2011/02/23 08:13) Java VM: Java HotSpot(TM) Client VM Java Version: 1.6.0_13 Java Vendor: Sun Microsystems Inc. OS Name: Windows XP OS Arch: x86 OS Version: 5.1 ------------------------- Connected Databases ------------------------ Database Type: Sybase ASE Major Version: 12 Minor Version: 5 Profile: sybase-ase Connection Message: Adaptive Server Enterprise Adaptive Server Enterprise/12.5.4/EBF 14919 ESD#7/P/Sun_svr4/OS 5.8/ase1254/2093/64-bit/FBO/Thu Oct 11 09:25:36 2007 jConnect (TM) for JDBC (TM) jConnect (TM) for JDBC(TM)/6.05(Build 26023)/P/EBF14466/JDK14/Thu Mar 15 1:05:45 2007 Database Type: Sybase ASE Major Version: 12 Minor Version: 5 Profile: sybase-ase Connection Message: Adaptive Server Enterprise Adaptive Server Enterprise/12.5.4/EBF 14919 ESD#7/P/Sun_svr4/OS 5.8/ase1254/2093/64-bit/FBO/Thu Oct 11 09:25:36 2007 jConnect (TM) for JDBC (TM) jConnect (TM) for JDBC(TM)/6.05(Build 26023)/P/EBF14466/JDK14/Thu Mar 15 1:05:45 2007 Database Type: Sybase ASE Major Version: 12 Minor Version: 5 Profile: sybase-ase Connection Message: Adaptive Server Enterprise Adaptive Server Enterprise/12.5.4/EBF 14919 ESD#7/P/Sun_svr4/OS 5.8/ase1254/2093/64-bit/FBO/Thu Oct 11 09:25:36 2007 jConnect (TM) for JDBC (TM) jConnect (TM) for JDBC(TM)/6.05(Build 26023)/P/EBF14466/JDK14/Thu Mar 15 1:05:45 2007 --------------------------- Debug Printouts -------------------------- 15:04:07 [DEBUG Thread-784 J.setCurrentCatalog] DbConnection='ETMA_NYDEV_DS (dbo)' Catalog='tss_ds_dev2' Schema='null' NewCatalog='tss_ds_dev2' 15:04:07 [DEBUG pool-2-thread-195 C.?] DefaultEditor-138: SybConnection.prepareStatement("update dbo.iTB_FuncParams set P3 = ? where APP_ID = ? and FunctionName = ?") 15:04:07 [DEBUG Thread-784 O.?] index=[1] name=[P3] value=[Y|07:00 PM] type=[|String] options=[nullable ds=255 dt=VARCHAR] 15:04:07 [WARN Thread-784 O.?] {color:#ff0000}*Unknown data type*: {color}String. Will bind parameter name=[P3] value*=[Y|07:00 PM]* type=*{color:#ff0000}[|String]{color}* options=[nullable ds=255 dt=VARCHAR] as Object 15:04:07 [DEBUG pool-2-thread-195 B.?] DefaultEditor-138: SybPreparedStatement.setObject(1, "Y|07:00 PM") 15:04:07 [DEBUG Thread-784 O.?] index=[2] name=[APP_ID (where)] value=[CEMRXP] type=[String] options=[where pk ds=10 dt=VARCHAR] 15:04:07 [DEBUG pool-2-thread-195 B.?] DefaultEditor-138: SybPreparedStatement.setString(2, "CEMRXP") 15:04:07 [DEBUG Thread-784 O.?] index=[3] name=[FunctionName (where)] value=[CONFIG_1] type=[String] options=[where pk ds=32 dt=VARCHAR] 15:04:07 [DEBUG pool-2-thread-195 B.?] DefaultEditor-138: SybPreparedStatement.setString(3, "CONFIG_1") 15:04:07 [DEBUG pool-2-thread-195 B.?] DefaultEditor-138: SybPreparedStatement.execute() 15:04:07 [DEBUG Thread-784 G.?] Commit: ETMA_NYDEV_DS (dbo) 15:04:07 [DEBUG pool-2-thread-195 C.?] DefaultEditor-138: SybConnection.commit() 15:04:07 [DEBUG pool-2-thread-195 C.?] DefaultEditor-138: SybConnection.setAutoCommit(true) 15:04:07 [DEBUG Thread-785 J.execute] Executing... 15:04:07 [DEBUG Thread-785 J.setCurrentCatalog] DbConnection='ETMA_NYDEV_DS (dbo)' Catalog='tss_ds_dev2' Schema='null'

[This reply is migrated from our old forums. The original author name has been removed]

Re: In-cell editing bug
Ok, please do. The worst thing is that the app did not give any warning; - just dropped the character from the value that was intended to be saved. Thanks.
[This reply is migrated from our old forums.]

Re: In-cell editing bug
Hi Alex, To workaround this problem change Variable Delimiter from: || to ^^. We will check into a permanent fix. Best Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: In-cell editing bug
Roger, Variable Identifier Prefix: *$$* Suffix *$$* Variable Delimiter: || Please keep in mind that I am trying to do in-grid editing and not sql script that uses variables.. thanks!
[This reply is migrated from our old forums.]

Re: In-cell editing bug
Alex, In Tool Properties->General->Variables, what is the setting for Variable Delimiter? Regards Roger