Question Hieu Dien Nguyen · Nov 29, 2018 Special Char % in SQL Query Hello everyone,I try excuting a SQL Query like this SELECT ID, CompanyName FROM Company WHERE CompanyName LIKE 'condition' But if I want to search CompanyName have special char %, ex: '100% Co' , 'Group of Mr.%', 'The %TaxProp'...How can I take % to query, with #Caché #SQL 0 5 0 893
Question Hieu Dien Nguyen · Oct 4, 2018 Can't save Json String to SQL Table Hi everyone,I need submit a object have a json string as property of class, but I get an issue, object can't save to SQL table if I take json data to json property. I try making a test class with only json property and get the same issue, no data row in SQL table after run ClassMethod . Some one know what's problem, please help me. Here my test class: #JSON #Object Data Model #SQL #HealthShare 1 2 0 776
Question Hieu Dien Nguyen · Aug 23, 2018 Set value to Property's DISPLAYLIST, VALUELIST Hello Everyone, I have a healthshare web application with production, I try to make a field in basic setting of business service, and I would like to set a string to DISPLAYLIST and VALUELIST of that Property (string maked by query to sql table). I code the same here but it's syntax incorrect in DISPLAYLIST = GetTypeDisplay(), VALUELIST = GetTypeValue(). Someone know a best way to solved my problem? Thanks so much! #Business Service #Object Data Model #Ensemble 0 8 0 1.5K