New Ticket Existing and Public Tickets   
Ticket:  410  Created: 8/14/2015 12:00 AM
 
Public/Private:
Status:    Assigned:      
Lean Application / Version:
Priority:       Due Date:  
Name:   Invesco Houston USA    
Email:   -
Phone:    Estimate Hours:  
Description:      
  Start:    Complete:  

Visible to Requestor Comment User Time
Select Issue found to only affect columns where 'Merge Number Format' was used. Issue fixed in EDT release 3.3.136. Lean Software 8/20/2015 11:05:26 AM
Select Chip, please can you highlight the row that has issue, then select the EDT Ribbon option 'View SQL' and email the SQL to support@leansoftware.net. Meanwhile there is an Oracle technique for escaping the apostrophe : q'!!' this notation allows the of use single quotes we think will work for you - please see http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/fundamentals.htm#sthref336 Lean Software 8/18/2015 5:56:25 PM
Select Unfortunately, I'm still getting the ORA-01754 error (Quoted string not properly terminated). Not sure if it will come through on your web interface, but it's having trouble with: Treasurer's Could it be a character-set thing? Invesco Houston USA 8/18/2015 5:44:43 PM
Select EDT is designed to automatically escape a single apostrophe with a double apostrophe for MS SQL Server, or to escape the character for MySQL. With ORACLE however this functionality was not working correctly. We have published a service release as EDT V3.3.129 http://leansoftware.net/Productsdownloads/ExcelDatabaseTasks(EDT)/Download.aspx Thank you for reporting. Lean Software 8/18/2015 1:04:12 PM
Select I need to insert into a text field a value that may contain an apostrophe. What I wound up doing is creating a Work Field, loaded the data into that, and in the field that actually gets loaded into the database, created a formula: =SUBSTITUTE(RC[-1], "'","''") (replaced single quotes with two single quotes) This works, but is there an easier/better way to accomplish this? Thanks Invesco Houston USA 8/14/2015 9:20:24 PM

Tags:

Skip Navigation Links.
Bug report
Consultancy
Expand DatabaseDatabase
Feature request
Feedback
Help request