<?xml version="1.0" encoding="UTF-8" ?>
<jsp:root
	xmlns:jsp="http://java.sun.com/JSP/Page"
	xmlns:og="hybs-taglib.tld"
	version="2.0">
<jsp:directive.page language="java" contentType="text/html; charset=UTF-8" />

<og:head headType="result" />
<jsp:directive.include file="/jsp/custom/result_info.jsp" />
<og:comment
	system	= "GF:エンジンサンプル"
	pgid	= "GFX012"
	title	= "親子展開"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>
<og:columnCheck
	command   = "{@command}"
	columns   = "DEPTNO"
	nullCheck = "DEPTNO"
/>

<og:message lbl="{@lblKey}" /><br />

<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
	<jsp:text>
		select A.DEPTNO,A.DNAME,A.LOC,'{@EMPNO}' || ':' || A.DEPTNO as MANAGER
		from DEPT A inner join EMP B
		on    A.DEPTNO = B.DEPTNO
		where B.JOB    = 'MANAGER'
		and   B.DEPTNO = '{@DEPTNO}'
	</jsp:text>
</og:query>

<og:columnEditor column="MANAGER" must="true" editor="DBMENU" addNoValue="false" >
	<jsp:text>select EMPNO,ENAME from EMP where DEPTNO = '$2'</jsp:text>
</og:columnEditor>

<og:view
	viewFormType = "HTMLTable"
	command    = "{@command}"
	startNo    = "{@startNo}"
	checked    = "{@checked}"
	writable   = "true"
	columnWritable = "MANAGER"
	pageSize   = "{@pageSize}" />

<jsp:directive.include file="/jsp/common/htmlend.jsp" />
</jsp:root>
