Problem in update grid's item when using join in render_sql

Suite and Optimus Suite 5
#1

hello
when I using JOIN statement in my query it just load my items from db correctly but when I want to edit item in grid by double click on it or drag on drop it,it makes red and don’t store changes.
code of server side is like this:

<?php
	require_once("../config.php");
	$res=mysql_connect($mysql_server,$mysql_user,$mysql_pass);
	mysql_select_db($mysql_db);
	mysql_set_charset("UTF8", $res);

	require("../codebase/grid_connector.php");
	require("../codebase/xss_filter.php");
	$grid = new GridConnector($res);
	ConnectorSecurity::$security_key = true;
	$query="SELECT *
        FROM group_bank_question JOIN question ON question.id=group_bank_question.questionid";
	
	
	$grid->render_sql(
        $query,
        "id","id, name, content");
?>

please help me,thanks.

#2

This is expected
In case of complex SQL query for data selecting, you need to define a separate SQL for data saving or use your own code for data saving.

docs.dhtmlx.com/connector__php__ … omdatabase
docs.dhtmlx.com/connector__php__ … lexqueries