bytebeam
Posts: 6
|
Posted: 06/18/2018, 12:07 PM |
|
Since it seems that we have to maintain the product alive ourselves...
1) Exit the CCS IDE. Go to CCS install folder -> Components -> File TypeLib.xml
Edit the file by inserting after line 138 the following text:
<Item value="IContains" name="contains (ilike '%...%')"/>
2) In your project, in the file Classes.php,
After the following text: define("opNotBetween", 18);
Add just below: define("opIContains", 19);
After the followin text:
case opBeginsWith:
$Result = $FieldName . " like '" . $SQLValue . "%'";
break;
Add just below:
case opBeginsWith:
$Result = $FieldName . " ilike '" . $SQLValue . "%'";
break;
And after the following text:
case opContains:
$Result = $FieldName . " like '%" . $SQLValue . "%'";
break;
Add just below:
case opIContains:
$Result = $FieldName . " ilike '%" . $SQLValue . "%'";
break;
Finally, look for the following text:
case opContains:
case opIsNull:
And replace with:
case opContains:
case opIContains:
case opIsNull:
You should now be able to use the ILIKE operator in the DB Designer and generate correct SQL code for your project.
|
|
|
|