https://sourceforge.net/p/tora/bugs/906/2020-11-27T14:43:29.692000ZRecent changes to 906: Failure to update values with mixed cases field name through HMI2020-11-27T14:43:29.692000Z2020-11-27T14:43:29.692000Zerasohttps://sourceforge.net/u/sf-eraso/https://sourceforge.netbc69abc48934fc8fdf361fdabcd9cb532dcd6be8

<div class="markdown_content"><p>Hello,</p> <p>With Tora 3.2.186/windows/x64, while trying to update values of fields directly / interactively through HMI, it failed.</p> <p>The problem is with mixed cases (lower and upper case) field names.<br/> If such field names are'nt protected with double quotes, the field name is considered in upper case.<br/> The field name with mixed cases is totally different with the "almost same" field name in uppercase.<br/> For instance, the table Fee declares a field name called "Price".<br/> If you try to update the value of "Price" field of the "Fee" table through HMI, the request sended to Oracle Server is :<br/> update "Fee" set Price=0.01 where ...<br/> But the request should be like :<br/> update "Fee" set "Price"=0.01 where ...</p> <p>KR,</p> <p>eraso</p></div>